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

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

77 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
grumps	11	45	1057	(None)
crumps	12	45	1434	1	crumps
frumps	13	47	978	1	frumps
gramps	11	41	1427	1	gramps
grumes	9	44	1555	1	grumes
grump	10	51	1531	1	grump_
grumpy	14	49	815	1	grumpy
rumps	9	59	2229	1	_rumps
trumps	10	46	1188	1	trumps
arums	7	55	1783	2	arum_s
brumes	10	64	1707	2	brumes
bumps	11	59	2114	2	_bumps
chumps	15	43	1382	2	chumps
clumps	12	153	1464	2	clumps
cramps	12	56	1556	2	cramps
crimps	12	46	1345	2	crimps
crumbs	12	40	923	2	crumbs
crump	11	56	1642	2	crump_
drums	8	54	1587	2	drum_s
dumps	10	52	2010	2	_dumps
flumps	13	51	1250	2	flumps
frump	12	69	1256	2	frump_
frumpy	16	46	688	2	frumpy
gamps	10	53	2371	2	g_amps
gaums	8	62	1707	2	gaum_s
gazumps	21	3	187	2	gazumps
geums	8	54	1411	2	geum_s
gimps	10	59	1520	2	g_imps
glumes	9	45	1681	2	glumes
glumpy	14	52	719	2	glumpy
glums	8	46	2142	2	glum_s
gramas	9	43	1720	2	gramas
gramp	10	62	1832	2	gramp_
grampa	11	50	1017	2	grampa
grampas	12	39	925	2	grampas
grampus	12	35	631	2	grampus
grams	8	53	2731	2	gram_s
grasps	9	48	925	2	grasps
grimes	9	46	1903	2	grimes
grips	8	55	2013	2	gr_ips
groups	9	42	1051	2	groups
grubs	8	63	1260	2	gru_bs
gruels	7	39	1015	2	gruels
grues	6	57	2196	2	gru_es
gruffs	13	33	745	2	gruffs
grum	7	56	2508	2	grum__
grume	8	62	1816	2	grum_e
grumose	10	3	572	2	grumose
grumous	10	8	660	2	grumous
grumped	13	33	733	2	grumped
grumphy	18	44	362	2	grumphy
grumpish	16	4	376	2	grumpish
grunts	7	55	1185	2	grunts
gulps	8	47	1507	2	g_ulps
gums	7	50	3094	2	g_um_s
humps	12	63	2280	2	_humps
jumps	16	51	1649	2	_jumps
lumps	9	56	2498	2	_lumps
mumps	11	56	1910	2	_mumps
plumps	12	46	1261	2	plumps
primps	12	47	1182	2	primps
pumps	11	55	2060	2	_pumps
ramps	9	62	2463	2	_ramps
romps	9	46	1754	2	_romps
rump	8	67	2908	2	_rump_
rumpus	10	45	889	2	_rumpus
rums	6	48	3347	2	_rum_s
slumps	10	43	1358	2	slumps
stumps	10	49	1228	2	stumps
sumps	9	50	2343	2	_sumps
thumps	13	44	935	2	thumps
tramps	10	51	1445	2	tramps
tromps	10	49	1170	2	tromps
trump	9	56	1512	2	trump_
tumps	9	54	2079	2	_tumps
umps	8	57	2194	2	__umps
whumps	16	42	709	2	whumps

Search took 5 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	82551	0.106	1685764.2
2	DLD Change Limit	82551	77	4.393	18791.5
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	4.545	39316.0