title: Rearrange the characters in a string alphabetically using SQL
body: <p>I am looking to take a string field and rearrange the characters into alphabetical order.  For example, if it was a name field and the name was MICHAEL SMITH it would change to ACEHHIILMMST.</p>
  
  <p>The main purpose is to look for duplicates in a field like name where someone could have made a typo and put in the name as MICHEAL SMITH or MICHAEL SMTIH.  Another option I thought of would be to assign a number value to each letter (1-26) and then if the sum of those values and the length of the name field are the same it would be considered a duplicate.  Problem with that is I do not know how to sum up numbers in a string field.</p>
  
  <p>Also, I am using Oracle SQL so the functions would be based on those available.</p>
  
  <p>Any ideas or at least places to start?</p>
  
  <p><em><strong>EDIT</em></strong></p>
  
  <p>I am not trying to ask for the code for how to do this, I am asking more if it is possible or not and if possible, what would my starting place be (types of functions, techniques, etc)</p>