The client is famous pharmacy price comparison site in Australia. Data for the rates and availability is gathered from multiple sites and made available for search. Mysql fulltext search was being used for the search. The search was no accurate and was very slow. Searching a misspelled word was common due to nature of the site. It was also missing important features like search by synonyms.
We designed and implemented Sphinx Search for this site. It made is easy to search via synonyms and misspelled words. The load of the full text search was taken off mysql so it made over all site faster.