title: How to do partial match in full-text search in SQL Server
body: <p>I have a list of places, e.g <em>"Auckland"</em>, <em>"Wellington"</em>.</p>
  
  <p>My current implementation, won't return these rows if "Auck" or "Welli" is typed.</p>
  
  <p>I am using full-text search, (as there are 30 million rows), and using:</p>
  
  <pre><code>CONTAINSTABLE([Table], [Field], 'Auck')
  </code></pre>
  
  <p>This works great, but how can I get it to do partial matches whilst using my full-text index?</p>