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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

150 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
dummying	17	26	372	(None)
mummying	15	26	372	1	mummying
bumming	14	34	1078	2	bumm_ing
damming	13	38	1274	2	damm_ing
dimming	13	33	959	2	dimm_ing
drumming	14	26	578	2	drumm_ing
dumbing	13	31	985	2	du_mbing
dumping	13	37	1291	2	du_mping
dumpling	14	21	789	2	dumpling
gumming	13	38	1019	2	gumm_ing
humming	15	33	1067	2	humm_ing
jemmying	23	3	231	2	jemmying
jimmying	23	4	238	2	jimmying
mumming	11	40	1002	2	mumm_ing
summing	12	29	1238	2	summ_ing
bamming	14	46	1181	3	bamm_ing
buddying	16	27	479	3	buddying
bullying	14	32	929	3	bullying
bumbling	15	24	976	3	bumbling
bumping	14	38	1249	3	bu_mping
buoying	13	37	995	3	bu_oying
burying	13	34	1391	3	bu_rying
busying	13	42	1199	3	bu_sying
buying	12	42	1383	3	bu__ying
chammying	22	4	335	3	chammying
chumming	18	36	620	3	chumm_ing
cullying	14	29	750	3	cullying
culming	12	38	1118	3	culm_ing
cummin	12	8	878	3	cumm_in_
cummins	13	5	896	3	cumm_ins
currying	14	19	649	3	currying
dairying	13	3	635	3	dairying
dallying	13	36	849	3	dallying
damaging	13	3	738	3	damaging
damning	11	42	1163	3	d_amning
damping	13	34	1400	3	d_amping
decaying	15	23	945	3	decaying
decoying	15	20	876	3	decoying
decrying	15	23	741	3	decrying
deeming	11	39	1312	3	deem_ing
defying	15	32	882	3	d_efying
degumming	16	4	313	3	degumm_ing
deifying	16	3	763	3	deifying
delaying	13	32	1097	3	delaying
demising	12	20	1252	3	demising
demoing	11	3	1175	3	d_emoing
demoting	12	3	1142	3	demoting
denying	12	37	1129	3	d_enying
dimpling	14	19	902	3	dimpling
dirtying	13	3	609	3	dirtying
dismaying	16	5	682	3	dismaying
divvying	19	3	277	3	divvying
dizzying	21	3	302	3	dizzying
dollying	13	40	741	3	dollying
doming	10	42	1839	3	d_om_ing
dooming	11	31	1253	3	doom_ing
dramming	14	34	756	3	dramming
draying	12	38	1384	3	d_raying
drumbling	15	4	403	3	drumbling
drying	11	34	1160	3	d__rying
dubbing	13	33	1121	3	du_bbing
ducking	15	43	1505	3	du_cking
duckling	16	24	770	3	duckling
ducting	11	37	1359	3	du_cting
duding	9	39	1332	3	du__ding
dueling	9	36	1454	3	du_eling
duelling	10	34	1073	3	duelling
dueting	9	38	1439	3	du_eting
duetting	10	4	718	3	duetting
duking	12	47	1513	3	du__king
dulling	9	34	1827	3	du_lling
dummied	13	34	672	3	dumm_ied
dummies	12	30	1213	3	dumm_ies
dummy	13	47	1278	3	dummy___
dumpings	14	29	576	3	du_mpings
dumplings	15	21	385	3	dumplings
dunging	10	30	1262	3	du_nging
dunking	13	38	1326	3	du_nking
dunning	9	35	1447	3	du_nning
dunting	9	34	1838	3	du_nting
duping	10	41	1363	3	du__ping
dupping	13	37	1104	3	du_pping
during	8	44	1940	3	du__ring
durning	9	35	1173	3	du_rning
dusking	13	39	1205	3	du_sking
dusting	9	36	1899	3	du_sting
dying	10	53	1603	3	d___ying
fumbling	16	20	816	3	fumbling
fuming	12	40	1329	3	fu_m_ing
gamming	13	31	1262	3	gamm_ing
gemming	13	28	914	3	gemm_ing
gullying	13	36	724	3	gullying
gussying	13	3	406	3	gussying
guying	11	37	972	3	gu__ying
hamming	15	30	1409	3	hamm_ing
hemming	15	26	997	3	hemm_ing
humbling	16	20	867	3	humbling
humoring	14	5	685	3	humoring
humphing	19	3	516	3	humphing
humping	15	32	1307	3	hu_mping
hurrying	15	14	553	3	hurrying
jamming	19	32	979	3	jamm_ing
jumbling	20	21	723	3	jumbling
jumping	19	31	980	3	ju_mping
jurying	18	33	776	3	ju_rying
juttying	19	3	357	3	juttying
lamming	12	30	1458	3	lamm_ing
lemming	12	26	939	3	lemm_ing
lumping	12	33	1464	3	lu_mping
maying	12	44	2115	3	__maying
muddying	16	25	454	3	muddying
mumbling	15	19	853	3	mumbling
mummifying	20	4	285	3	mummifying
mumping	14	34	1163	3	mu_mping
nimming	12	35	814	3	nimm_ing
numbing	12	26	903	3	nu_mbing
outlying	12	4	881	3	outlying
outvying	15	3	606	3	outvying
pumicing	15	3	584	3	pumicing
pummeling	16	4	360	3	pummeling
pumping	14	42	1355	3	pu_mping
puttying	14	3	495	3	puttying
querying	21	3	524	3	querying
ramming	12	31	1506	3	ramm_ing
rimming	12	34	1107	3	rimm_ing
rubying	13	29	793	3	ru_bying
rumbaing	13	18	530	3	rumbaing
rumbling	13	19	1010	3	rumbling
rummaging	15	4	336	3	rummaging
rumoring	11	3	698	3	rumoring
rumpling	13	17	876	3	rumpling
scumming	15	25	679	3	scumm_ing
shammying	20	4	295	3	shammying
shimmying	20	4	253	3	shimmying
slumming	13	27	838	3	slumm_ing
stimying	14	3	750	3	stimying
stumming	13	34	767	3	stumm_ing
stymying	17	3	396	3	stymying
sullying	12	32	851	3	sullying
summating	14	3	794	3	summating
summering	14	5	875	3	summering
summiting	14	4	579	3	summiting
summoning	14	11	569	3	summoning
tomming	12	35	924	3	tomm_ing
tumbling	13	21	929	3	tumbling
tumefying	18	4	242	3	tumefying
tumping	12	31	1424	3	tu_mping
umping	11	48	1533	3	_u_mping
undying	12	3	850	3	_undying
untying	11	3	894	3	_untying

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	150	7.250	20160.3
3	Display Results	150	150	0.063	2381.0
	(SQL Overall)	178691	150	7.719	23149.5