Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
This article describes the legacy procedure for switching US English and UK English word breakers between the updated components introduced in SQL Server 2012 (11.x) and the previous English components.
For information about the full-text index version change in SQL Server 2025 (17.x), see Full-text index version upgrade.
Applies to: SQL Server 2022 (16.x) and earlier versions.
SQL Server 2012 (11.x) installs an updated version of the word breaker and stemmer for the English language, replacing the previous version of these components. For information about the changed behavior of the updated components, see Behavior changes in Full-Text Search.
This article describes how to switch from the updated version of these components to the previous version, or to switch back from the previous version to the updated version. For cluster installations, make these changes on all nodes.
Some previous versions of SQL Server used different word breakers represented by different CLSIDs for US English (LCID 1033) and UK English (LCID 2057). In SQL Server 2012 (11.x) and later versions, both locale identifiers (LCIDs) use the same components with the same CLSIDs, as shown in the following table:
| LCID | Word breaker installed by previous versions (version 12.0.6828.0) | Stemmer installed by previous versions | Word breaker installed with SQL Server 2012 and higher versions (version 14.0.4999.1038) | Stemmer installed with SQL Server 2012 and higher versions |
|---|---|---|---|---|
1033 (US English) |
188d6cc5-cb03-4c01-912e-47d21295d77e |
eeed4c20-7f1b-11ce-be57-00aa0051fe20 |
9faed859-0b30-4434-ae65-412e14a16fb8 |
e1e5ef84-c4a6-4e50-8188-99aef3de2659 |
2057 (UK English) |
173c97e2-aebe-437c-9445-01b237abf2f6 |
d99f7670-7f1a-11ce-be57-00aa0051fe20 |
9faed859-0b30-4434-ae65-412e14a16fb8 |
e1e5ef84-c4a6-4e50-8188-99aef3de2659 |
The components described in this article are DLL files that are installed in the MSSQL\Binn folder for the SQL Server instance. The full path is typically C:\Program Files\Microsoft SQL Server\<instance>\MSSQL\Binn.
For more information about word breakers and stemmers, see Configure and manage word breakers and stemmers.
Switch from the current English word breaker to the previous English word breakers
This example uses MSSQL17.MSSQLSERVER for the <InstanceRoot> value, which is the default instance for SQL Server 2025 (17.x). Adjust this value to match your environment.
The following commands add or update keys in the Windows registry, to set the COM ClassIDs for the previous US English word breaker and stemmer interfaces for LCID 1033 (enu).
Run these commands from an elevated command prompt:
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\CLSID\{188D6CC5-CB03-4C01-912E-47D21295D77E}" /ve /t REG_SZ /d "langwrbk.dll"
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\CLSID\{EEED4C20-7F1B-11CE-BE57-00AA0051FE20}" /ve /t REG_SZ /d "infosoft.dll"
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\Language\enu" /v "WBreakerClass" /t REG_SZ /d "{188D6CC5-CB03-4C01-912E-47D21295D77E}" /f
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\Language\enu" /v "StemmerClass" /t REG_SZ /d "{EEED4C20-7F1B-11CE-BE57-00AA0051FE20}" /f
Restart SQL Server to use these word breaker settings.
Switch back from the previous English word breakers to the current English word breaker
This example uses MSSQL17.MSSQLSERVER for the <InstanceRoot> value, which is the default instance for SQL Server 2025 (17.x). Adjust this value to match your environment.
The following commands add or update keys in the Windows registry, to set the COM ClassIDs back from US English for LCID 1033 (enu).
Run these commands from an elevated command prompt:
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\CLSID\{9FAED859-0B30-4434-AE65-412E14A16FB8}" /ve /t REG_SZ /d "MsWb7.dll"
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\CLSID\{E1E5EF84-C4A6-4E50-8188-99AEF3DE2659}" /ve /t REG_SZ /d "MsWb7.dll"
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\Language\enu" /v "WBreakerClass" /t REG_SZ /d "{9FAED859-0B30-4434-AE65-412E14A16FB8}" /f
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSearch\Language\enu" /v "StemmerClass" /t REG_SZ /d "{E1E5EF84-C4A6-4E50-8188-99AEF3DE2659}" /f
Restart SQL Server to use these word breaker settings.