title: Contains clause in SQL Server full-text search omits some matching rows
body: <p>I have a table called <code>Products</code> in a SQL Server 2014 database. A column <code>ProductName</code> in this table has a regular non-clustered index as well as a full-text index on it. 
  When I run the queries below, then the full-text search queries omit some of the rows that a LIKE clause includes.</p>
  
  <p><strong>Question</strong>: Why are the first two full-text queries not bringing up products that are returned by the LIKE query? My goal is to look for Products whose name contains <code>i2</code>.</p>
  
  <pre><code>SELECT p.ProductId, p.ProductName FROM Products p WHERE contains(p.ProductName, N'i2');
  SELECT p.ProductId, p.ProductName FROM Products p WHERE freetext(p.ProductName, N'i2');
  SELECT p.ProductId, p.ProductName  FROM Products p WHERE p.ProductName LIKE '%i2%';
  </code></pre>
  
  <p>The results that I am seeing from these queries is as in screenshot below.</p>
  
  <p><a href="https://i.stack.imgur.com/oHnsm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oHnsm.png" alt="Results of Full Text Search Vs LIKE Query in SQL Server 2014"></a></p>