title: Find same address with different spelling (Like abbreviation) with sql
body: <p>I want to find same address with different spelling/expression (abbreviation) example like below. But my query is not working. For example St--&gt;Street(correct) but Street--&gt;Streetict.
  Here is the code.</p>
  <pre><code>SELECT B_ADDRESS,H_ADDRESS, REGEXP_REPLACE(REGEXP_REPLACE(B_ADDRESS,'S[a-z]r.|(St.)','Street'),'(Dist.)|(Dt.)','Street') as B_NEW,
          REGEXP_REPLACE(REGEXP_REPLACE(H_ADDRESS,'(Str.)|(St.)','Street'), '(Dist.)|(Dt.)','District') as H_NEW
          FROM (
  
   SELECT H_ADDRESS,B_ADDRESS
                  FROM
                  ( 
                      SELECT 'Washington Str. No:60 ABD' AS H_ADDRESS,'Washington Street No60 ABD' AS B_ADDRESS FROM DUAL UNION ALL 
                      SELECT 'Pennsylvania Dt. St. No 6 ABD' AS H_ADDRESS,'Pennslyvania District Street No6 ABD' AS B_ADDRESS FROM DUAL UNION ALL
                      SELECT 'Onion Dist.  No 63 Kartal' AS H_ADDRESS,'Onion District No 61 Kartal' AS B_ADDRESS FROM DUAL
                  )
                  )
  </code></pre>
  <hr />
  <p>Thanks for helping.I wrote that code as below and It is working.</p>
  <pre><code> SELECT B_ADDRESS,H_ADDRESS,B_ADDRESS_C,H_ADDRESS_C,
   UTL_MATCH.jaro_winkler_similarity(B_ADDRESS_C,H_ADDRESS_C) AS JWS,
   UTL_MATCH.jaro_winkler(B_ADDRESS_C,H_ADDRESS_C) AS JW,
   UTL_MATCH.edit_distance_similarity(B_ADDRESS_C,H_ADDRESS_C) AS EDS,
   UTL_MATCH.edit_distance(B_ADDRESS_C,H_ADDRESS_C) AS ED
  
   FROM (
  
   SELECT H_ADDRESS,B_ADDRESS,
   INITCAP(REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(H_ADDRESS,'S[a- 
   zA-Z]{1,}|S[a-zA-Z]r|S[t]','Street'),'D[a-zA-Z]{1,}|D[a-zA-Z] 
   {1,}|D[a-zA-Z]','District'),'[.: ]',' ')) AS H_ADDRESS_C,
   INITCAP(REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(B_ADDRESS,'S[a- 
   zA-Z]{1,}|S[a-zA-Z]r|S[t]','Street'),'D[a-zA-Z]{1,}|D[a-zA-Z] 
   {1,}|D[a-zA-Z]','District'),'[.: ]',' '))  AS B_ADDRESS_C
  
  
              FROM
              ( 
                  SELECT 'Washington Str. No:60 ABD' AS 
   H_ADDRESS,'Washington Street No60 ABD' AS B_ADDRESS FROM DUAL UNION 
   ALL 
                  SELECT 'Pennslyvania Dt. St. No 6 ABD' AS 
   H_ADDRESS,'Pennslyvania District Street No6 ABD' AS B_ADDRESS FROM 
   DUAL UNION ALL
                  SELECT 'Onion Dist. No 63 Kartal' AS H_ADDRESS,'Onion 
   District No 61 Kartal' AS B_ADDRESS FROM DUAL
              )
              )
  </code></pre>