title: Full-Text Search Not working (FREETEXT - CONTAINS)
body: <p>Freetext not return all of the words from table. And Contains not work </p>
  
  <p>I have a one row wich include in mycolumn="Life of a King"</p>
  
  <p>I tried 2 method;
  First "contains"</p>
  
  <pre><code>SELECT * FROM MYTABLE WHERE CONTAINS(MYCOLUMN,'Life NEAR of NEAR a NEAR King')
  </code></pre>
  
  <p>It returns NOTHING</p>
  
  <p>Second:</p>
  
  <pre><code>SELECT * FROM MYTABLE WHERE FREETEXT(MYCOLUMN,'Life of a King')
  </code></pre>
  
  <p>It returns 237 rows!
  which is ; </p>
  
  <blockquote>
    <p>"Life of Pie","It's a Wonderfull Life","The Lion King","King Arthur","Life Story","Life of a King" etc...</p>
  </blockquote>
  
  <p>I want to return row which only include "Life"+"of"+"a"+"King" words together.</p>
  
  <p>Thanks for replies!</p>