title: Compare Address against to addresses list
body: <p>To check the customer address against to our SQL DB address list,to tell the address existed in our DB or not.
  The customer address comes in different format.</p>
  
  <pre><code>e.g:- 8455 W 23RD st OFFICE 4
       8455 WEST 23RD st OFC 4
       8455 WEST TWENTY-THIRD street OFC 4
  </code></pre>
  
  <p>If I do string compare,I will get <code>bExist = False;</code>  </p>
  
  <p>Note:- I am using C#, The server were the application run has no internet connection.
  Additional eg:-</p>
  
  <pre><code>APARTMENT   APT
  APARTMENT   APARTMENT
  BUILDING    BLDG
  BUILDING    BUILDING
  DEPARTMENT  DEPT
  DEPARTMENT  DEPARTMENT
  FLOOR   FL
  FLOOR   FLOOR
  HANGAR  HNGR
  HANGAR  HANGAR
  LOT LOT
  OFFICE  OFC
  OFFICE  OFFICE
  PIER    PIER
  PIER    PIER
  ROOM    RM
  ROOM    ROOM
  SLIP    SLIP
  SPACE   SPC
  SPACE   SPACE
  STOP    STOP
  SUITE   STE
  SUITE   SUITE
  TRAILER TRLR
  TRAILER TRAILER
  UNIT    UNIT
  
  N   NORTH
  S   SOUTH
  E   EAST
  W   WEST
  NE  NORTHEAST
  SE  SOUTHEAST
  NW  NORTHWEST
  SW  SOUTHWEST
  NORTH   NORTH
  SOUTH   SOUTH
  EAST    EAST
  WEST    WEST
  NORTHEAST   NORTHEAST
  SOUTHEAST   SOUTHEAST
  NORTHWEST   NORTHWEST
  SOUTHWEST   SOUTHWEST
  NORTH EAST  NORTHEAST
  SOUTH EAST  SOUTHEAST
  NORTH WEST  NORTHWEST
  SOUTH WEST  SOUTHWEST
  </code></pre>