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

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

419 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
cedary	12	41	960	(None)
cedar	8	40	1432	1	cedar_
cedarn	9	40	844	1	cedarn
cedars	9	33	1283	1	cedars
canary	11	3	1469	2	canary
ceder	8	53	2223	2	ceder_
ceders	9	38	1767	2	ceders
celery	11	3	962	2	celery
chary	13	50	2313	2	c_hary
cheddary	18	29	333	2	cheddary
clary	10	57	1961	2	c_lary
covary	14	3	874	2	covary
deary	9	58	2684	2	de_ary
denary	10	53	1686	2	denary
feodary	14	4	471	2	feodary
feudary	14	4	427	2	feudary
leary	8	59	2738	2	le_ary
pedlary	13	27	754	2	pedlary
redry	9	43	1436	2	red_ry
senary	9	37	1607	2	senary
sudary	10	3	870	2	sudary
teary	8	51	2405	2	te_ary
weary	11	56	2061	2	we_ary
zedoary	20	4	321	2	zedoary
actuary	12	4	561	3	actuary
aery	7	72	3168	3	ae__ry
alary	8	61	2344	3	_alary
ambary	13	40	1054	3	ambary
angary	10	3	1132	3	angary
apiary	11	39	1038	3	apiary
ariary	9	41	1420	3	ariary
aviary	12	33	841	3	aviary
aweary	12	3	730	3	aweary
beady	11	47	1992	3	be_ady
beaky	14	61	1802	3	be_aky
beamy	12	62	1857	3	be_amy
bear	6	68	4464	3	be_ar_
beard	8	60	2496	3	be_ard
bears	7	57	3904	3	be_ars
bedamn	11	3	781	3	bedamn
bedaub	11	4	603	3	bedaub
bedirty	13	4	418	3	bedirty
bedward	14	9	747	3	bedward
bedwarf	16	10	646	3	bedwarf
beery	10	52	2012	3	be_ery
beggary	14	31	615	3	beggary
belady	12	48	993	3	belady
belay	10	50	2152	3	bela_y
belfry	14	3	507	3	belfry
benday	12	38	1081	3	benda_y
berry	10	45	2177	3	be_rry
betray	11	15	1144	3	betray
beware	11	3	1371	3	beware
beweary	15	3	622	3	beweary
bewray	14	14	773	3	bewray
binary	11	3	1222	3	binary
bleary	11	51	1255	3	bleary
briary	11	49	1200	3	briary
caddy	12	54	1402	3	cad_dy
cadgy	12	52	1078	3	cad_gy
cadre	8	54	1901	3	cad_re
caesar	8	4	1093	3	caesar_
caesars	9	4	1072	3	caesars
cagy	10	63	2199	3	c__agy
caky	13	62	2244	3	c__aky
calory	11	3	1284	3	calory
calvary	15	3	718	3	calvary
canard	9	3	1476	3	canard
car	5	91	6556	3	c__ar_
carb	8	51	4316	3	c__arb
card	7	102	4587	3	c__ard
care	6	69	6837	3	c__are
cark	10	55	3927	3	c__ark
carl	6	51	4478	3	c__arl
carn	6	62	4543	3	c__arn
carny	10	58	2292	3	c__arny
carp	8	51	3981	3	c__arp
carr	6	54	3470	3	c__arr
carry	10	58	2378	3	c_arry
cars	6	73	6476	3	c__ars
cart	6	65	7034	3	c__art
catenary	13	4	658	3	catenary
cavalry	15	5	496	3	cavalry
cavy	12	59	2000	3	c__avy
cay	8	71	5598	3	c__a_y
cease	7	52	2765	3	ce_ase
ceca	8	48	2078	3	ceca__
cecal	9	46	1911	3	ceca_l
cecally	14	5	939	3	cecally
cecity	13	9	815	3	cecity
cede	7	49	2876	3	ced__e
ceded	9	61	1855	3	ced_ed
cedes	8	49	2732	3	ced_es
cedi	7	49	1927	3	ced__i
ceding	10	40	1480	3	ceding
cedis	8	43	1708	3	ced_is
cedula	9	7	764	3	cedula
cellar	8	45	1498	3	cellar_
cellars	9	37	1369	3	cellars
centare	9	31	1370	3	centare
centaury	13	4	395	3	centaury
centra	8	41	1388	3	centra
centre	8	43	1664	3	centre
century	12	3	719	3	century
ceorl	7	4	1091	3	ce_orl
cerate	8	48	2946	3	cerate
cere	6	67	4147	3	ce__re
cero	6	63	2945	3	ce__ro
cesura	8	3	876	3	cesura
cetane	8	3	1528	3	cetane
chadar	12	3	934	3	chadar_
chadars	13	3	827	3	chadars
chadri	12	3	813	3	chadri
char	9	51	3215	3	c_har_
chard	11	61	2474	3	c_hard
chare	10	52	3198	3	c_hare
chark	14	42	2271	3	c_hark
charm	12	61	2466	3	c_harm
charr	10	48	2178	3	c_harr
charry	14	50	1211	3	charry
chars	10	59	3663	3	c_hars
chart	10	50	3828	3	c_hart
chay	12	49	2487	3	c_ha_y
cheddar	14	25	473	3	cheddar_
cheddars	15	23	437	3	cheddars
cheder	12	51	1349	3	cheder_
cheders	13	45	1239	3	cheders
cheery	14	49	1315	3	cheery
cherry	14	48	1076	3	cherry
cider	8	47	2331	3	cider_
ciders	9	46	2008	3	ciders
cigar	8	9	1179	3	cigar_
cigars	9	9	1071	3	cigars
ciliary	12	4	792	3	ciliary
cindery	13	42	919	3	cindery
cinerary	13	4	643	3	cinerary
claro	7	50	1869	3	c_laro
clay	9	59	2741	3	c_la_y
clear	7	62	1905	3	clear_
clearly	12	3	666	3	clearly
clears	8	41	1656	3	clears
coaly	10	55	2159	3	c_oaly
coda	7	70	2934	3	coda__
codas	8	47	2424	3	coda_s
coder	8	61	3421	3	coder_
coders	9	54	2697	3	coders
codify	15	3	716	3	codify
cometary	15	4	769	3	cometary
copay	12	65	1631	3	copa_y
cory	9	69	4151	3	c__ory
coward	12	4	1167	3	coward
cowry	13	55	1248	3	c_owry
crazy	19	55	1122	3	c_razy
creaky	15	49	1155	3	creaky
creamy	13	48	1136	3	creamy
creasy	11	46	1230	3	creasy
credal	9	3	1167	3	creda_l
croaky	15	52	848	3	croaky
cry	8	97	2624	3	c___ry
cuddly	13	38	841	3	cuddly
cuddy	12	51	1197	3	cud_dy
curacy	13	3	959	3	curacy
curara	8	37	1220	3	curara
curare	8	49	1695	3	curare
curari	8	44	1440	3	curari
curry	10	59	2034	3	c_urry
cyder	11	46	1113	3	cyder_
cyders	12	39	883	3	cyders
cymar	12	57	1126	3	cymar_
cymars	13	59	914	3	cymars
czar	15	60	1313	3	c_zar_
czars	16	48	1291	3	c_zars
dairy	9	70	1630	3	__dairy
darb	7	60	3353	3	__darb
dare	5	58	4886	3	__dare
dark	9	51	3321	3	__dark
darky	13	60	1883	3	__darky
darn	5	64	3462	3	__darn
dart	5	58	5787	3	__dart
datary	10	3	1024	3	datary
davy	11	60	1552	3	__davy
day	7	62	5411	3	__da_y
deadly	11	38	1147	3	deadly
dear	5	53	4360	3	de_ar_
dearly	10	46	1532	3	de_arly
dears	6	57	3688	3	de_ars
debar	8	55	1786	3	debar_
debark	13	42	1094	3	debark
debars	9	42	1804	3	debars
decare	9	39	1915	3	decare
decay	11	47	1848	3	deca_y
decenary	14	4	627	3	decenary
decry	11	55	1435	3	de_cry
decury	12	7	796	3	decury
dedal	7	57	1902	3	deda_l
dedans	8	59	1507	3	dedans
defray	13	3	764	3	defray
dekare	11	28	1156	3	dekare
delay	9	48	2063	3	dela_y
demark	13	42	1102	3	demark
denar	6	52	2329	3	denar_
denari	7	109	1735	3	denari
denars	7	46	2143	3	denars
deodar	8	3	771	3	deodar_
deodara	9	4	524	3	deodara
deodars	9	3	762	3	deodars
depart	9	47	2056	3	depart
deray	9	50	2418	3	dera_y
derry	9	47	2137	3	de_rry
descry	12	5	618	3	descry
dewar	9	58	1773	3	dewar_
dewars	10	51	1707	3	dewars
diary	9	50	1697	3	_diary
dietary	11	5	866	3	dietary
dory	8	58	3623	3	__dory
dray	8	54	2809	3	__dray
dreary	10	46	1167	3	dreary
dry	7	65	2603	3	__d_ry
ear	3	68	6788	3	_e_ar_
earl	4	58	3814	3	_e_arl
early	8	53	2412	3	_e_arly
earn	4	67	3755	3	_e_arn
ears	4	63	5659	3	_e_ars
easy	7	62	2449	3	_e_asy
echard	12	4	922	3	echard
eddy	9	39	1209	3	_ed_dy
edgy	9	47	1352	3	_ed_gy
edify	12	30	856	3	_edify
eery	7	61	2962	3	_e_ery
emery	10	48	1433	3	_emery
entry	8	24	1426	3	_entry
every	11	52	1545	3	_every
eyry	10	63	1588	3	_e_yry
fear	7	53	3779	3	fe_ar_
fears	8	48	2939	3	fe_ars
fedora	10	3	859	3	fedora
ferry	11	60	2080	3	fe_rry
feuar	8	3	1024	3	feuar_
feuars	9	3	865	3	feuars
friary	12	40	1009	3	friary
gear	5	59	3497	3	ge_ar_
gears	6	46	2869	3	ge_ars
gentry	10	34	1044	3	gentry
glary	9	60	1854	3	_glary
heady	12	51	1726	3	he_ady
heapy	13	59	1498	3	he_apy
hear	7	61	4388	3	he_ar_
heard	9	52	2275	3	he_ard
hears	8	67	3737	3	he_ars
heart	8	54	4074	3	he_art
hearty	12	63	1363	3	he_arty
heavy	14	48	1418	3	he_avy
heder	9	56	2363	3	heder_
heders	10	41	1976	3	heders
hedgy	13	45	1074	3	hed_gy
hegari	10	3	951	3	hegari
henry	11	40	1447	3	he_nry
herry	11	49	2247	3	he_rry
heyday	16	3	514	3	heyda_y
hoary	11	45	1676	3	_hoary
horary	12	3	1038	3	horary
jerry	15	50	1618	3	je_rry
kebar	11	51	1353	3	kebar_
kebars	12	41	1249	3	kebars
kerry	12	49	1609	3	ke_rry
leady	9	56	1860	3	le_ady
leafy	11	63	1621	3	le_afy
leaky	12	52	1772	3	le_aky
lear	4	70	4595	3	le_ar_
learn	5	53	2266	3	le_arn
lears	5	59	3873	3	le_ars
leavy	11	57	1577	3	le_avy
ledgy	10	57	1201	3	led_gy
leery	8	59	1913	3	le_ery
legacy	12	5	665	3	legacy
lidar	6	3	1272	3	lidar_
lidars	7	3	1078	3	lidars
mealy	10	44	2218	3	me_aly
meany	10	46	2047	3	me_any
meaty	10	70	2131	3	me_aty
medaka	13	3	634	3	medaka
medal	8	62	2132	3	meda_l
medals	9	42	1804	3	medals
medfly	15	3	522	3	medfly
mediacy	15	3	614	3	mediacy
medlar	9	30	1046	3	medlar_
medlars	10	25	944	3	medlars
medley	12	9	833	3	medley
megara	9	3	1009	3	megara
memory	13	3	880	3	memory
merry	10	47	2148	3	me_rry
nary	7	69	3122	3	__nary
near	4	52	3650	3	ne_ar_
nearby	11	35	605	3	ne_arby
nearly	9	48	1373	3	ne_arly
nears	5	55	2942	3	ne_ars
nectary	12	4	622	3	nectary
neddy	10	47	987	3	ned_dy
notary	9	23	1071	3	notary
ovary	11	4	911	3	_ovary
peaky	14	57	1815	3	pe_aky
pear	6	97	4523	3	pe_ar_
pearl	7	53	2446	3	pe_arl
pearly	11	64	1484	3	pe_arly
pears	7	51	3861	3	pe_ars
peart	7	64	4075	3	pe_art
peaty	10	57	2569	3	pe_aty
peavy	13	50	1484	3	pe_avy
peccary	16	3	628	3	peccary
pedal	8	60	2250	3	peda_l
pedalo	9	38	1114	3	pedalo
pedals	9	43	1603	3	pedals
pedant	9	3	1949	3	pedant
pedantry	14	4	405	3	pedantry
pedate	9	31	1776	3	pedate
pedlar	9	33	1127	3	pedlar_
pedlars	10	32	1021	3	pedlars
pedlery	13	29	707	3	pedlery
pedro	8	3	1315	3	ped_ro
peery	10	57	1944	3	pe_ery
peltry	11	28	865	3	peltry
penury	11	4	810	3	penury
perry	10	52	2271	3	pe_rry
pessary	12	4	687	3	pessary
petard	9	50	1380	3	petard
plenary	12	3	754	3	plenary
predry	12	3	786	3	pred_ry
radar	6	13	1672	3	radar_
radars	7	13	1466	3	radars
ready	9	48	2150	3	re_ady
rear	4	56	4455	3	re_ar_
rearm	7	59	2356	3	re_arm
rears	5	47	3965	3	re_ars
rebar	7	54	2019	3	rebar_
rebars	8	40	1982	3	rebars
rebury	11	34	921	3	rebury
recarry	12	4	506	3	recarry
redact	9	4	1904	3	redact
redan	6	61	2501	3	reda_n
redans	7	54	2102	3	redans
redate	7	41	2468	3	redate
redbay	12	3	833	3	redbay
redear	7	35	1517	3	redear_
redears	8	28	1445	3	redears
redefy	13	38	876	3	redefy
redeny	10	27	1273	3	redeny
redly	9	42	1719	3	red_ly
redraw	10	26	985	3	redraw
redware	11	3	935	3	redware
reearn	6	6	1214	3	reearn
refry	11	44	1246	3	re_fry
regard	8	52	1577	3	regard
relay	8	44	2467	3	rela_y
remark	12	35	1237	3	remark
remarry	12	3	519	3	remarry
repark	12	35	1171	3	repark
repay	10	48	1845	3	repa_y
resay	8	53	2054	3	resa_y
retard	7	50	1893	3	retard
retiary	10	3	833	3	retiary
retry	8	47	1808	3	re_try
revery	12	40	1421	3	revery
reward	10	60	1763	3	reward
rewarm	11	59	1348	3	rewarm
rosary	9	28	1035	3	rosary
rotary	9	24	1130	3	rotary
rudery	10	41	903	3	rudery
salary	9	5	1521	3	salary
scary	10	52	2259	3	_scary
scenery	12	3	655	3	scenery
seamy	10	59	2127	3	se_amy
sear	4	73	5384	3	se_ar_
sears	5	47	4491	3	se_ars
sectary	12	3	827	3	sectary
sedan	6	56	2042	3	seda_n
sedans	7	48	1609	3	sedans
sedarim	10	4	710	3	sedarim
sedate	7	30	1980	3	sedate
seder	6	48	2675	3	seder_
seders	7	44	2028	3	seders
sedgy	10	45	1278	3	sed_gy
sentry	9	29	1205	3	sentry
serry	8	48	2412	3	se_rry
sewar	8	54	2109	3	sewar_
sewars	9	40	1862	3	sewars
smeary	11	41	1080	3	smeary
sugary	10	3	901	3	sugary
tear	4	52	4288	3	te_ar_
tears	5	54	3646	3	te_ars
teddy	10	48	949	3	ted_dy
ternary	10	3	834	3	ternary
terry	8	47	2187	3	te_rry
tetany	9	5	984	3	tetany
today	9	64	1695	3	toda_y
unary	8	3	1599	3	_unary
unwary	12	3	982	3	unwary
updart	9	3	1074	3	updart
updry	11	3	548	3	upd_ry
vagary	13	3	733	3	vagary
vary	10	52	2606	3	__vary
vealy	11	58	1777	3	ve_aly
veery	11	58	1625	3	ve_ery
velar	8	58	1763	3	velar_
velars	9	39	1372	3	velars
venery	12	37	1066	3	venery
very	10	80	2564	3	ve__ry
vestry	12	3	862	3	vestry
vicenary	16	5	497	3	vicenary
vivary	15	3	698	3	vivary
votary	12	24	833	3	votary
wary	10	67	4001	3	__wary
wear	7	58	3672	3	we_ar_
wears	8	60	3030	3	we_ars
wedgy	13	47	979	3	wed_gy
year	7	65	3425	3	ye_ar_
yearly	12	52	1027	3	ye_arly
yearn	8	63	1643	3	ye_arn
years	8	45	2767	3	ye_ars
zonary	18	3	879	3	zonary

Search took 8 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	419	7.126	15817.6
3	Display Results	419	419	0.170	2464.7
	(SQL Overall)	178691	419	7.436	24030.5