sql server full text search: hit locations in full text -- sql server full text search

hit locations in full text

madmik3 NO[at]SPAM gmail.com
9/28/2006 10:08:37 AM

sql server full text search: I'm working on an aplication that could benefit from having the hit
location inside of a column. For example

A Column has

"United Stated Education System : Educational Stuff"

The full text search might match Education and Edicational from the
word eudcation. But I can not see any clear way to determine what
word(s) were matches and how they were used in the ranking. Is there
any known way to do this?

Thanks,
madmike

Re: hit locations in full text

Hilary Cotter
9/28/2006 2:05:27 PM

No, you have to implement a version of Porter Stemming algorithm to do
something like this.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]