title: SQL count string matches in each row
body: <p>Please take a look at this simple SQL server database :
  <img src="https://i.stack.imgur.com/lihd6.png" alt="database"></p>
  
  <p>What I want is, I want to create a summary with only 3 column, here is the code:</p>
  
  <pre><code>select ProductID, Name,
         *code* as CountString
  from product
  where Name in ('this', 'is', 'count', 'example')
  </code></pre>
  
  <p>I want the result to have 3 column, and the column "CountString" is the total number of string that matches ('this','is', 'count', 'example'). Here is the result I want :</p>
  
  <p><a href="https://i.stack.imgur.com/82TaQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/82TaQ.png" alt="Result"></a></p>
  
  <p>So for example, I want the Countstring for ProductID 1 is 4, because it contains all of 4 words.</p>
  
  <p>If you can solve this, it would be amazing!</p>