How to do partial match in full-text search in SQL Server

Question

I have a list of places, e.g "Auckland", "Wellington".

My current implementation, won't return these rows if "Auck" or "Welli" is typed.

I am using full-text search, (as there are 30 million rows), and using:

CONTAINSTABLE([Table], [Field], 'Auck')

This works great, but how can I get it to do partial matches whilst using my full-text index?

score 2 · Answer 1 · answered Jul 01 '19 at 14:55

2

I have used the following for partial matches on full-text indexed columns.

SELECT * FROM [Table] WHERE CONTAINS([Field], '"*Auck*"');

Same applies for CONTAINSTABLE

SELECT * From CONTAINSTABLE([Table], [Field], '"*Auck*"');

answered Jul 01 '19 at 14:55

obaylis

score 0 · Answer 2 · answered Apr 11 '15 at 03:25

0

How about

CONTAINSTABLE([Table], [Field], 'Auckland OR "Auck*"')

answered Apr 11 '15 at 03:25

TavoloPerUno

Did you include Auck*? – TavoloPerUno Apr 21 '15 at 06:35
@TavoloPerUno, Why we need 'Auckland OR "Auck*"', if we only type '"Auck*"' ? – MUHAMMAD TASADDUQ ALI Oct 31 '16 at 12:19

2 Answers2