title: Oracle Find duplicate records that are similar but aren't exact matches
body: <p>I'm trying to find a way to search a text field to identify rows that could be similar so I can identify if they are duplicates that should be merged. For example if my data looks like this:</p>
  
  <p><strong>MyText_Column</strong></p>
  
  <ol>
  <li>Bob</li>
  <li>Bobby</li>
  <li>Robert</li>
  <li>Jane</li>
  <li>Janey</li>
  <li>Janie</li>
  <li>Joe</li>
  <li>John</li>
  <li>Johnathan</li>
  </ol>
  
  <p>A GROUP BY won't work because none of the values are exactly the same, but if I could have a query that would return a list of the likelihood that one row is similar would be great. Maybe there's a better layout but what I am imagining is a result like this:</p>
  
  <p><strong>Query Result</strong></p>
  
  <p>Search Compare Likely_Match</p>
  
  <ol>
  <li>Bob    Bobby   96%</li>
  <li>Bob    Robert  12%</li>
  <li>Bob    Jane    0%</li>
  <li>Bob    Janey   0%</li>
  <li>.....</li>
  <li>Jane   Janey   87%</li>
  <li>Jane   Janie   69%</li>
  <li>Jane   Joe     12%</li>
  </ol>
  
  <p>Then with result like that I could sort by likelihood and and visually scan to determine if the results are duplicates or not.</p>