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

Here are the results of your fuzzy-string dictionary search for “plumps” 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
plumps	12	46	1261	(None)
clumps	12	153	1464	1	clumps
flumps	13	51	1250	1	flumps
lumps	9	56	2498	1	_lumps
plumbs	12	45	933	1	plumbs
plumes	10	43	1813	1	plumes
plump	11	53	1526	1	plump_
plums	9	46	1995	1	plum_s
pumps	11	55	2060	1	p_umps
slumps	10	43	1358	1	slumps
alums	7	57	2060	2	alum_s
blimps	12	58	815	2	blimps
blumes	10	59	1779	2	blumes
bumps	11	59	2114	2	_bumps
chumps	15	43	1382	2	chumps
clamps	12	45	1508	2	clamps
clomps	12	52	1223	2	clomps
clump	11	55	1745	2	clump_
clumpy	15	40	957	2	clumpy
crumps	12	45	1434	2	crumps
dumps	10	52	2010	2	_dumps
flumes	11	51	1973	2	flumes
flump	12	46	1472	2	flump_
frumps	13	47	978	2	frumps
glumes	9	45	1681	2	glumes
glumpy	14	52	719	2	glumpy
glums	8	46	2142	2	glum_s
grumps	11	45	1057	2	grumps
humps	12	63	2280	2	_humps
jumps	16	51	1649	2	_jumps
lamps	9	56	2483	2	_lamps
limps	9	55	2267	2	_limps
lumas	7	56	2291	2	_lumas
lump	8	65	3170	2	_lump_
lumpy	12	66	1591	2	_lumpy
lums	6	57	3424	2	_lum_s
mumps	11	56	1910	2	_mumps
pimps	11	46	1698	2	p_imps
plops	9	59	2033	2	pl_ops
plucks	14	37	973	2	plucks
plugs	8	52	1349	2	plu_gs
plum	8	51	2210	2	plum__
plumb	11	45	1407	2	plum_b
plume	9	48	1946	2	plum_e
plumed	11	44	1288	2	plumed
plummy	15	37	566	2	plummy
plumose	11	3	596	2	plumose
plumped	14	31	864	2	plumped
plumpen	13	27	640	2	plumpen
plumpens	14	30	495	2	plumpens
plumper	13	31	878	2	plumper
plumpers	14	35	730	2	plumpers
plumpest	14	23	635	2	plumpest
plumpish	17	16	473	2	plumpish
plumply	16	3	422	2	plumply
plumy	12	42	1323	2	plum_y
plunks	12	47	1116	2	plunks
plus	6	63	2483	2	plu__s
pluses	8	36	1807	2	pluses
pomps	11	53	1619	2	p_omps
primps	12	47	1182	2	primps
pulps	9	51	1648	2	p_ulps
pumas	9	51	2156	2	p_umas
pump	10	57	2685	2	p_ump_
pups	8	60	3223	2	p_u_ps
rumps	9	59	2229	2	_rumps
shlumps	14	3	414	2	shlumps
slump	9	48	1663	2	slump_
slums	7	46	2343	2	slum_s
slurps	8	44	1000	2	slurps
stumps	10	49	1228	2	stumps
sumps	9	50	2343	2	_sumps
thumps	13	44	935	2	thumps
trumps	10	46	1188	2	trumps
tumps	9	54	2079	2	_tumps
umps	8	57	2194	2	__umps
whumps	16	42	709	2	whumps

Search took 3 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.343	520965.0
2	DLD Change Limit	82551	77	2.220	37185.1
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	2.593	68912.8