title: Term order in FREETEXTTABLE in SQL Server
body: <p>From the documentation, it seems that SQL Server's FREETEXTTABLE should treat a search query containing multiple words as a bag-of-words.</p>
  
  <p>If I run:</p>
  
  <pre><code>SELECT *
  FROM FREETEXTTABLE(tblThings, *, 'Cartridge Black')
  </code></pre>
  
  <p>I get results where the word 'Cartridge' is immediately followed by the word 'Black', e.g.:</p>
  
  <pre><code>EPSON STYLUS INKJET CARTRIDGE BLACK
  INKJET CARTRIDGE BLACK 40ML
  </code></pre>
  
  <p>No results have the words in the other order.</p>
  
  <p>If instead I run</p>
  
  <pre><code>SELECT *
  FROM FREETEXTTABLE(tblThings, *, 'Black Cartridge')
  </code></pre>
  
  <p>I get a different set of results:</p>
  
  <pre><code>AD1020BK BLACK CARTRIDGE
  GD230X BLACK CARTRIDGE
  </code></pre>
  
  <p>In neither set of results would I find 'black ink cartridge'.</p>
  
  <p>Is there a way to make SQL Server disregard the order of the words?</p>