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

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

86 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
chomps	15	51	1222	(None)
champs	15	49	1568	1	champs
chimps	15	57	1366	1	chimps
chomp	14	48	1566	1	chomp_
chops	12	50	1987	1	cho_ps
chumps	15	43	1382	1	chumps
clomps	12	52	1223	1	clomps
comps	11	55	2605	1	c_omps
whomps	16	45	760	1	whomps
camps	11	63	3026	2	c_amps
champ	14	50	1796	2	champ_
champy	18	50	961	2	champy
chams	12	60	2850	2	cham_s
chaps	12	53	2606	2	ch_aps
cheaps	13	46	1368	2	cheaps
cheeps	13	53	1291	2	cheeps
chemos	13	3	1172	2	chemos
chimbs	15	39	1030	2	chimbs
chimes	13	49	2257	2	chimes
chimp	14	52	1647	2	chimp_
chips	12	57	2125	2	ch_ips
chirps	13	54	1400	2	chirps
chocks	17	48	1531	2	chocks
choirs	11	49	1188	2	choirs
chokes	15	49	1738	2	chokes
cholas	11	48	1800	2	cholas
cholos	11	47	1685	2	cholos
chomped	17	32	977	2	chomped
chomper	16	38	1007	2	chomper
chompers	17	36	959	2	chompers
chooks	15	53	1279	2	chooks
chop	11	60	2492	2	cho_p_
choppy	18	37	629	2	choppy
chords	12	52	1463	2	chords
chores	11	48	2802	2	chores
chorus	11	50	1477	2	chorus
choses	11	58	2513	2	choses
chotts	11	36	1099	2	chotts
chows	13	56	1820	2	cho_ws
chromas	14	25	1269	2	chromas
chromes	14	29	1493	2	chromes
chromos	14	26	1027	2	chromos
chump	14	53	1544	2	chump_
chums	12	50	1583	2	chum_s
chymes	16	59	1215	2	chymes
clamps	12	45	1508	2	clamps
clomp	11	56	1570	2	clomp_
clops	9	59	2485	2	clo_ps
clumps	12	153	1464	2	clumps
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
hemps	12	69	1733	2	_hemps
homes	10	69	3881	2	_homes
homos	10	59	2178	2	_homos
hoops	10	56	2107	2	_hoops
hops	9	79	4263	2	_ho_ps
humps	12	63	2280	2	_humps
pomps	11	53	1619	2	_pomps
rhombs	13	33	649	2	rhombs
romps	9	46	1754	2	_romps
shops	10	42	2290	2	sho_ps
stomps	10	56	1283	2	stomps
thorps	11	36	1089	2	thorps
thumps	13	44	935	2	thumps
tromps	10	49	1170	2	tromps
whomp	15	50	1132	2	whomp_
whoops	14	48	786	2	whoops
whops	13	50	1393	2	who_ps
whumps	16	42	709	2	whumps

Search took 4 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.360	496363.9
2	DLD Change Limit	82551	86	2.720	30349.6
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	3.110	57456.9