Link to home
Start Free TrialLog in
Avatar of kalliopi
kalliopi

asked on

Stemming/Word matching library for C#...

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#?

Thanks.

EJ
ASKER CERTIFIED SOLUTION
Avatar of ShazbotOK
ShazbotOK
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kalliopi
kalliopi

ASKER

That is EXACTLY what I was looking for!  If I could give you an A+ I would have.  Thank you!