A separate file is provided for each supported language. Setup installs empty thesaurus files in the above location. This default location contains the following files: The default location of the thesaurus files is: They contain only the top-level XML structure that is common to all SQL Server thesauruses and a commented-out sample thesaurus. SQL Server provides a set of XML thesaurus files, one for each supported language. By default, a thesaurus is accent-insensitive. If the thesaurus is accent-sensitive, full-text search replaces only the pattern 'café'. If the thesaurus is accent-insensitive, full-text search replaces the patterns 'café' and 'cafe'. For example, suppose you specify the pattern 'café' to be replaced by other patterns in a full-text query. For an example, see the section XML Structure of a Replacement Set later in this topic.įor a given thesaurus, all search patterns are either sensitive or insensitive to diacritical marks such as a tilde ( ~), acute accent mark ( ´), or umlaut ( ¨) (that is, accent sensitive or accent insensitive). Queries that contain a match for any synonym in an expansion set are expanded to include every other synonym in the expansion set.įor more information, see XML Structure of an Expansion Set later in this topic.Ī replacement set contains a text pattern to be replaced by a substitution set.

Each thesaurus must be manually configured to define the following:Īn expansion set contains a group of synonyms such as 'writer', 'author', and 'journalist' that are substituted for one another by a full-text query. What's in a thesaurusīefore full-text search queries can look for synonyms in a given language, you have to define thesaurus mappings (that is, synonyms) for that language. Thesaurus matching occurs for all FREETEXT and FREETEXTABLE queries and for any CONTAINS and CONTAINSTABLE queries that specify the FORMSOF THESAURUS clause.Ī Full-Text Search thesaurus is an XML text file. By developing a thesaurus tailored to your full-text data, you can effectively broaden the scope of full-text queries on that data. Each thesaurus defines a set of synonyms for a specific language. SQL Server Full-Text Search queries can search for synonyms of user-specified terms through the use of a Full-Text Search thesaurus. Applies to: SQL Server (all supported versions)

What is another word for thesaurus ms