I have a issue designing am asp.net site. The problem is that I want to have a search component that searches article titles. Also I want to catch closely words. Since there are tens of thousands of articles I cannot run SQL directly.
Can you give me a hint... or some good articles how to design a search component?
Thanks.
Why not use MS Search Server Express Edition to index your contents and then use MS Search Server API to query and display results? This question has some information about it if you are interested.