| title | Behavior Changes in Full-Text Search | ||||
|---|---|---|---|---|---|
| titleSuffix | SQL Server Full-Text Search | ||||
| description | Learn about behavior changes in SQL Server full-text search features. | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 01/12/2026 | ||||
| ms.service | sql | ||||
| ms.subservice | search | ||||
| ms.topic | concept-article | ||||
| helpviewer_keywords |
|
||||
| monikerRange | >=sql-server-linux-ver17 || >=sql-server-ver17 |
This article describes behavior changes in full-text search. Behavior changes affect how features work or interact in recent versions of [!INCLUDE ssnoversion-md] as compared to earlier versions.
[!INCLUDE sssql25-md] replaces legacy word breakers and filters with new and enhanced binaries. To use the new components, rebuild your existing full-text indexes.
[!INCLUDE sssql25-md] adds support for full-text indexing in three new languages:
- Finnish (LCID 1035)
- Hungarian (LCID 1038)
- Estonian (LCID 1061)
[!INCLUDE sssql25-md] adds support for indexing the following document extensions by default.
| Filter | Extension |
|---|---|
msgfilt02.dll |
.msg |
odffilt02.dll |
.odp, .ods, .odt |
offfilt02.dll |
.doc, .dot, .obd, .obt, .pot, .pps, .ppt, .xlb, .xlc, .xls, .xlt |
offfiltx02.dll |
.docm, .docx, .dotx, .pptm, .pptx, .xlsb, .xlsm, .xlsx, .zip |
onfilter02.dll |
.one |
New components in [!INCLUDE sssql25-md] might return unexpected results to applications. For example, consider the English (LCID 1033) word breaker:
| Term | Results with previous word breaker | Results with new word breaker |
|---|---|---|
cat_dog |
cat_dog |
cat_dogcatdog |
$100 |
$100nn100usd |
\$100nn100\$ |
2026-01-09 |
2026-01-092026nn20260109 |
2026-01-09dd2026010920260109 |