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

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

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.

82 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
blonds	9	52	1334	(None)
blends	9	60	1288	1	blends
blinds	9	51	1161	1	blinds
blond	8	56	1837	1	blond_
blonde	9	48	1329	1	blonde
blondes	10	42	1316	1	blondes
bloods	9	46	1484	1	bloods
bonds	8	61	2684	1	b_onds
alands	7	54	1837	2	alands
almonds	10	12	795	2	almonds
bands	8	52	3342	2	b_ands
belongs	10	40	822	2	belongs
belons	8	41	1941	2	belon_s
bends	8	56	2897	2	b_ends
beyonds	13	3	506	2	beyonds
binds	8	66	2747	2	b_inds
bionts	8	6	1239	2	bionts
bland	8	53	2045	2	bland_
blanks	12	41	1289	2	blanks
bleeds	9	52	1159	2	bleeds
blend	8	53	1745	2	blend_
blende	9	54	1344	2	blende
blendes	10	47	1368	2	blendes
blind	8	63	1932	2	blind_
blinis	8	53	1368	2	blinis
blinks	12	46	1357	2	blinks
bloats	8	52	1576	2	bloats
blobs	9	56	2003	2	blo_bs
blocks	14	45	1394	2	blocks
blocs	9	52	1965	2	blo_cs
blogs	8	53	1923	2	blo_gs
blokes	12	38	1388	2	blokes
blonder	10	40	1194	2	blonder
blondest	11	41	924	2	blondest
blondish	14	7	617	2	blondish
blood	8	53	1952	2	blood_
bloody	12	47	1017	2	bloody
blooms	10	46	1317	2	blooms
bloops	10	66	1134	2	bloops
blots	7	56	2617	2	blo_ts
blows	10	54	2383	2	blo_ws
blunts	8	45	1289	2	blunts
bods	7	62	4471	2	b_o_ds
bolds	8	58	2528	2	b_olds
bond	7	53	3436	2	b_ond_
bones	7	64	4653	2	b_ones
bongs	8	78	2842	2	b_ongs
bonks	11	63	2646	2	b_onks
bonus	7	53	2432	2	b_onus
boons	7	50	3191	2	boon_s
bounds	9	44	1580	2	bounds
brands	9	51	1894	2	brands
broads	9	45	1515	2	broads
broncs	10	16	1115	2	broncs
broods	9	54	1638	2	broods
bunds	8	55	2354	2	b_unds
clods	8	53	2086	2	clo_ds
clones	8	45	2656	2	clones
clonks	12	50	1347	2	clonks
clons	7	52	2813	2	clon_s
clonus	8	52	1241	2	clonus
clouds	9	46	1235	2	clouds
elands	7	49	1477	2	elands
flongs	10	50	1049	2	flongs
floods	10	45	1165	2	floods
fonds	9	58	2482	2	_fonds
fronds	10	64	1234	2	fronds
glands	8	53	1440	2	glands
klongs	11	43	660	2	klongs
lands	6	54	2690	2	_lands
lends	6	53	2625	2	_lends
loads	6	53	2337	2	_loads
loids	6	62	2070	2	_loids
longs	6	55	2706	2	_longs
lords	6	49	2350	2	_lords
oblongs	10	3	353	2	oblongs
plods	8	57	1929	2	plo_ds
plonks	12	42	1042	2	plonks
ponds	8	53	2340	2	_ponds
sloids	7	37	1269	2	sloids
slojds	14	34	547	2	slojds
sloyds	10	34	629	2	sloyds

Search took 3 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	82551	0.110	1624463.6
2	DLD Change Limit	82551	82	2.640	31269.3
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	2.780	64277.3