title: Performance of like '%Query%' vs full text search CONTAINS query
body: <p>I have a situation where I would like to <strong>search a single word</strong>. </p>
  
  <p>For that scenario, which query would be good from a performance point of view?</p>
  
  <pre><code>Select Col1, Col2 from Table Where Col1 Like '%Search%'
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Select Col1, Col2 from Table Where Col1 CONTAINS(Col1,'Search')
  </code></pre>
  
  <p>?</p>