title: Address standardization within a database
body: <p>Working in MS Access 2013. Have a ton of locations/addresses which need to be standardized.</p>
  
  <p>Examples include addresses like:</p>
  
  <ul>
  <li>500 W Main St</li>
  <li>500 West Main St</li>
  <li>500 West Main Street</li>
  </ul>
  
  <p>You get the point.</p>
  
  <p>I've considered running a query that pulls all records where the left(7) or something characters exist more than once in the database, but there are obvious flaws in that logic.</p>
  
  <p>Is there a function or query or anything else that would help me generate a list of records whose addresses may exist multiple times, in slightly different fashions?</p>