Behavior changes in Full-Text Search

This article describes behavior changes in full-text search. Behavior changes affect how features work or interact in recent versions of SQL Server as compared to earlier versions.

Behavior changes in Full-Text Search in SQL Server 2025

SQL Server 2025 (17.x) replaces legacy word breakers and filters with new and enhanced binaries. To use the new components, rebuild your existing full-text indexes.

Support for new languages

SQL Server 2025 (17.x) adds support for full-text indexing in three new languages:

Finnish (LCID 1035)
Hungarian (LCID 1038)
Estonian (LCID 1061)

Support for default document extension indexing

SQL Server 2025 (17.x) 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`

Unexpected results

New components in SQL Server 2025 (17.x) 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_dog` `cat` `dog`
`$100`	`$100` `nn100usd`	`\$100` `nn100\$`
`2026-01-09`	`2026-01-09` `2026` `nn2026` `01` `09`	`2026-01-09` `dd20260109` `2026` `01` `09`

Feedback

Was this page helpful?

Last updated on 2026-01-14

Share via

Behavior changes in Full-Text Search