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

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

82 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
clumps	12	153	1464	(None)
chumps	15	43	1382	1	chumps
clamps	12	45	1508	1	clamps
clomps	12	52	1223	1	clomps
clump	11	55	1745	1	clump_
clumpy	15	40	957	1	clumpy
crumps	12	45	1434	1	crumps
flumps	13	51	1250	1	flumps
lumps	9	56	2498	1	_lumps
plumps	12	46	1261	1	plumps
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
camps	11	63	3026	2	c_amps
champs	15	49	1568	2	champs
chimps	15	57	1366	2	chimps
chomps	15	51	1222	2	chomps
chump	14	53	1544	2	chump_
chums	12	50	1583	2	chum_s
clamp	11	55	1765	2	clamp_
clams	9	51	2767	2	clam_s
claps	9	56	2618	2	cl_aps
clasps	10	45	1209	2	clasps
climbs	12	49	872	2	climbs
climes	10	47	2000	2	climes
clips	9	60	1830	2	cl_ips
clomp	11	56	1570	2	clomp_
clops	9	59	2485	2	cl_ops
clubs	9	54	1510	2	clu_bs
clucks	14	45	1207	2	clucks
clues	7	46	2303	2	clu_es
clumped	14	36	1066	2	clumped
clumpish	17	16	489	2	clumpish
clumsy	13	32	619	2	clumsy
clunks	12	48	1101	2	clunks
columns	11	3	647	2	columns
comps	11	55	2605	2	c_omps
coups	9	55	2247	2	cou_ps
cramps	12	56	1556	2	cramps
crimps	12	46	1345	2	crimps
crumbs	12	40	923	2	crumbs
crump	11	56	1642	2	crump_
culms	9	53	1419	2	culm_s
cups	8	54	3082	2	c_u_ps
cusps	9	49	1367	2	c_usps
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
plumbs	12	45	933	2	plumbs
plumes	10	43	1813	2	plumes
plump	11	53	1526	2	plump_
plums	9	46	1995	2	plum_s
pumps	11	55	2060	2	_pumps
rumps	9	59	2229	2	_rumps
schlumps	17	4	274	2	schlumps
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 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.216	827273.1
2	DLD Change Limit	82551	82	4.283	19274.1
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	4.529	39454.8