title: SQL Server similar function like with postgres
body: <p>Does SQL Server have an equivalent function to Postgres Similar to compare strings? </p>
  
  <p>I looking for something that will match </p>
  
  <pre><code>str1 = "Flat 1, 110 Bob Street" 
  str2 = "110, Bob St. Flat 1" 
  </code></pre>
  
  <p>so I can do</p>
  
  <pre><code>select
  ...
  from
  t1 join 
  t2  on (similar(t1.str1,t2.str2) &gt;= 0.9)
  </code></pre>