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

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

70 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
clumped	14	36	1066	(None)
chumped	17	37	949	1	chumped
clamped	14	40	1204	1	clamped
clomped	14	39	897	1	clomped
crumped	14	43	1122	1	crumped
flumped	15	37	771	1	flumped
lumped	11	42	1696	1	_lumped
plumped	14	31	864	1	plumped
slumped	12	37	1015	1	slumped
blumed	11	43	1364	2	blum_ed
bumped	13	44	1400	2	_bumped
camped	13	47	2023	2	c_amped
champed	17	41	1148	2	champed
chomped	17	32	977	2	chomped
chummed	17	39	644	2	chummed
clammed	14	36	996	2	clammed
clamper	13	40	1299	2	clamper
clapped	14	35	1117	2	clapped
clasped	12	36	1044	2	clasped
cleped	11	51	1411	2	cl_eped
climbed	14	33	698	2	climbed
clipped	14	43	983	2	clipped
clopped	14	36	1152	2	clopped
clubbed	14	30	745	2	clubbed
clucked	16	38	1013	2	clucked
clued	8	49	1768	2	clu__ed
clumber	13	40	1144	2	clumber
clump	11	55	1745	2	clump__
clumpier	14	3	558	2	clumpier
clumps	12	153	1464	2	clump_s
clumpy	15	40	957	2	clump_y
clunked	14	43	957	2	clunked
clupeid	12	3	463	2	clu_peid
columned	13	3	492	2	columned
comped	13	59	1987	2	c_omped
couped	11	50	1931	2	cou_ped
cramped	14	47	1218	2	cramped
crimped	14	39	1076	2	crimped
crumbed	14	37	847	2	crumbed
crumpet	13	37	1106	2	crumpet
crumpled	15	29	687	2	crumpled
culmed	11	46	1059	2	culm_ed
cupped	13	44	1398	2	c_upped
cusped	11	43	1204	2	c_usped
dumped	12	38	1449	2	_dumped
flumed	12	49	1526	2	flum_ed
grumped	13	33	733	2	grumped
humped	14	40	1524	2	_humped
jumped	18	35	1155	2	_jumped
lamped	11	40	1754	2	_lamped
limped	11	48	1712	2	_limped
lumpen	10	40	1066	2	_lumpen
lumper	10	38	1665	2	_lumper
mumped	13	38	1316	2	_mumped
plumbed	14	31	727	2	plumbed
plumed	11	44	1288	2	plum_ed
plumiped	15	3	331	2	plumiped
plumpen	13	27	640	2	plumpen
plumper	13	31	877	2	plumper
pumped	13	39	1556	2	_pumped
schlumped	19	4	195	2	schlumped
shlumped	16	4	344	2	shlumped
slummed	12	35	927	2	slummed
slurped	10	36	875	2	slurped
stumped	12	42	1015	2	stumped
thumped	15	38	741	2	thumped
trumped	12	43	971	2	trumped
tumped	11	42	1623	2	_tumped
umped	10	47	1727	2	__umped
whumped	18	33	563	2	whumped

Search took 4 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	107671	0.393	454684.5
2	DLD Change Limit	107671	70	3.500	30763.1
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	3.923	45549.6