I remember the first time I saw Google Suggest, it would run the search in real-time and provide a dropdown with possible queries. One of my teammates always joked about making software with one button that would automatically know what you wanted to do. I showed it to him and suggested that Google was getting closer.
- Changing the query to use the FullText rather than the keyword query.
- Changing the jQuery selectors as the return values are different for the different query types.
In addition to this I changed the path to jQuery to load from the 12 hive, and I added some protection against SQL injection in the query.
Update 9/26/2011: David Lozzi has extended this code (and code contributed by several others) to create the Search as You Type Project on CodePlex. I would encourage all of you to take advantage of his hard work with this great project.