Highlight words from search expression

Hi,
I want to create a search engine which will display a short text
description in the surrounding of the searched words. The problem is I
can't find the exact words in my search phrase in the results because
of stemming. Is there any way I can which words in the results were
responsible finding this particular result due to stemming?
Thanks,
Lior
Microsoft's stemming algorithm is based on the Ported Stemming algorithm.
You can roll your own implementation of this, or something like this
http://www.indexserverfaq.com/sqlhithighlighting.htm
"Lior Shorshi" <lishorsh@.gmail.com> wrote in message
news:1177242161.666784.11460@.y5g2000hsa.googlegrou ps.com...
> Hi,
> I want to create a search engine which will display a short text
> description in the surrounding of the searched words. The problem is I
> can't find the exact words in my search phrase in the results because
> of stemming. Is there any way I can which words in the results were
> responsible finding this particular result due to stemming?
> Thanks,
> Lior
>

High Light Words in Query

I creating an SQL script that will query a database and return the results to an html page. The script searches for a keyword and then displays the results. What I want to do is when the result is returned, I want to highlight the word that was being searched in the result set. I would like the word to be bolded in the query. How can this be done?please, don't cross-post

see http://www.dbforums.com/t1100603.html