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

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

59 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
grumped	13	33	733	(None)
crumped	14	43	1122	1	crumped
trumped	12	43	971	1	trumped
bumped	13	44	1400	2	_bumped
chumped	17	37	949	2	chumped
clumped	14	36	1066	2	clumped
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
drummed	13	30	632	2	drummed
dumped	12	38	1449	2	_dumped
flumped	15	37	771	2	flumped
gaumed	10	46	1032	2	gaum_ed
gazumped	23	4	140	2	gazumped
gimped	12	39	1147	2	g_imped
grasped	11	40	906	2	grasped
grimed	10	47	1409	2	grim_ed
griped	10	41	1471	2	gr_iped
gripped	13	41	934	2	gripped
groped	10	75	1505	2	gr_oped
grouped	11	41	919	2	grouped
grubbed	13	40	643	2	grubbed
grudged	11	31	716	2	grudged
grueled	9	3	713	2	grueled
gruffed	15	4	494	2	gruffed
grumbled	14	25	675	2	grumbled
grume	8	62	1816	2	grum_e_
grumes	9	44	1555	2	grum_es
grummer	12	33	878	2	grummer
grummet	12	29	887	2	grummet
grump	10	51	1531	2	grump__
grumphy	18	44	362	2	grumphy
grumpier	13	3	480	2	grumpier
grumps	11	45	1057	2	grump_s
grumpy	14	49	815	2	grump_y
grunted	9	33	928	2	grunted
gulped	10	46	1037	2	g_ulped
gummed	12	38	1166	2	g_ummed
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
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.393	454684.5
2	DLD Change Limit	107671	59	5.873	18333.2
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	6.299	28368.2