FullText search in SQLServer is the best option for you for text search inside one or more columns.
Just configure your table columns for capable to use full text search feature.
then you write sp and use full text search query inside that stored procedure.
write ajax function from your application, with this ajax function you execute that sp and fetch the value and render it by client side.
In details regarding fulltext search in sqlserver