title: Is that possible to use full text index to find closest match strings? What does Statistical Semantics do in Full Text Indexing
body: <p>I am looking for SQL Server 2016 full text indexes and they are awesome to make searches for finding multiple words containing strings</p>
  
  <p>When i try to compose the full text index, it shows <code>Statistical Semantics</code> as a tickbox. What does statistical semantics do?</p>
  
  <p>Moreover, I want to find did you mean queries</p>
  
  <p>For example lets say i have a record as <code>house</code>. The user types <code>hause</code></p>
  
  <p>Can i use full text index to return <code>hause</code> as closest match and show user did you mean house efficiently ? thank you</p>
  
  <p>I have tried soundex but the results it generates are terrible</p>
  
  <p>It returns so many unrelated words</p>
  
  <p>And since there are so many records in my database and i need very fast results, i need something SQL server natively supports</p>
  
  <p>Any ideas? Any way to achieve such thing with using indexes? </p>
  
  <p>I know there are multiple algorithms but they are not efficient enough for me to use online. I mean like calculating edit distance between each records. They could be used for offline projects but i need this efficiency in an online dictionary where there will be thousands of requests constantly.  </p>
  
  <p>I already have a plan in my mind. Storing not-found results in the database and offline calculating closest matches. And using them as cache. However, i wonder any possible online/live solution may exists? Consider that there will be over 100m nvarchar records </p>