I have table that stored business types. I use full text search in
that table . I can find the business type but when user enter the
worng word or not complete word like 'hosp' for 'hospital', at that
time I can't handle . if I use " contains(bus_type,'"hosp*"') " its
ok. But
for "car" its display "car" ,"care","caraok" and so on .How should I
do. I want to know how to spell correct the user input string if I can
get that function it ok.


waiting for guru

On Fri, 11 Jan 2008 22:47:45 -0800 (PST), akk2006 [at] gmail.com wrote:

You don't mention what tool you are developing your application in,
but most tools would allow you to create a dropdown with a hidden
BusinessTypeID and a visible BusinessType column, and then you can
have the users select from that list. No spelling errors possible.

-Tom.


>I have table that stored business types. I use full text search in
>that table . I can find the business type but when user enter the
>worng word or not complete word like 'hosp' for 'hospital', at that
>time I can't handle . if I use " contains(bus_type,'"hosp*"') " its
>ok. But
>for "car" its display "car" ,"care","caraok" and so on .How should I
>do. I want to know how to spell correct the user input string if I can
>get that function it ok.
>
>
>waiting for guru