This is one of those days where I'm starting to really appreciate Rails. Just implemented a ranked, paginated, highlighted, full text search engine for our transcripts and notes in about an hour and a half.
For those interested, the ThinkingSphinx gem integrates beautifully with the Sphinx indexer on Rails 3.1, requiring minimal configuration in the app or on the server. Pagination and relevance straight out of the box, and works just like will_paginate. Result highlighting was done with a little jquery plugin by Johann Burkard, with minor tweaking to highlight individual words in the query instead of matching the entire query string.
Oh, and the Bootstrap css framework made the results all pretty without any additional effort.