sql server full text search: Highlight Results from search -- sql server full text search

Highlight Results from search

guate911
5/17/2007 10:02:10 AM

sql server full text search: [quoted text, click to view]
its query results hits in a highlighted format. I was able to
programmatically get this working for simple searches, where I simply
do a find and replace based on the search criteria. But this will not
work for plural results or irregular type finds. For example, if I do
a search for "mouse", and sql server returns "mice", I have no way of
knowing to highlight "mice". I read that this can be done using
lemmatizer and stemmer algorithms. Is there an easier way of doing
this? If not, does anyone know of any .net api's or code I can get
started with?

Thanks

Re: Highlight Results from search

Hilary Cotter
5/23/2007 12:00:00 AM

You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.

http://www.indexserverfaq.com/sqlhithighlighting.htm

[quoted text, click to view]