I take it you mean how does sql fts know how to stem words, so foot returns
foot and feet.
Basically these are hard coded in the word breakers and you can't dig into
the dll to find the stems. Most of the stemming is done according to language
rules. Have a look at morphems to understand the technology behind it.
"ruben" wrote:
> Hi,
>
> I´m working on my university senior project about a Search Engine and I
> ´m using SQL08 Full-Text.
> I´m trying to get all the inflectional forms for all words for an
> improvement.
> Using this:
>
> SELECT * FROM sys.dm_fts_parser(N'FORMSOF(INFLECTIONAL, "foot")',
> 1033, null, 1);
>
> I get all the forms, but I need to know the word "foot" and this is a
> dynamic function.
> Is there any way to know the TABLE where are stored all the
> inflectional words?
>
> Thanks.
>
> Ruben.
>
>> Stay informed about: Inflectional forms