title: SQL Server FREETEXTTABLE minimum length
body: <p>I'm getting no results when using a FREETEXTTABLE query when my search string is only 3 characters in length (when its 4 it returns results).
  Below is the code I'm running when it returns results, but if I change my search term to 'gol' it returns no results.</p>
  
  <pre><code>DECLARE  @strSearchWords varchar(500)   = 'golf'
  SELECT sku, title
  FROM products AS p INNER JOIN
      FREETEXTTABLE(products, title, @strSearchWords) AS search_table
      ON p.product_id = search_table.[KEY]
  ORDER BY 
      search_table.RANK DESC
  </code></pre>
  
  <p>I'm sure its most likely a database setting but I've not been able to find anything referencing it. or is it just too broad a search for it to find any matches?</p>