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

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

87 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
dumpy	13	54	1475	(None)
bumpy	14	47	1505	1	bumpy
dumky	15	45	1134	1	dumky
dummy	13	47	1278	1	dummy
dump	9	59	2709	1	dump_
dumps	10	52	2010	1	dumps
humpy	15	51	1567	1	humpy
jumpy	19	57	1281	1	jumpy
lumpy	12	66	1591	1	lumpy
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
clumpy	15	40	957	2	clumpy
cuppy	14	47	1038	2	cuppy
damp	9	62	2884	2	damp_
damply	14	33	789	2	damply
damps	10	52	2041	2	damps
demy	10	54	2285	2	dem_y
dimly	11	49	1348	2	dimly
dimply	14	33	974	2	dimply
dippy	13	51	1154	2	dippy
dopy	10	62	2415	2	d_opy
drumly	12	3	570	2	drumly
duchy	14	43	1087	2	duchy
ducky	15	42	1611	2	ducky
duddy	11	49	1103	2	duddy
dully	9	49	2163	2	dully
duly	8	53	2303	2	du_ly
duma	7	55	2445	2	dum_a
dumas	8	54	2043	2	dumas
dumb	9	71	2410	2	dum_b
dumbly	14	39	960	2	dumbly
dumbo	10	56	1406	2	dumbo
dumbs	10	59	1575	2	dumbs
dumka	12	43	883	2	dumka
dumped	12	38	1449	2	dumped
dumper	11	46	1521	2	dumper
dumpily	15	6	623	2	dumpily
dungy	10	47	1364	2	dungy
dup	6	76	3788	2	du_p_
dupe	7	66	3060	2	du_pe
dups	7	59	2951	2	du_ps
dusky	13	52	1304	2	dusky
dusty	9	60	1832	2	dusty
duty	8	53	2145	2	du_ty
frumpy	16	46	688	2	frumpy
fumy	12	71	1858	2	fum_y
gimpy	13	52	1223	2	gimpy
glumpy	14	52	719	2	glumpy
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
lump	8	65	3170	2	lump_
lumps	9	56	2498	2	lumps
mummy	11	49	1362	2	mummy
mump	10	54	2572	2	mump_
mumps	11	56	1910	2	mumps
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
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.096	1861364.6
2	DLD Change Limit	53800	87	1.530	35163.4
3	Display Results	87	87	0.016	5437.5
	(SQL Overall)	178691	87	1.642	108825.2