Automatic coding of open end answers in constructed list

Our client wants to implement a brand funnel where the first question is brand awareness open ended. As there can be many answers I think we would implement let's say 10 fields. Each of the fields should have an autocomplete function from the 4th letter on.

Now the client wants to have the responses automatically coded into a constructed list of about 400 brands. Some variations and misspellings should also be allowed. Would it be possible to store these spelling variations in some kind of database or perl hash to compare the input with this and to fill the constructed list? With 400 brands and different spellings we perhaps need a economical solution.

The coded answers from the open ends should then be shown as pre ticked in the following aided awareness question ...

Any ideas would be appreciated.

7 replies