My MVC site (sql08 back-end - nHibernate in the middle) asks for a company name when a user creates a new account. My business rules dictate that i accept whatever the user enters but into a field named CompanynameProvisional. Management needs to confirm that entry so we can enforce a One-to-Many relationship. (a single company can have many users).
So i'm creating a report that shows a manager all unconfirmed, newly created users. Alongside the string entered by the user I'd like to use a soundex (or equivalent) algorithm that would query the db for confirmed names and suggest preexisting names that would override the user's entry if such a match exists.
Sometimes the newly entered name has an obvious typo (which i assume would be covered by implementing a standard soundex resource) but what about entries like MyAcme Co compared to MyAcme Inc.
I've found an interesting article that may or may not be the best starting point for addressing this problem. Do you have a better starting point?
thx