sql function to compare 2 strings for possible matches

Avbrutt Lagt ut 5 år siden Betales ved levering
Avbrutt Betales ved levering

Need sql function to compare 2 strings of names to determine if they match. See the examples below.

The below set is a Match

Str1 Str2

John Doe John Doe

John, Doe John Doe

John Doe John, Doe

John Doe Doe John

John L Doe John Doe

Doe John John L Doe

Doe L. John John L Doe

Doe L. John John L. Doe Jr.

Doe L John John L. Doe Jr.

Doe L John John L. Doe

Doe John John Lee Doe

Doe Lee John John L Doe

Doe Lee John John Doe

John Doe Sarah Doe and John Doe

John Doe Sarah Doe & John Doe

Doe John R John R Doe

Doe John R John Ray Doe

Doe John Ray John R Doe

The below set is NOT a match

Jay Taft John Doe

Doe L John John R. Doe

Sarah R Doe John R Doe

Sarah R Doe John R Doe

Databaseadministrasjon Microsoft SQL Server MySQL Oracle SQL

Prosjekt-ID: #17529108

Om prosjektet

8 bud Eksternt prosjekt Aktiv 5 år siden

Tildelt til:

$13 USD på 1 dag
(0 omtaler)
0.0

8 frilansere byr i gjennomsnitt $25 for denne jobben

royalwebraisers

HI, I can help you with the project. I am good at: PHP, CodeIgniter, laravel, jquery, MySQL, google map API. Let me know when we can discuss and start working. Looking forward to your response. Thanks... Mer

$35 USD på 1 dag
(113 Omtaler)
6.5
abugosia

Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$25 USD på 1 dag
(142 Omtaler)
6.4
fastwebsoft

hello sir, I have read your requirement carefully. I can do this job in few hours. thanks

$15 USD på 1 dag
(16 Omtaler)
6.0
ripasahasl

I can handle this task. give me an opportunity to work in this. I know you will be satisfied with the result.

$29 USD på 1 dag
(35 Omtaler)
5.0
anton515

Hi, I read your description carefully and I am sure I can do it in a day. I can complete this by using regular expression. Please contact me if you want. Regards,

$25 USD på 1 dag
(2 Omtaler)
3.5