title: Select query where in with partial match
body: <p>I would like to select all rows from <code>[Column]</code> that have within their string the words in a list as so:</p>
  
  <pre><code>select [Column]
  from [db]
  where [Column] like '%some%' or 
        [Column] like '%word%' or
        [Column] like '%and%' or
        [Column] like '%another%' 
  </code></pre>
  
  <p>However, as I have a long list of words, I do not want to repeat the <code>or [Column] like '%%'</code>. Is there a better way to write this? I am using SQL Server Management Studio.</p>