I am using the FullTextSearch feature on SQL Server. This feature let's you very efficiently search through text in a database. So I can do the following search:
SELECT * FROM MyTable WHERE CONTAINS(Notes, 'run')
Which will return the following records:
The boy will run.
The boy ran.
The boy is running.
So, FTS handles the tenses of the word run, and automatically returns all records with the word run, even if it's in a different tense. The problem is that now I have these three records, and I want to display the matching word - like this:
The boy will <b>run</b>.
THe boy <b>ran</b>.
The boy is <b>running</b>.
The problem is that from C# the only "word" I know about is run, and the 1st one is the only "simple" match that I can make on the word run.
I guess my question is - are there any free stemming/word matching/etc libraries for C# that would help me match the word run to ran and running like FTS does IN is C#?