Q:

What is a standard way to do autocomplete of addresses from DB?

I am having DB table with various addresses. It is divided into fields Street Name, House Number, Floor Number, Door Number.
I need to do autocomplete field (only one search field is there, consisting all fields mentioned above), which would suggest all matching addresses while typing.
Normally I would split it by space and have it done. 
However, how do you do it if Street Name sometime consists of 1,2,3 or more words?

A:

QAS PAF Matching Software has a whole team dedicated to finding address algorithms, and have been working on it for decades, and they still don't get it 100% of the time. Unless Jesus lives in Stack Overflow, I'm afraid you won't find anyone here who can solve your query out-of-the-box with SQL Server. Leading experts will tell you, this is something people will avoid like the plague, and spend tens of thousands of pounds per year to outsource to other companies.

