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

Here are the results of your fuzzy-string dictionary search for “cheapens” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

157 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
cheapens	15	30	594	(None)
cheapen	14	40	762	1	cheapen_
chapels	14	42	915	2	ch_apels
chapes	13	54	2187	2	ch_ape_s
cheapened	17	4	378	2	cheapened
cheapener	16	4	377	2	cheapener
cheapeners	17	4	311	2	cheapeners
cheaper	14	40	1058	2	cheape_r
cheapest	15	3	607	2	cheapest
cheapies	15	3	903	2	cheapies
cheapness	16	4	374	2	cheapness
cheapos	14	41	851	2	cheap_os
cheaps	13	46	1368	2	cheap__s
cheaters	13	36	1351	2	cheaters
cheepers	15	32	901	2	cheepers
heapers	12	36	1667	2	_heapers
heavens	13	43	930	2	_heavens
wheatens	14	5	466	2	wheatens
canapes	11	12	1308	3	canape_s
capers	10	54	2814	3	c__apers
capes	9	54	4192	3	c__ape_s
capons	10	41	1950	3	c__apons
ceases	8	44	2707	3	c_ease_s
cepes	9	44	2446	3	c_e_pe_s
chafers	15	45	1274	3	ch_afers
chafes	14	50	1791	3	ch_afe_s
chaines	12	45	1873	3	ch_aines
chains	11	48	1970	3	ch_a_ins
chalehs	15	26	880	3	ch_alehs
chalets	12	28	1347	3	ch_alets
champers	17	33	1162	3	champers
chape	12	52	2114	3	ch_ape__
chapeau	14	3	552	3	ch_apeau
chapeaus	15	4	499	3	ch_apeaus
chapel	13	49	1137	3	ch_ape_l
chaperons	16	4	689	3	ch_aperons
chaplets	15	5	688	3	ch_aplets
chapmen	16	3	728	3	ch_apmen_
chaps	12	53	2606	3	ch_ap__s
chapters	15	40	1213	3	ch_apters
chares	11	56	3180	3	ch_are_s
chasers	12	37	1492	3	ch_asers
chases	11	51	2823	3	ch_ase_s
chastens	13	42	918	3	chastens
chawers	15	44	1205	3	ch_awers
chazans	21	26	812	3	ch_azans
chazzens	21	25	394	3	chazzens
cheap	12	69	1594	3	cheap___
cheapening	18	8	380	3	cheapening
cheapie	14	3	756	3	cheap_ie
cheapish	18	4	433	3	cheapish
cheaply	17	3	502	3	cheap_ly
cheapo	13	48	1008	3	cheap__o
cheated	13	44	1634	3	cheate_d
cheater	12	48	1696	3	cheate_r
cheating	14	40	1452	3	cheating
cheats	11	45	1954	3	chea__ts
chebecs	16	3	501	3	che_becs
checkers	19	31	784	3	checkers
cheders	13	45	1239	3	che_ders
cheeks	15	47	1278	3	che__eks
cheeped	15	34	1059	3	cheepe_d
cheeper	14	36	1074	3	cheepe_r
cheeping	16	32	955	3	cheeping
cheeps	13	53	1291	3	che__eps
cheerers	13	31	954	3	cheerers
cheers	11	45	1891	3	che__ers
cheeses	12	36	1310	3	cheese_s
chegoes	13	3	733	3	chegoe_s
chelates	13	27	1384	3	chelate_s
chelipeds	17	4	300	3	chelipeds
chequers	22	3	410	3	chequers
cheques	21	3	686	3	cheque_s
chesses	12	41	1263	3	chesse_s
chevalets	17	4	338	3	chevalets
chevies	15	35	1144	3	chevie_s
chevres	15	37	979	3	chevre_s
chevrets	16	25	532	3	chevrets
chevrons	16	6	546	3	chevrons
chewers	15	41	1114	3	che_wers
chickens	19	26	743	3	chickens
chippers	17	35	1088	3	chippers
chirpers	15	35	813	3	chirpers
chompers	17	36	959	3	chompers
chopins	14	23	1224	3	ch_opins
choppers	17	41	1046	3	choppers
chortens	13	30	879	3	chortens
cleaners	10	36	1054	3	cleaners
cleans	8	58	1705	3	clea__ns
clearers	10	34	930	3	clearers
cleavers	13	39	887	3	cleavers
cleaves	12	41	1162	3	cleave_s
clepes	10	42	1462	3	cle_pe_s
copens	10	61	1996	3	c__opens
crapes	10	47	2769	3	c_rape_s
cravens	12	40	1012	3	c_ravens
creamers	12	41	1131	3	creamers
creasers	10	36	1284	3	creasers
creases	9	40	2096	3	crease_s
creates	9	52	2520	3	create_s
creatins	10	36	1751	3	creatins
creepers	12	31	863	3	creepers
crepes	10	54	1934	3	cre_pe_s
crepons	11	3	932	3	cre_pons
crispens	12	28	625	3	crispens
deadens	9	34	1069	3	_deadens
deafens	11	31	725	3	_deafens
deepens	10	30	781	3	_deepens
greatens	9	30	759	3	greatens
happens	14	35	917	3	_happens
haptens	12	45	1134	3	_h_aptens
havens	12	45	1404	3	_h_avens
headend	12	39	836	3	_headend
headends	13	32	672	3	_headends
headers	11	38	1939	3	_headers
headpins	14	3	610	3	_headpins
healers	10	43	1946	3	_healers
heaped	12	45	1690	3	_heape_d
heaper	11	41	1952	3	_heape_r
heaping	13	30	1585	3	_heaping
heaps	10	52	2322	3	_heap__s
hearers	10	43	1978	3	_hearers
hearkens	15	33	669	3	_hearkens
heartens	11	30	1015	3	_heartens
heaters	10	42	2522	3	_heaters
heathens	14	32	1015	3	_heathens
heaven	12	39	1260	3	_heaven_
heavers	13	37	1719	3	_heavers
heaves	12	41	2030	3	_heave_s
helpers	12	33	1185	3	_helpers
hempen	13	3	896	3	_hempen_
herpes	11	55	1732	3	_herpe_s
khazens	23	3	266	3	kh_azens
leadens	8	36	1098	3	_leadens
leapers	9	37	1666	3	_leapers
leavens	10	40	930	3	_leavens
neatens	7	33	1040	3	_neatens
peahens	12	30	757	3	_peahens
reapers	9	35	2045	3	_reapers
reopens	9	3	937	3	_reopens
shapen	11	44	1465	3	sh_apen_
shapers	12	40	1689	3	sh_apers
shapes	11	51	2495	3	sh_ape_s
sharpens	13	37	781	3	sharpens
shearers	11	39	1132	3	shearers
sheaves	13	44	1297	3	sheave_s
shebeens	13	4	333	3	shebeens
sheens	9	51	1699	3	she__ens
shippens	15	31	680	3	shippens
steepens	10	27	711	3	steepens
theaters	11	42	1190	3	theaters
threapers	14	4	477	3	threapers
threatens	12	5	467	3	threatens
weakens	14	36	706	3	_weakens
weapons	12	27	860	3	_weapons
wheaten	13	3	640	3	wheaten_
wheens	12	46	1061	3	whe__ens

Search took 9 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	146162	0.440	406115.9
2	DLD Change Limit	146162	157	7.936	18417.6
3	Display Results	157	157	0.046	3413.0
	(SQL Overall)	178691	157	8.422	21217.2