title: Sql server function for displaying word frequency in a column
body: <p>I have a table that lists a freet text input from a survey where enterents were allowed to enter their responses (regarding colours they would like to have in their wedding)</p>
  
  <p>I would like to write a sql function that gathers all the information from this column, and orders counts the frequency of each word, ordering the result set by this count.</p>
  
  <pre><code>Response
  --------
  Red and White
  green
  White and blue
  Blue
  Dark blue
  </code></pre>
  
  <p>I would like the above table to be ordered as follows</p>
  
  <pre><code>Response  Frequency
  --------  ---------
  Blue      3
  White     2
  And       2
  Red       1
  Green     1
  </code></pre>
  
  <p>I can strip all the rubbish words like "and" after the function has run. Does anyone know any good functions that produce this behaviour? </p>