Full-Text Search -- What Thesaurus does it use??


  • can't find a full-text search forum .. decided to post it here...

    Here's what I find in documentation on FREETEXT

  • Generates inflectional forms of the words (stemming).
  • Identifies a list of expansions or replacements for the terms based on matches in the thesaurus.

     Question: which thesaurus does it use?? Because it definitely doesn't pick up on synonyms from the Office thesaurus..

Friday, June 17, 2005 7:12 PM


  • nevermind... found the expansion/ignore files in
    \Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\
    Friday, June 17, 2005 8:14 PM