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

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

90 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
chomp	14	48	1566	(None)
champ	14	50	1796	1	champ
chimp	14	52	1647	1	chimp
chomps	15	51	1222	1	chomps
chop	11	60	2492	1	cho_p
chump	14	53	1544	1	chump
clomp	11	56	1570	1	clomp
comp	10	67	3125	1	c_omp
whomp	15	50	1132	1	whomp
camp	10	63	3645	2	c_amp
cham	11	55	3231	2	cham_
champs	15	49	1568	2	champs
champy	18	50	961	2	champy
chams	12	60	2850	2	chams
chap	11	49	2849	2	ch_ap
cheap	12	69	1594	2	cheap
cheep	12	54	1650	2	cheep
chemo	12	3	1363	2	chemo
chimb	14	48	1356	2	chimb
chime	12	53	2259	2	chime
chimps	15	57	1366	2	chimps
chip	11	67	2642	2	ch_ip
chirp	12	47	1716	2	chirp
chock	16	43	1661	2	chock
choir	10	53	1360	2	choir
choke	14	51	1802	2	choke
choky	17	57	1122	2	choky
chola	10	47	1803	2	chola
cholo	10	52	1797	2	cholo
chomped	17	32	977	2	chomped
chomper	16	38	1007	2	chomper
chon	9	66	2779	2	cho_n
chook	14	60	1504	2	chook
choppy	18	37	629	2	choppy
chops	12	50	1987	2	chops
chord	11	59	1726	2	chord
chore	10	51	2676	2	chore
chose	10	59	2540	2	chose
chott	10	39	2393	2	chott
chow	12	58	2099	2	cho_w
chows	13	56	1820	2	chows
chroma	13	29	1247	2	chroma
chrome	13	32	1481	2	chrome
chromo	13	28	1101	2	chromo
chromy	16	30	990	2	chromy
chum	11	63	1800	2	chum_
chumps	15	43	1382	2	chumps
chums	12	50	1583	2	chums
chyme	15	65	1250	2	chyme
clamp	11	55	1765	2	clamp
clomb	11	57	1470	2	clomb
clomps	12	52	1223	2	clomps
clop	8	69	2989	2	clo_p
clump	11	55	1745	2	clump
coma	8	71	3485	2	c_oma
comb	10	66	3211	2	c_omb
come	8	75	4770	2	c_ome
compo	11	53	1857	2	c_ompo
comps	11	55	2605	2	c_omps
compt	11	63	2822	2	c_ompt
coomb	11	56	1570	2	coomb
coop	8	72	3865	2	c_oop
cop	7	111	6237	2	c_o_p
coup	8	67	2979	2	c_oup
cramp	11	51	2069	2	cramp
crimp	11	56	1580	2	crimp
crop	8	76	2863	2	cro_p
croup	9	56	1678	2	croup
crump	11	56	1642	2	crump
hemp	11	57	2562	2	_hemp
holp	9	57	2755	2	_holp
home	9	80	4244	2	_home
homo	9	61	2647	2	_homo
homy	12	66	2322	2	_homy
hoop	9	61	2998	2	_hoop
hop	8	75	5459	2	_ho_p
hump	11	62	2872	2	_hump
pomp	10	62	2546	2	_pomp
rhomb	12	39	980	2	rhomb
romp	8	59	2657	2	_romp
shop	9	56	2984	2	sho_p
stomp	9	56	1666	2	stomp
thorp	10	44	1426	2	thorp
thump	12	62	1157	2	thump
tromp	9	58	1580	2	tromp
whom	12	70	1818	2	whom_
whomps	16	45	760	2	whomps
whoop	13	42	1144	2	whoop
whop	12	55	2092	2	who_p
whump	15	49	1004	2	whump

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.310	576422.6
2	DLD Change Limit	53800	90	1.626	33087.3
3	Display Results	90	90	0.016	5625.0
	(SQL Overall)	178691	90	1.952	91542.5