title: Sql Server Soundex Name search - find shortened form of a name
body: <p>I would like to allow my app to search for names and return similar first names. I.e. if the user searches for John, Jonathan's should be returned as well.</p>
  
  <p>A Soundex search does not seem to do this. Are there any alternatives other than storing a dictionary of related names?</p>