"MattIrwin via SQLMonster.com" <u28166@uwe> wrote in message
news:6926b9c20e067@uwe...
> Hi,
> I need to search a Items catalog that has a field that is key word
> seperated by commas. Would a fulltext search be more productive than a
> like
> searcn. If the use keys in Bic Black Pens then that is all it should
> bring
> up but if they key in pens it should only get pens. With the like I have
> been
> getting despensers. I don't know exactly how Fulltext search would work
> for
> this.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-search/200611/1
>

> Hi,
> I need to search a Items catalog that has a field that is key word
> seperated by commas. Would a fulltext search be more productive than a
> like
> searcn. If the use keys in Bic Black Pens then that is all it should
> bring up but if they key in pens it should only get pens. With the
> like I have been getting despensers. I don't know exactly how Fulltext
> search would work for this.
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:uo8ZEAyBHHA.4892@TK2MSFTNGP04.phx.gbl...
> Full text for English will break words at white space. So bic black pen
> would be broken as three words, bic, black and pen. Dispensers would be
> broken as dispensers. In a free text search this would match with
> dispensers, dispenser, dispenser's, and dispensers.

"Allan Ebdrup" <ebdrup@noemail.noemail> wrote in message
news:%23aVerjWNHHA.3424@TK2MSFTNGP02.phx.gbl...
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:uo8ZEAyBHHA.4892@TK2MSFTNGP04.phx.gbl...
>> Full text for English will break words at white space. So bic black pen
>> would be broken as three words, bic, black and pen. Dispensers would be
>> broken as dispensers. In a free text search this would match with
>> dispensers, dispenser, dispenser's, and dispensers.
>
> I would like to do the opposite.
> When searching for "pædagog" I also want to return results that contain
> "dagplejepædagog" or "pædagogmedhjælper" is ther no other way to
> accomplish this than using LIKE '%pædagog%'.
> Performance using LIKE is very poor, how do I improve performance?
>
> Kind Regards,
> Allan Ebdrup
>

"tbh" <femdev@newsgroups.nospam> wrote in message
news:%23rGPgouOHHA.3544@TK2MSFTNGP03.phx.gbl...
> "Greek"? looks a bit more like a scandinavian language, doesn't it? :)
>
> i think Allan is looking for inflectional forms or compound words
> containing a stem-word in question. i'm interested too (in my case for
> German).
>
> can anyone point us to good documentation on which languages are supported
> and other details? there is some info here:
> http://msdn2.microsoft.com/en-US/library/ms142507.aspx
>
> but i would want to learn more.
>
> cheers,
>
> Tim Hanson
>
>

> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:uo8ZEAyBHHA.4892@TK2MSFTNGP04.phx.gbl...
>> Full text for English will break words at white space. So bic black pen
>> would be broken as three words, bic, black and pen. Dispensers would be
>> broken as dispensers. In a free text search this would match with
>> dispensers, dispenser, dispenser's, and dispensers.
>
> I would like to do the opposite.
> When searching for "pædagog" I also want to return results that contain
> "dagplejepædagog" or "pædagogmedhjælper" is ther no other way to
> accomplish this than using LIKE '%pædagog%'.
> Performance using LIKE is very poor, how do I improve performance?