Results 1 to 3 of 3

Thread: A (Google like) auto suggest for customer addresses

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2005
    Posts
    259

    A (Google like) auto suggest for customer addresses

    I have a database of 600,000 addresses with no names attached to it like this:

    Address01, Address02, City, State Zip

    I know these addresses are good so what I would like to do is create a function to do an auto suggest for addresses like Google does for search words after our staff enters a addresses into our Point of Sale system. So for instance if a staff member types in:

    Address01: 600 Weeler St

    I want to go through my address01 column and look for a match and if there is none I want to auto suggest similars like

    Did you mean:

    1) Wheeler St
    2) Wealer St
    3) Whaler St

    I have a couple of ideas on how to accomplish this but I am not sure of the best way to find "similars" since a Like = % (wild card character) won't work for this scenerio. So I am asking for some suggestions of an efficient way to accomplish the suggestions.

    Essentially, I am looking for patterns so I am thinking that I need to be working with Regular Expressions but I haven't done any work with them and I don't want to spend a lot of time trying to make them work with this application if there is another (better) way to do it.

    Any ideas, thoughts or suggestions will be greatly appreciated.
    Last edited by FastEddie; Sep 18th, 2008 at 08:36 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width