SQL Server 2008 FullTextSearch No single character in name in results

Question

I have a full text indexing column in SQL Server 2008 that has the following rows:

W Smithers, Wilda Smithers, W2 Smithers

When I run the following query, I return only to Wilda Smithers and W2 Smithers.

SELECT FT_TBL.full_name as results FROM dbo.ft_table AS FT_TBL WITH (NOLOCK) INNER JOIN CONTAINSTABLE (ft_table , full_name, '("w*" AND "smither*")',12) AS KEY_TBL ON FT_TBL.ft_key_id = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK desc 

Any suggestions on how to tweak this so W Smithers is also in my result set?

Answer 1

W is probably a stop word. Try removing it from the list.

See how it's done: Set up and manage stop words and stop lists for full-text search

EDIT

Try to recreate the FT index, but this time do not list the stops at all.