Customize behavior of word breakers with a custom dictionary (SQL Server Search)

Applies to: SQL Server

You can customize the behavior of the word breaker for a particular language by creating a language-specific custom dictionary file. For example, you can prevent the word breaker from breaking certain terms or patterns.

For more information, see the following SharePoint article:

Create a custom dictionary (SharePoint Server 2010)

For SQL Server, place custom dictionary files in the following folder:

C:\Program Files\Microsoft SQL Server\<instance name>\MSSQL\Binn

After creating or changing custom dictionary files, restart the SQL Full-text Daemon Launcher with the following command:

exec sp_fulltext_service 'restart_all_fdhosts'