A custom search engine, with which you can search for web results, images, video and news items on your site.
Also use a server-side language like PHP and run search queries on your database, displaying the results to the user.
This app uses Google’s AJAX Search API with naked version by issuing JSONp calls with jQuery directly to their API.