title: MSSQL - Is there a way to match '2nd' and 'second' . Doesn't seem like soundex does the trick
body: <p>We are looking for ways to match user addresses. If a user enters '2nd street' and our DB has 'Second street', the sql should return 'Second street' when queried.</p>
  <p>Soundex didn't work. I tried something like <code>SELECT * FROM TABLE WHERE SOUNDEX(ADDRESS_COL) = SOUNDEX(@USERINPUT)</code></p>
  <p>I can't use full-text search as I don't control the DB and table is not full-text indexed. Will the full-text search work in this case anyways? If so, maybe I can get someone to convince DBAs for it.</p>
  <p>Am I missing something obvious?</p>