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

Here are the results of your fuzzy-string dictionary search for “dumfounding” 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.

68 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
dumfounding	19	5	158	(None)
dumbfounding	22	6	105	1	dumbfounding
cofounding	17	4	367	3	_cofounding
compounding	19	4	307	3	compounding
confounding	18	4	326	3	confounding
defunding	15	21	612	3	d_ef_unding
demounting	14	4	496	3	dem_ounting
dumbfoundering	24	9	76	3	dumbfoundering
dumfound	15	4	259	3	dumfound___
dumfounded	18	6	170	3	dumfound_ed
dumfounds	16	4	223	3	dumfound__s
founding	13	30	1079	3	___founding
impounding	16	5	334	3	_impounding
mounding	12	33	1126	3	__m_ounding
refounding	15	4	535	3	_refounding
surrounding	13	5	237	3	surrounding
unrounding	12	4	487	3	_unrounding
abounding	13	3	519	4	__abounding
amounting	12	3	664	4	_am_ounting
astounding	12	4	415	4	_astounding
bounding	12	30	1213	4	___bounding
defending	15	29	835	4	d_ef_ending
demanding	14	23	792	4	dem__anding
denouncing	14	4	388	4	d_enouncing
desponding	15	5	566	4	despo_nding
diamonding	15	4	364	4	diamo_nding
discounting	15	4	744	4	discounting
dismounting	15	4	508	4	dismounting
drownding	15	6	412	4	d__rownding
dumbfound	18	5	167	4	dumbfound___
dumbfounded	21	5	105	4	dumbfound_ed
dumbfounder	20	5	109	4	dumbfound_er
dumbfounders	21	6	98	4	dumbfounders
dumbfounds	19	5	148	4	dumbfound__s
expounding	21	4	269	4	_expounding
fonding	12	38	1542	4	___fo_nding
foundling	14	3	521	4	___foundling
funding	12	41	1366	4	___f_unding
grounding	12	3	608	4	__grounding
hounding	13	26	1005	4	___hounding
humouring	15	4	455	4	hum_ou_ring
inbounding	14	4	384	4	_inbounding
missounding	15	4	344	4	missounding
moulding	12	25	814	4	__m_oulding
mounting	11	27	1181	4	__m_ounting
outcounting	14	4	430	4	outcounting
outfinding	15	4	587	4	outf_inding
pounding	12	33	1147	4	___pounding
prefunding	17	4	523	4	pref_unding
propounding	17	4	405	4	propounding
rebounding	14	3	530	4	_rebounding
redounding	13	4	521	4	_redounding
refunding	14	25	807	4	_ref_unding
remounting	13	4	667	4	rem_ounting
resounding	12	3	636	4	_resounding
rounding	10	28	1228	4	___rounding
rumouring	12	4	451	4	rum_ou_ring
sounding	10	27	1287	4	___sounding
stounding	11	3	623	4	__stounding
summoning	14	11	569	4	summo_n_ing
summonsing	15	4	309	4	summo_nsing
surmounting	14	4	264	4	surmounting
surroundings	14	5	126	4	surroundings
swounding	14	3	413	4	__swounding
typefounding	22	7	87	4	typefounding
unfolding	14	3	606	4	_unfo_lding
upfolding	16	4	294	4	_upfo_lding
wounding	13	24	940	4	___wounding

Search took 10 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	68	8.670	17164.8
3	Display Results	68	68	0.046	1478.3
	(SQL Overall)	178691	68	9.139	19552.6