将地址与地址列表进行比较 [英] Compare Address against to addresses list

问题描述

请帮助： -

要查看我们的SQL DB地址列表中的客户地址，请告知我们的数据库中是否存在该地址。

客户地址有不同的格式。

例如： - 8455 W 23RD st OFFICE 4

8455 WEST 23RD st OFC 4

8455 WEST TWENTY-THIRD街道OFC 4

如果我进行字符串比较，我会得到bExist = False;





注意： - 我正在使用C＃，

服务器运行的应用程序没有互联网连接。

请指教。

Please help:-
To check the customer address against to our SQL DB address list,to tell the address is existed in our DB or not.
The customer address comes in different format.
e.g:- 8455 W 23RD st OFFICE 4
8455 WEST 23RD st OFC 4
8455 WEST TWENTY-THIRD street OFC 4
If I do string compare,I will get bExist = False;


Note:- I am using C#,
The server were the application run has no internet connection.
Please advice.

推荐答案

你可以对字符进行频率分析，和/或取缩写值（W用空格包围）是WEST，ST by spaces是STREET）并扩展它们等，然后获得它们有多相似的概率。我曾经在一个数据库项目上做过一次，效果很好。



代码示例和说明 [ ^ ]

You can do a frequency analysis on the characters, and/or take abbreviated values (W surrounded by spaces is WEST, ST by spaces is STREET) and expand them, etc then get a probability of how similar they are. I did this on a database project once and it worked well.

Code Example and Explanation[^]

这篇关于将地址与地址列表进行比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！