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

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

67 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
crumped	14	43	1122	(None)
chumped	17	37	949	1	chumped
clumped	14	36	1066	1	clumped
cramped	14	47	1218	1	cramped
crimped	14	39	1076	1	crimped
crumbed	14	37	847	1	crumbed
crumpet	13	37	1106	1	crumpet
crumpled	15	29	687	1	crumpled
grumped	13	33	733	1	grumped
trumped	12	43	971	1	trumped
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
clamped	14	40	1204	2	clamped
clomped	14	39	897	2	clomped
comped	13	59	1987	2	c_omped
couped	11	50	1931	2	cou_ped
crammed	14	37	1012	2	crammed
craped	11	61	2053	2	cr_aped
crapped	14	39	1263	2	crapped
creeped	12	32	971	2	creeped
creped	11	41	1572	2	cr_eped
crimper	13	65	1042	2	crimper
crimpled	15	36	693	2	crimpled
crisped	12	40	1011	2	crisped
cropped	14	38	1207	2	cropped
crudded	12	3	573	2	crudded
cruised	10	37	1022	2	cruised
crumber	13	33	964	2	crumber
crumbled	15	35	744	2	crumbled
crump	11	56	1642	2	crump__
crumpets	14	33	594	2	crumpets
crumple	13	36	836	2	crumple
crumples	14	34	881	2	crumples
crumply	16	33	609	2	crumply
crumps	12	45	1434	2	crump_s
crupper	13	33	856	2	crupper
crushed	13	41	1197	2	crushed
crusted	10	37	1276	2	crusted
cupped	13	44	1398	2	c_upped
cusped	11	43	1204	2	c_usped
drummed	13	30	632	2	drummed
dumped	12	38	1449	2	_dumped
flumped	15	37	771	2	flumped
humped	14	40	1524	2	_humped
jumped	18	35	1155	2	_jumped
lumped	11	42	1696	2	_lumped
mumped	13	38	1316	2	_mumped
plumped	14	31	864	2	plumped
primped	14	47	915	2	primped
pumped	13	39	1556	2	_pumped
ramped	11	46	1790	2	_ramped
romped	11	45	1365	2	_romped
rumpled	12	38	1001	2	_rumpled
scrimped	15	5	531	2	scrimped
scrummed	15	5	431	2	scrummed
slumped	12	37	1015	2	slumped
stumped	12	42	1015	2	stumped
thumped	15	38	741	2	thumped
tramped	12	43	1243	2	tramped
tromped	12	42	1029	2	tromped
trumpet	11	38	1072	2	trumpet
tumped	11	42	1623	2	_tumped
umped	10	47	1727	2	__umped
whumped	18	33	563	2	whumped

Search took 7 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.766	233278.1
2	DLD Change Limit	107671	67	5.936	18138.6
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	6.735	26531.7