Full Text Search - Thesaurus help (is there an already "pre-filled" thesaurus?)

  • We have implemented Full Text Search on our system. The only thing is missing is the Thesaurus. The one that comes with SQL Server has a "sampling" of a few words. We would like to implement a Thesaurus of basically all the English words and their synonyms - so "car" replaces "auto", etc. But I cannot find any way of either downloading a "pre-filled" XML file that I can simply plug in instead of the other one, which contains the thousands of words, or a way to get some thesaurus in a table and import that into the XML.

    Is there any way to get a "ready out of the box" thesaurus file out of the box or can I only edit it word by word (which is not feasible to add hundreds of thousands of words).

    Any help is greatly appreciated.

  • I think you have to define and create it for both 2005 and 2008, the links below will help you with Full Text Thesaurus.

    http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/

    http://msdn.microsoft.com/en-us/library/ms142491.aspx

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply