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

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

98 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
lumpy	12	66	1591	(None)
bumpy	14	47	1505	1	bumpy
clumpy	15	40	957	1	clumpy
dumpy	13	54	1475	1	dumpy
glumpy	14	52	719	1	glumpy
humpy	15	51	1567	1	humpy
jumpy	19	57	1281	1	jumpy
lump	8	65	3170	1	lump_
lumps	9	56	2498	1	lumps
bump	10	62	2824	2	bump_
bumph	14	49	1198	2	bumph
bumps	11	59	2114	2	bumps
buppy	14	48	1007	2	buppy
campy	14	51	1618	2	campy
clump	11	55	1745	2	clump_
clumps	12	153	1464	2	clumps
clumsy	13	32	619	2	clumsy
cuppy	14	47	1038	2	cuppy
dumky	15	45	1134	2	dumky
dummy	13	47	1278	2	dummy
dump	9	59	2709	2	dump_
dumps	10	52	2010	2	dumps
flump	12	46	1472	2	flump_
flumps	13	51	1250	2	flumps
frumpy	16	46	688	2	frumpy
fumy	12	71	1858	2	fum_y
gimpy	13	52	1223	2	gimpy
glumly	12	35	662	2	glumly
grumpy	14	49	815	2	grumpy
gulpy	11	46	1276	2	gulpy
gummy	13	54	1365	2	gummy
guppy	13	52	1127	2	guppy
hempy	15	49	1276	2	hempy
hump	11	62	2872	2	hump_
humph	15	57	1221	2	humph
humps	12	63	2280	2	humps
jimpy	19	52	1082	2	jimpy
jump	15	66	2172	2	jump_
jumps	16	51	1649	2	jumps
lamby	12	51	1484	2	lamby
lamp	8	62	3382	2	lamp_
lamps	9	56	2483	2	lamps
limby	12	57	1407	2	limby
limey	10	47	2104	2	limey
limp	8	84	3249	2	limp_
limpa	9	70	1446	2	limpa
limply	13	38	1003	2	limply
limps	9	55	2267	2	limps
limpsy	13	51	684	2	limpsy
limy	9	57	2771	2	lim_y
lippy	12	45	1190	2	lippy
loopy	10	53	1664	2	loopy
loppy	12	59	1166	2	loppy
lucky	14	55	1501	2	lucky
lum	5	55	4293	2	lum__
luma	6	55	2752	2	lum_a
lumas	7	56	2291	2	lumas
lumen	7	52	2090	2	lumen
lumped	11	42	1696	2	lumped
lumpen	10	40	1066	2	lumpen
lumper	10	38	1665	2	lumper
lumpily	14	7	656	2	lumpily
lums	6	57	3424	2	lum_s
luny	7	73	2413	2	lu_ny
lusty	8	54	1757	2	lusty
lymph	15	4	704	2	lymph
mummy	11	49	1362	2	mummy
mump	10	54	2572	2	mump_
mumps	11	56	1910	2	mumps
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
pulpy	12	46	1236	2	pulpy
pump	10	57	2685	2	pump_
pumps	11	55	2060	2	pumps
puppy	11	49	1241	2	puppy
rummy	12	42	1241	2	rummy
rump	8	67	2908	2	rump_
rumply	13	34	857	2	rumply
rumps	9	59	2229	2	rumps
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
sump	8	63	3153	2	sump_
sumps	9	50	2343	2	sumps
tummy	12	47	1199	2	tummy
tump	8	59	2703	2	tump_
tumps	9	54	2079	2	tumps
ump	7	61	3044	2	_ump_
umps	8	57	2194	2	_umps
vampy	15	53	940	2	vampy
wimpy	15	59	1192	2	wimpy
yummy	15	42	915	2	yummy
yuppy	15	48	791	2	yuppy

Search took 2 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	53800	0.310	576422.6
2	DLD Change Limit	53800	98	1.423	37807.4
3	Display Results	98	98	0.016	6125.0
	(SQL Overall)	178691	98	1.749	102167.5