tryTry to use the "tesarus"Tesarus search" in a full text index in MS SQL ServerSQL Server. This is much better than using "%" in search if you have millions of records. tesarus haveTesarus has a smallsmaller amount of memory consumption than the others. try
Try to search this functions :)