Ajax autosuggest/autocomplete from database

Since google introduced the autosuggest or AutoComplete search form on their toolbar everyone started looking for this piece of code to put on their websites. It`s not new in the Ajax world but it`s not seen as often as it should if you Ask me. Why? It`s hard to find good examples or examples that match everyone`s needs. An Ajax autosuggest script is supposed to help the visitor and present in real time (as they type) some possible results based on their entered words/characters. In my opinion, this is a great feature to enhance the user experience. It`s not hard to build an autocomplete search form. In fact, it`s very easy. Our application will use script.aculo.us which is a rich Javascript library for the Ajax effect, an index page that will hold the search form and a response page that will perform the search based on the $_POST parameter received from our index and display some possible matches/results/suggestions. Since it`s very easy to follow the demos and examples from the scriptaculous website we will focus more on the response page and the way that it will select the results and display them. Using what`s explained in the PHP search engine tutorial I managed to build a nice response page in order to display my suggestions using Ajax. The response page will check the post data, stem it (plurals to singulars etc.), Clean It (for common words, too short words etc.) and perform an sql search do display the entries that might match our words.