Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Calculation of a degree of similarity of phrases
i make The Extended stored procedure for MS SQL Server which
Calculation of a degree of similarity of phrases.
One of the most complex and important problems for the developer and the operator of a database is maintenance of uniqueness names in the most important references of system.
Offered function can be used in SQL inquiry as criterion of sorting of the directory according to similarity with a required phrase.
incredibly high speed of data processing
Unique algorithm analyzing similarity of phrases even at significant divergences in required phrases
is not required installation of additional libraries to each client - library DLL must benn installed only on a server.
Result is all the table sorted in decreasing order phonetic similarity (probably use of operator TOP for sample only the limited quantity of the most similar variants)
Use of user server function supposes use in Stored procedures, Views and any SQL expressions
Spends a minimum of server memory
If the decision of the given problem is interesting to you and there is an opportunity desire and an opportunity to test http://kozin1.narod.ru/newsite/index.html?english.htm
Dll and sample scripts in rar archive (2,5 KB)
I thank in advance
0 · ·