title: Finding text similarities between row values in excel
body: <p>Lets say I have 9 rows of records. Each 3 rows have the same value. For instance:</p>
  
  <pre><code>Mike  
  Mike  
  Mike  
  John  
  John  
  John  
  Ryan  
  Ryan  
  Ryan
  </code></pre>
  
  <p>Is there a way I can search for similarities of these records? For example spelling mistakes, additional characters, missing characters, etc. So, for example, the correct version is <code>Mike</code>, but there might be a record down in the list with value <code>Mke</code> which is incorrect (spelling mistake). How can I find this and replace it with the correct one? </p>
  
  <p>The above example is obviously simplified. I actually have ~1mln rows. Right now to achieve the 'grouping' of the elements I just sort them alphabetically. </p>