Create a dynamic search function using coldfusion

The project is as follows: 1.) To write a query / collection of queries in coldfusion (must be coldfusion) which will search 2 stipulated tables for a given search term. The query has to look for search terms that are similar to those that are provided for the search. For example a search for "hotel club" should be able to return [login to view URL], Hotelclub and other similar terms (if this is possible) 2.) I would also like the search box, where the search term will be inputted to suggest possible search terms like [login to view URL], Google and [login to view URL] I will give the names of the tables, the fields and the structure but without content and also will not give the Datasources. Once part 1.) and 2.) are finished; the pieces of code need to be put into two seperate .cfm files and sent to me which I will then integrate into the rest of the files. I will then test on my database to make sure it works. This project requires urgent attention as the rest of the website is completed and ready for deployment. ## Deliverables Please see attached table structure