ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
NamesError NamesFuzzy MatchMatch?
2
Mehul GuptaMeryl Gupta#N/A0Formula
3
John Andrew LewisJahn Andrej Levis#N/A0
=ARRAY_CONSTRAIN(ARRAYFORMULA(FUZZY_XLOOKUP('Fuzzy Matching Test Sheet'!$B2,'Fuzzy Matching Test Sheet'!$A$2:$A$440)), 1, 1)
4
Cyndi Eric WoodCandice Erick Waud#N/A0
5
Mary EllenMari Ehlen#N/A0# Good Matches
6
Carlos Alfonzo DiazCarlow Diez#N/A00
7
Anne Meier-KingAnge Meyer-King#N/A0#NAME?
8
Michaela Hudson Bennett
Michael Hudson#N/A0
JARO_MATCHES = LAMBDA(
9
Alyson Colin GrayAlison Coplin Gray#N/A0# Bad Matches
        str_1, str_2, str_1_index, str_2_index, distance_matrix, 
10
Britney Alejandro Hughes
Britni Alessandro#N/A0439
        LET(
11
Dwayne SandersDwaine Xander#N/A0#NAME?
            match_array, IF(INDEX(distance_matrix, 1, ), INDEX(str_1, 1) = str_2, FALSE),
12
Jesse JonesJessie Jonas#N/A0
            match_found, OR(match_array),
13
Cedric Maxwell FosterCedric Marcell Foister#N/A0
            match_position, XMATCH(TRUE, match_array),
14
John JacobJohn Jacobi#N/A0
            remaining_cols, FILTER(SEQUENCE(COLUMNS(str_2)), SEQUENCE(COLUMNS(str_2)) <> IF(match_found, match_position, "")),
15
Peter Alfred EscherPieter Alfreds Eshcher#N/A0
            new_distance_matrix, CHOOSECOLS(distance_matrix, remaining_cols),
16
Peter James LowPete Lowd#N/A0
            remaining_rows, SEQUENCE(ROWS(str_1) - 1, 1, 2),
17
Mehul GuptaMehl Gutta#N/A0
            result, IF(
18
John Andrew LewisJohan Andrew Lewise#N/A0
                match_found,
19
Cyndi Eric WoodCandy Erin Wood#N/A0
                HSTACK(INDEX(str_1_index, 1), INDEX(str_2_index, match_position)),
20
Mary EllenMare Ellens#N/A0
                HSTACK("", "")
21
Carlos Alfonzo DiazCarlo Alford Diaz#N/A0            ),
22
Anne Meier-KingAnny Merlin#N/A0
            IF(
23
Michaela Hudson Bennett
Michele Bennett#N/A0
                OR(ISERROR(remaining_rows),ISERROR(remaining_cols)),
24
Alyson Colin GrayAlys Corin#N/A0
                result,
25
Britney Alejandro Hughes
Britaney Alexander Hughes#N/A0
                VSTACK(result, JARO_MATCHES(
26
Dwayne SandersSanders Dayne#N/A0
                    CHOOSEROWS(str_1, remaining_rows),
27
Jesse JonesJosie Jones#N/A0
                    CHOOSECOLS(str_2, remaining_cols),
28
Cedric Maxwell FosterMaxwell Gedris Foster#N/A0
                    CHOOSEROWS(str_1_index, remaining_rows),
29
John JacobJacob Jahn#N/A0
                    CHOOSECOLS(str_2_index, remaining_cols),
30
Peter Alfred EscherPetr Alfie#N/A0
                    CHOOSEROWS(CHOOSECOLS(distance_matrix, remaining_cols), remaining_rows)
31
Peter James LowPester Jamie Low#N/A0
32
Mehul GuptaMehul Gustaf#N/A0
33
John Andrew LewisJorn Andrei Lenis#N/A0
34
Cyndi Eric WoodCyndie Erice#N/A0
35
Mary EllenEllyn Mary#N/A0
36
Carlos Alfonzo DiazCarls Riaz#N/A0
37
Anne Meier-KingAnna Meier-King#N/A0
38
Michaela Hudson Bennett
Mikhaila Bennett#N/A0
39
Alyson Colin GrayColin Alston Gray#N/A0
40
Britney Alejandro Hughes
Alejandro Britney Hughie#N/A0
41
Dwayne SandersAnder Dwane#N/A0
42
Jesse JonesJoynes Jesse#N/A0
43
Cedric Maxwell FosterCedric Falwell Fesler#N/A0
44
John JacobJohn Jago#N/A0
45
Peter Alfred EscherPeter Escher Aled#N/A0
46
Peter James LowJames Petet Low#N/A0
47
Mehul GuptaMehul Gutt#N/A0
48
John Andrew LewisJohn Andie#N/A0
49
Cyndi Eric WoodWedd Cyndi Eric#N/A0
50
Mary EllenMarc Elle#N/A0
51
Carlos Alfonzo DiazCaryss Alfonza Diaz#N/A0
52
Anne Meier-KingAnne Meger-King#N/A0
53
Michaela Hudson Bennett
Michal Hudson Brett#N/A0
54
Alyson Colin GrayAlyson Coplin Grey#N/A0
55
Britney Alejandro Hughes
Britney Leando Hughes#N/A0
56
Dwayne SandersSandy Dwayne#N/A0
57
Jesse JonesJessel Jones#N/A0
58
Cedric Maxwell FosterCedric Foster Kambell#N/A0
59
John JacobJaxon Jon#N/A0
60
Peter Alfred EscherPeter Esther Alfres#N/A0
61
Peter James LowLowe Petek James#N/A0
62
Dr.Stuti Aayush AgarwalDr.Shruti Aayush Agarwal#N/A0
63
William Benjamin HallWillean Benjamin Hall#N/A0
64
Er Saumya Dhruv MehtaSaumya Dhruv Mesta#N/A0
65
Phd.Aaditya KapoorPhd.Adith Kapoor#N/A0
66
Samuel Gabriel CarterSamuel Ariel Carter#N/A0
67
Rafael Ryan TurnerRafal Ryan Turner#N/A0
68
Stephen Isaac ParkerStephen Izaac Parker#N/A0
69
Jerry EdwardsDerry Edwards#N/A0
70
James Earl SmithJames Earl Snith#N/A0
71
Brian Gavin CollinsBrian Cavin Collins#N/A0
72
Michael Tyler StewartMichael Kyler Stewart#N/A0
73
Philip Owen MorrisPhilip Oden Morris#N/A0
74
Neil Brandon CookNeil Brandon Coop#N/A0
75
Elizabeth RogersElisabetta Rogers#N/A0
76
John Adrian PetersonJohn Adriano Peterson#N/A0
77
Shawn Kevin HowardShaan Kevin Howard#N/A0
78
Anne Sebastian WatsonAnne Sebastian Wasson#N/A0
79
Joanne Colton Richardson
Joanne Coltin Richardson#N/A0
80
Katelyn Xavier CoxKaelyn Xavier Cox#N/A0
81
Sara Alex BrooksSaba Alex Brooks#N/A0
82
Katherine D'SouzaKaterina D'Souza#N/A0
83
Dr.Stuti Aayush AgarwalDr. Stuti Aarush Agarwal#N/A0
84
William Benjamin HallWilliam Benhamin Hall#N/A0
85
Er Saumya Dhruv MehtaEr Saurya Dhruv Mehta#N/A0
86
Phd.Aaditya KapoorPhd.Aaditya Zahoor#N/A0
87
Samuel Gabriel CarterManuel Gabriel Carter#N/A0
88
Rafael Ryan TurnerRafael Bryan Turner#N/A0
89
Stephen Isaac ParkerStellen Isaac Parker#N/A0
90
Jerry EdwardsEduardo Jerry#N/A0
91
James Earl SmithJamey Earl Smith#N/A0
92
Brian Gavin CollinsBrian Gavin Cillis#N/A0
93
Michael Tyler StewartStuart Michael Tyler#N/A0
94
Philip Owen MorrisPhil Owen Morris#N/A0
95
Neil Brandon CookNeil Braedon Cook#N/A0
96
Elizabeth RogersRowen Elizabeth#N/A0
97
John Adrian PetersonHenderson John Adrian#N/A0
98
Shawn Kevin HowardShawn Kelvin Howard#N/A0
99
Anne Sebastian WatsonAnne Bastian Watson#N/A0
100
Joanne Colton Richardson
Deanne Colton Richardson#N/A0