title: MySQL street address fuzzy search
body: <p>Does anyone know of a good script (or good strategy) for doing a fuzzy street address search on a MySQL database? The key issues are:</p>
  
  <ul>
  <li>capitalization (easy -- just use LCASE)</li>
  <li>punctuation (could use REPLACE; not sure it there are more efficient options)</li>
  <li>abbreviations (this is the tough one -- street = st, etc.)</li>
  </ul>
  
  <p>I want to be able to match:
  123 Main st, unit B = 123 Main Street Unit b</p>