We've faced a problem how FTS works with abbreviations. There are two rows with values "R.W. Mead & Sons" and "r.w. Mead & Sons1" in the full-text indexed column. The following query returns only "r.w. Mead & Sons1"
SELECT * FROM Table_Name WHERE CONTAINS ([Column_Name],N'"r.w. Mead*"')
How to do that the query returns both rows "R.W. Mead & Sons" and "r.w. Mead & Sons1"?
Microsoft SQL Server 2016 (SP2-CU15) is on a server. A stoplist is off for the index. LCID= 1033.
This is how data is saved in the index
r.w. Mead & Sons1
R.W. Mead & Sons
Any help is appreciated. Thanks!