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

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

88 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
clomps	12	52	1223	(None)
chomps	15	51	1222	1	chomps
clamps	12	45	1508	1	clamps
clomp	11	56	1570	1	clomp_
clops	9	59	2485	1	clo_ps
clumps	12	153	1464	1	clumps
comps	11	55	2605	1	c_omps
blimps	12	58	815	2	blimps
bloops	10	66	1134	2	bloops
camps	11	63	3026	2	c_amps
celoms	10	4	1212	2	celom_s
champs	15	49	1568	2	champs
chimps	15	57	1366	2	chimps
chomp	14	48	1566	2	chomp_
chops	12	50	1987	2	cho_ps
chumps	15	43	1382	2	chumps
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
cleomes	11	3	881	2	cleomes
climbs	12	49	872	2	climbs
climes	10	47	2000	2	climes
clips	9	60	1830	2	cl_ips
cloaks	12	44	1126	2	cloaks
clocks	14	49	1623	2	clocks
clods	8	53	2086	2	clo_ds
clogs	8	55	1955	2	clo_gs
clomb	11	57	1470	2	clom_b
clomped	14	39	897	2	clomped
clones	8	45	2656	2	clones
clonks	12	50	1347	2	clonks
clons	7	52	2813	2	clo_ns
clonus	8	52	1241	2	clonus
cloots	8	51	1369	2	cloots
clop	8	69	2989	2	clo_p_
closes	8	54	2559	2	closes
cloths	11	55	1248	2	cloths
clots	7	56	2764	2	clo_ts
clouds	9	46	1235	2	clouds
clours	8	52	1509	2	clours
clouts	8	70	1720	2	clouts
cloves	11	49	1882	2	cloves
clowns	11	48	1011	2	clowns
cloys	10	49	1694	2	clo_ys
clozes	17	49	1556	2	clozes
clump	11	55	1745	2	clump_
clumpy	15	40	957	2	clumpy
comas	9	58	3300	2	c_omas
combs	11	61	2296	2	c_ombs
comes	9	72	4699	2	c_omes
comp	10	67	3125	2	c_omp_
compas	12	58	1706	2	c_ompas
compo	11	53	1857	2	c_ompo
compos	12	48	1880	2	c_ompos
compt	11	63	2822	2	c_ompt
compts	12	52	1665	2	c_ompts
coombs	12	42	1019	2	coombs
coops	9	62	2964	2	c_oops
cops	8	67	5137	2	c_o_ps
corps	9	59	2704	2	c_orps
coups	9	55	2247	2	c_oups
cramps	12	56	1556	2	cramps
crimps	12	46	1345	2	crimps
crops	9	61	2523	2	cro_ps
croups	10	43	1255	2	croups
crumps	12	45	1434	2	crumps
flops	10	59	2014	2	flo_ps
flumps	13	51	1250	2	flumps
gloms	8	52	1978	2	glom_s
glomus	9	46	809	2	glomus
glops	8	56	1955	2	glo_ps
lamps	9	56	2483	2	_lamps
limps	9	55	2267	2	_limps
loops	7	57	2396	2	_loops
lops	6	60	4335	2	_lo_ps
loups	7	53	1962	2	_loups
lumps	9	56	2498	2	_lumps
plops	9	59	2033	2	plo_ps
plumps	12	46	1261	2	plumps
pomps	11	53	1619	2	_pomps
romps	9	46	1754	2	_romps
sloops	8	55	1362	2	sloops
slops	7	50	2601	2	slo_ps
slumps	10	43	1358	2	slumps
stomps	10	56	1283	2	stomps
tromps	10	49	1170	2	tromps
whomps	16	45	760	2	whomps

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	88	2.440	33832.4
3	Display Results	88	88	0.016	5500.0
	(SQL Overall)	178691	88	2.799	63841.0