I've got a database table with columns as follows
ID:
Link:
Desc:
I want the following to happen, if a user enters a string such as "Car registry name change" I want it to find the closest row where Desc matches what was entered, for example one row's desc is
"NAME CHANGE CAR REGISTRY"
But it will ignore
"NAME CHANGE INSURANCE"
Or at least say it's a lower match than the car one, it would also find
"REGISTRY"
Ideas?