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?