title: How to find address that are shorthand or standard version? N or North, NW or NorthWest
body: <p>Court or CT
  Lane or LN
  Boulevard or BLVD, etc</p>
  
  <p>Is there a api that will sanitize a database into shorthand, or someway to clean a database so that when I do a search query I can find the address?</p>
  
  <p>Currently I do:</p>
  
  <pre><code>WHERE prod.street_num = new.street_num AND prod.street_name LIKE (CONCAT('%',new.street_name,'%'))
  </code></pre>