Knowledgebase & FAQ

RecFind 6 Text Search Synonym Configuration

Text searches performed within RecFind 6 v2.3 and higher will automatically use the Microsoft SQL Server Thesaurus if its configured. The Microsoft SQL Server Thesaurus feature allows you to configure synonyms that are to be used during text searches. For example, you can configure the system to search for records containing "color" and "colour" when a user searches for either term.

Please note that configuring the Microsoft SQL Server Thesaurus is a database administrator (IT) function - not a RecFind 6 application administrator function.

Details on configuring the SQL Server Thesaurus can be found at:
http://msdn.microsoft.com/en-us/library/ms345187.aspx, and
http://msdn.microsoft.com/en-us/library/ms142491.aspx

Please note that searching for text using a metadata or boolean search does not use the SQL Server full text index and therefore it will not utilise any Thesaurus/Synonym configuration you implement. The EDOC.Image field is the only exception.

To summarise the above Microsoft articles:

1. Using Notepad open the tsglobal.xml file from your Microsoft SQL Server installation's FTDATA folder (eg. C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTData\tsglobal.xml).
   
   Note: There are also language specific Thesaurus files however for simplicity in this example we are modifying the global thesaurus, meaning that it will apply to all languages.
    

2. Add your synonyms as required, for example:

   <XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml"> <diacritics_sensitive>0</diacritics_sensitive>     <expansion>         <sub>K1</sub>         <sub>Knowledgeone Corporation</sub>         <sub>K1 Corp</sub>     </expansion>     <expansion>         <sub>organisation</sub>         <sub>organization</sub>     </expansion>     <expansion>         <sub>color</sub>         <sub>colour</sub>     </expansion> </thesaurus> </XML>

   Save your changes to the tsglobal.xml file.
    

3. From SQL Server Management Studio run the following query to load the Thesaurus file changes:

   EXEC sys.sp_fulltext_load_thesaurus_file 0;

   where 0 is the LCID of the language, or 0 for the global thesaurus.

» Back to FAQ index