Find accented and non-accented variations of same word
<p>I have a database table which represent people and the records have people's names in them. Some of the names have accented characters in them. Some do not. Some are non-accented duplicates of the accented version.</p>

<p>I need to generate a report of all of the <em>potential</em> duplicates by finding names that are the same (first, middle, last) except for the accents so that someone else can go through this list and verify which are true duplicates, and which are actually different people (I'm assuming they have some other way of knowing).</p>

<p>For example: <code>Jose DISTINCT-LAST-NAME</code> and <code>José DISTINCT-LAST-NAME</code> should be picked up as potential duplicates because they have the same characters, but one has an accented character.</p>

<p>How can this type of query by written in MySQL?</p>

<hr>

<p>This question: <a href="https://stackoverflow.com/questions/4813620">How to remove accents in MySQL?</a> is not the same. It is asking about de-accenting strings in-place and the poster already has a second column of data that has been de-accented. Also, the accepted answer to that question is to set the character set and collation. I have already set the character set and collation.</p>

<p>I am trying to generate a report that finds strings in <em>different</em> records that are the same except for their accents.</p>