title: Search for words in SQL Server index
body: <p>I need something in between a full text search and an index search:<br>
  I want to search for text in one column of my table (probably there will be an index on the column, too, if that matters).</p>
  
  <p>Problem is, I want to search for words in the column, but I don't want to match parts.  </p>
  
  <p>For example, my column might contain business names:<br>
    <em>Mighty Muck Miller and Partners Inc.<br>
    Boy &amp; Butter Breakfast company</em>  </p>
  
  <p>Now if I search for "<em>Miller</em>" I want to find the first line. But if I search for "<em>iller</em>" I don't want to find it, because there is no word starting with "iller". Searching for "<em>Break</em>" should find "<em>Boy &amp; Butter Breakfast company</em>", though, since one word is starting with "<em>Break</em>".</p>
  
  <p>So if I try and use </p>
  
  <pre><code>WHERE BusinessName LIKE %Break%
  </code></pre>
  
  <p>it will find too many hits.</p>
  
  <p>Is there any way to Search for Words separated by whitespace <strong>or other delimiters</strong>? </p>
  
  <p>(LINQ would be best, plain SQL would do, too)</p>
  
  <p><strong>Important:</strong> Spaces are by far not the only delimiters! Slashes, colons, dots, all non-alphanumerical characters should be considered for this to work!</p>