title: Sql Select similar text
body: <p>I have a table Team</p>
  
  <pre><code>Id  Name ...
  1    Chelsea
  2    Arsenal
  3    Liverpool 
  </code></pre>
  
  <p>Now I need to search if my team table has a name like "Chelsea FC". How could I make a select query in this case when search string may have extra words ?</p>
  
  <p>I could try Lucene.net but it's kind of overkill just for a small usage and it would take time to learn it.</p>