Searching
Although the indexer launches word breakers and filters as out-of-process SQL Server components, the search process is entirely within the SQL Server engine. To query the full-text indexes, you need to use CONTAINS or FREETEXT predicates or their rowset analogs (CONTAINSTABLE, FREETEXTTABLE).
Just as the indexer applies the default server full-text language for indexing, it also applies the default full-text language for searching. Consider a search on the French word courir (to run). If you were to search in English on this word, it would search on courir and courirs. However, on a server with the default full-text language setting for French, your search would be conducted on couraient, courais, courait, courant, coure, courent, ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
