Hi,
Is there a way to get a list (programmatically) of the words that SQL Server
expands a user’s search word to for inflectional search?
Example:
1. User searches “run”
2. Inflectional search finds a document with the word “ran” (different tense)
3. I want to display the word that was actual found, i.e. “ran”
Is it possible to have SQL Server tell me that “run” expands to “ran”, etc?
Also, but of less importance, is it possible to have SQL Server tell me what
word was found in a document?
Example:
Text being searched over: “The quick brown fox…”
Search query: “quick OR slow”
Is there a way to have SQL Server tell me that “quick” was found in a given
text record?
I haven’t been able to find anything about this on the internet. Thanks a
bunch!
Hilary Cotter - 30 Jun 2008 20:30 GMT
Not in SQL 7, 2000, or 2005. In SQL Server 2008 there is the
sys.dm_fts_parser which will show you how words are stemmed.
> Hi,
>
[quoted text clipped - 24 lines]
> I haven’t been able to find anything about this on the internet. Thanks a
> bunch!