Highlight Results from search

>From what I have so far, Sql Server does not provide a way to return
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
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
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179421330.863970.28850@.p77g2000hsh.googlegro ups.com...
> 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
>
sql