Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “galvanizers” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

78 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
galvanizers	24	5	234	(None)
galvanizer	23	4	359	1	galvanizer_
galvanizes	23	4	476	1	galvanize_s
galvanises	14	4	465	2	galvanise_s
galvanize	22	4	513	2	galvanize__
galvanized	24	4	427	2	galvanize_d
alkalizers	23	15	395	3	_alkalizers
balkanizes	25	4	433	3	balkanize_s
galvanise	13	4	488	3	galvanise__
galvanised	15	4	346	3	galvanise_d
galvanisms	16	4	405	3	galvani_sms
galvanizing	25	9	434	3	galvanizing
paganizers	22	5	371	3	pa_ganizers
vulcanizers	25	5	245	3	vulcanizers
advancers	15	4	299	4	_advan_cers
aggrandizers	24	9	146	4	aggrandizers
alanines	8	3	1480	4	_al_anine_s
alkalizer	22	15	556	4	_alkalizer_
alkalizes	22	15	735	4	_alkalize_s
allanites	9	4	980	4	_allanite_s
avianizes	21	4	555	4	_avianize_s
balancers	13	4	506	4	bal_an_cers
balkanize	24	4	438	4	balkanize__
balkanized	26	4	380	4	balkanize_d
botanizers	21	4	428	4	_botanizers
calvaries	14	4	980	4	calvari_e_s
canonizers	21	4	441	4	ca_nonizers
cavaliers	14	5	562	4	ca_vali_ers
colonizers	21	28	672	4	col_onizers
fantasizers	23	9	288	4	fantasizers
faradizers	23	22	364	4	fa_radizers
galabiehs	15	4	244	4	gal_abi_ehs
galantines	11	4	572	4	gal_antine_s
galaxies	16	3	716	4	gal_axi_e_s
galenites	10	12	918	4	gal_enite_s
gallamines	13	4	549	4	gallamine_s
gallicizes	22	8	483	4	gallicize_s
gallinippers	17	6	71	4	gallinippers
galvanic	14	4	451	4	galvani___c
galvanising	16	12	334	4	galvanising
galvanism	15	4	452	4	galvani__sm
galvanometers	19	6	134	4	galvanometers
gasaliers	10	4	451	4	ga_sali_ers
germanizes	22	4	815	4	germanize_s
glaciers	11	27	789	4	g_l_aci_ers
glamorizers	23	10	270	4	glamorizers
glancers	11	40	800	4	g_l_an_cers
glanders	10	38	1150	4	g_l_an_ders
glazers	17	44	1004	4	g_l_a__zers
glaziers	18	40	656	4	g_l_azi_ers
gleaners	9	34	807	4	g_lean__ers
gormandizers	25	6	266	4	gormandizers
harmonizers	25	13	377	4	harmonizers
humanizers	24	4	395	4	_humanizers
italianizes	20	19	375	4	italianize_s
japanizes	27	4	516	4	ja_panize_s
lavaliers	12	5	428	4	la_vali_ers
lionizers	18	4	424	4	__lionizers
malanders	12	3	702	4	mal_an_ders
mechanizers	27	5	353	4	mechanizers
melanizes	20	4	1038	4	mel_anize_s
organizers	20	4	456	4	_organizers
paganizer	21	4	576	4	pa_ganizer_
paganizes	21	4	866	4	pa_ganize_s
palletizers	22	5	301	4	palletizers
polarizers	21	6	589	4	pol_arizers
pollenizers	22	5	297	4	pollenizers
pollinizers	22	5	297	4	pollinizers
pulverizers	25	5	224	4	pulverizers
salinizes	18	3	915	4	sal_inize_s
salvagers	13	4	469	4	salva__gers
sylvanites	16	4	328	4	sylvanite_s
tantalizers	20	8	426	4	tantalizers
volcanizes	24	4	564	4	volcanize_s
vulcanizer	24	5	343	4	vulcanizer_
vulcanizes	24	4	447	4	vulcanize_s
vulgarizers	24	17	247	4	vulgarizers
womanizers	24	4	417	4	_womanizers

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	148819	0.423	422437.4
2	DLD Change Limit	148819	78	8.156	18246.6
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	8.625	20717.8