See my post: https://www.c-sharpcorner.com/blogs/how-to-make-faster-sqlserver-search-part-i, wait for a while the part II, that are in revision: https://www.c-sharpcorner.com/blogs/how-to-make-faster-sql-server-search-part-two

using web services, angular js, REST services or WCF service.