We help IT Professionals succeed at work.
Get Started

SQL Server Full text search to find an address

Last Modified: 2014-07-09
I have a requirement to do "fuzzy logic" searching across a range of data to find an address quickly from 20,000+ Addresses.
I want to search across address line 1, line 2, town, postcode and a building reference code.
So I have created a field in my address table (called FullTextSearch Nvarchar(MAX) )and applied a FTE to it.
I have some triggers which populate these with the desired search fields, comma separated.E.g.

50888200,Canons House,Canons Way,Bristol,BS1 5LL

Now I want to enter for example "canons house Bristol" as a search term and return this record as the closest match.
Or I might enter "50888200" (a property code) or a part of it - like the first 6 characters and return a range of results
or a postcode "BS1 5LL"
and other combinations.
Essentially a very user friendly way of finding a location, based upon a number of different ways in which the property/address may be known.
We plan to add some other data in there where a building is known by a colloquial name, for example "Head Office" or "Bristol branch" or "Training centre".
Is my approach right ?
Any ideas or suggestions ?
Watch Question
Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE