title: SQL pattern matching
body: <p>I have a question related to SQL. </p>
  
  <p>I want to match two fields for similarities and return a percentage on how similar it is. </p>
  
  <p>For example if I have a field called doc, which contains the following</p>
  
  <pre><code>This is my first assignment in SQL 
  </code></pre>
  
  <p>and in another field I have something like</p>
  
  <pre><code>My first assignment in SQL 
  </code></pre>
  
  <p>I want to know how I can check the similarities between the two and return by how much percent. </p>
  
  <p>I did some research and wanted a second opinion plus I never asked for source code. Ive looked at Soundex(), Difference(), Fuzzy string matching using Levenshtein distance algorithm. </p>