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

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

43 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
glumpy	14	52	719	(None)
clumpy	15	40	957	1	clumpy
glumly	12	35	662	1	glumly
grumpy	14	49	815	1	grumpy
lumpy	12	66	1591	1	_lumpy
bumpy	14	47	1505	2	_bumpy
clump	11	55	1745	2	clump_
clumps	12	153	1464	2	clumps
clumsy	13	32	619	2	clumsy
dumpy	13	54	1475	2	_dumpy
flump	12	46	1472	2	flump_
flumps	13	51	1250	2	flumps
frumpy	16	46	688	2	frumpy
galumph	15	10	266	2	galumph
gimpy	13	52	1223	2	g_impy
gloppy	14	5	472	2	gloppy
gluey	9	57	1526	2	glu_ey
gluily	10	30	829	2	gluily
glum	7	58	2510	2	glum__
glume	8	51	2046	2	glum_e
glumes	9	45	1681	2	glumes
glumpily	16	4	359	2	glumpily
glums	8	46	2142	2	glum_s
grump	10	51	1531	2	grump_
grumphy	18	44	362	2	grumphy
grumps	11	45	1057	2	grumps
gulpy	11	46	1276	2	g_ulpy
gummy	13	54	1365	2	g_ummy
guppy	13	52	1127	2	g_uppy
humpy	15	51	1567	2	_humpy
jumpy	19	57	1281	2	_jumpy
lump	8	65	3170	2	_lump_
lumps	9	56	2498	2	_lumps
plummy	15	37	566	2	plummy
plump	11	53	1526	2	plump_
plumply	16	3	422	2	plumply
plumps	12	46	1261	2	plumps
plumy	12	42	1323	2	plum_y
shlumpy	17	4	286	2	shlumpy
slummy	13	32	586	2	slummy
slump	9	48	1663	2	slump_
slumps	10	43	1358	2	slumps
stumpy	13	45	813	2	stumpy

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.220	812231.8
2	DLD Change Limit	82551	43	4.030	20484.1
3	Display Results	43	43	0.000
	(SQL Overall)	178691	43	4.250	42044.9