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

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

323 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
cedarn	9	40	844	(None)
cedar	8	40	1432	1	cedar_
cedars	9	33	1283	1	cedars
cedary	12	41	960	1	cedary
bedamn	11	3	781	2	bedamn
carn	6	62	4543	2	c__arn
ceder	8	53	2224	2	ceder_
ceders	9	38	1767	2	ceders
darn	5	64	3462	2	__darn
earn	4	67	3755	2	_e_arn
learn	5	53	2266	2	le_arn
redan	6	61	2501	2	reda_n
reearn	6	6	1214	2	reearn
sedan	6	56	2042	2	seda_n
yearn	8	63	1643	2	ye_arn
adorn	6	49	1709	3	_adorn
barn	6	64	4464	3	__barn
bean	6	64	4386	3	be_a_n
bear	6	68	4464	3	be_ar_
beard	8	60	2496	3	be_ard
bears	7	57	3904	3	be_ars
bedamns	12	3	573	3	bedamns
bedarken	15	4	451	3	bedarken
bedaub	11	4	603	3	bedaub
bedpan	11	3	758	3	bedpan
beduin	9	3	971	3	beduin
bedward	14	9	747	3	bedward
bedwarf	16	10	646	3	bedwarf
began	8	63	1957	3	bega_n
beware	11	3	1371	3	beware
cadre	8	54	1902	3	cad_re
caesar	8	4	1093	3	caesar_
caesars	9	4	1073	3	caesars
cain	6	56	4391	3	c__ain
cairn	7	57	1751	3	c_airn
can	5	77	6014	3	c__a_n
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
car	5	91	6556	3	c__ar_
carb	8	51	4316	3	c__arb
carbarn	11	3	945	3	carbarn
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
carns	7	59	3756	3	c__arns
carny	10	58	2292	3	c__arny
carp	8	51	3981	3	c__arp
carr	6	54	3470	3	c__arr
cars	6	73	6476	3	c__ars
cart	6	65	7034	3	c__art
casern	8	47	1331	3	casern
cavern	11	53	1245	3	cavern
cease	7	52	2765	3	ce_ase
ceca	8	48	2078	3	ceca__
cecal	9	46	1911	3	ceca_l
cede	7	49	2877	3	ced__e
ceded	9	61	1856	3	ced_ed
cedes	8	49	2733	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
celadon	10	3	691	3	celadon
celery	11	3	962	3	celery
cellar	8	45	1498	3	cellar_
cellars	9	37	1369	3	cellars
centare	9	31	1370	3	centare
centra	8	41	1388	3	centra
centre	8	43	1664	3	centre
ceorl	7	4	1092	3	ce_orl
cerate	8	48	2946	3	cerate
ceratin	9	30	2016	3	ceratin
cere	6	67	4147	3	ce__re
cero	6	63	2945	3	ce__ro
certain	9	26	1221	3	certain
cesarean	10	4	462	3	cesarean
cesarian	10	4	818	3	cesarian
cesura	8	3	876	3	cesura
cetane	8	3	1528	3	cetane
chadar	12	3	935	3	chadar_
chadars	13	3	829	3	chadars
chadri	12	3	814	3	chadri
chain	10	57	2367	3	c_hain
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
chars	10	59	3664	3	c_hars
chart	10	50	3828	3	c_hart
chary	13	50	2313	3	c_hary
cheddar	14	25	473	3	cheddar_
cheddars	15	23	438	3	cheddars
cheddary	18	29	333	3	cheddary
cheder	12	51	1349	3	cheder_
cheders	13	45	1239	3	cheders
churn	10	51	1310	3	c_hurn
cider	8	47	2331	3	cider_
ciders	9	46	2009	3	ciders
cigar	8	9	1180	3	cigar_
cigars	9	9	1072	3	cigars
clan	6	56	3392	3	c_la_n
claro	7	50	1869	3	c_laro
clary	10	57	1961	3	c_lary
clean	7	54	2041	3	clea_n
clear	7	62	1905	3	clear_
clears	8	41	1656	3	clears
cocain	10	13	1501	3	cocain
coda	7	70	2934	3	coda__
codas	8	47	2424	3	coda_s
codein	9	49	1672	3	codein
coden	8	61	2854	3	cod_en
coder	8	61	3422	3	coder_
coders	9	54	2698	3	coders
codlin	9	45	1644	3	codlin
codon	8	65	2285	3	cod_on
corn	6	99	4581	3	c__orn
cotan	7	15	2178	3	cota_n
covary	14	3	874	3	covary
coward	12	4	1167	3	coward
credal	9	3	1167	3	creda_l
cumarin	11	3	926	3	cumarin
curara	8	37	1220	3	curara
curare	8	49	1695	3	curare
curari	8	44	1440	3	curari
curn	6	67	3189	3	c__urn
curran	8	3	1202	3	curran
cyan	9	64	1962	3	c_ya_n
cyder	11	46	1113	3	cyder_
cyders	12	39	883	3	cyders
cymar	12	57	1126	3	cymar_
cymars	13	59	915	3	cymars
czar	15	60	1313	3	c_zar_
czars	16	48	1291	3	c_zars
damn	7	57	2432	3	__damn
dan	4	68	5967	3	__da_n
darb	7	60	3353	3	__darb
dare	5	58	4886	3	__dare
dark	9	51	3321	3	__dark
darns	6	69	2789	3	__darns
dart	5	58	5787	3	__dart
dawn	8	56	2420	3	__dawn
deaden	8	37	1432	3	deaden
dean	5	60	3948	3	de_a_n
dear	5	53	4360	3	de_ar_
dears	6	57	3688	3	de_ars
deary	9	58	2684	3	de_ary
debar	8	55	1786	3	debar_
debark	13	42	1094	3	debark
debars	9	42	1804	3	debars
decare	9	39	1915	3	decare
decern	9	13	1095	3	decern
dedal	7	57	1902	3	deda_l
dedans	8	59	1507	3	dedans
dehorn	10	43	965	3	dehorn
dekare	11	28	1156	3	dekare
demark	13	42	1102	3	demark
denar	6	52	2329	3	denar_
denari	7	109	1735	3	denari
denars	7	46	2143	3	denars
denary	10	53	1686	3	denary
deodar	8	3	771	3	deodar_
deodara	9	4	524	3	deodara
deodars	9	3	762	3	deodars
depart	9	47	2056	3	depart
detain	7	46	1738	3	detain
dewan	9	57	1804	3	dewa_n
dewar	9	58	1773	3	dewar_
dewars	10	51	1707	3	dewars
durn	5	61	2763	3	__durn
ear	3	68	6788	3	_e_ar_
earl	4	58	3814	3	_e_arl
earns	5	59	2756	3	_e_arns
ears	4	63	5659	3	_e_ars
echard	12	4	922	3	echard
elain	5	53	2470	3	_elain
elan	4	67	3424	3	_ela_n
ern	3	57	3836	3	_e__rn
fear	7	53	3779	3	fe_ar_
fears	8	48	2939	3	fe_ars
fedora	10	3	859	3	fedora
feodary	14	4	471	3	feodary
fern	7	61	2932	3	fe__rn
feuar	8	3	1024	3	feuar_
feuars	9	3	865	3	feuars
feudary	14	4	427	3	feudary
gear	5	59	3497	3	ge_ar_
gears	6	46	2869	3	ge_ars
goldarn	9	4	438	3	goldarn
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
heder	9	56	2364	3	heder_
heders	10	41	1976	3	heders
hegari	10	3	952	3	hegari
heparin	12	4	1043	3	heparin
hern	7	61	3489	3	he__rn
iceman	10	3	785	3	icema_n
jean	11	66	2928	3	je_a_n
karn	8	61	2941	3	__karn
kebar	11	51	1353	3	kebar_
kebars	12	41	1249	3	kebars
kern	8	53	2621	3	ke__rn
leaden	7	45	1522	3	leaden
lean	4	63	4524	3	le_a_n
lear	4	70	4595	3	le_ar_
learns	6	55	1374	3	le_arns
learnt	6	40	1925	3	le_arnt
lears	5	59	3873	3	le_ars
leary	8	59	2738	3	le_ary
leman	7	56	2260	3	lema_n
lidar	6	3	1272	3	lidar_
lidars	7	3	1078	3	lidars
mean	6	55	3809	3	me_a_n
medaka	13	3	634	3	medaka
medal	8	62	2133	3	meda_l
medals	9	42	1806	3	medals
median	9	41	1754	3	median
medlar	9	30	1046	3	medlar_
medlars	10	25	944	3	medlars
megara	9	3	1009	3	megara
megaron	10	24	830	3	megaron
modern	9	3	952	3	modern
near	4	52	3650	3	ne_ar_
nears	5	55	2942	3	ne_ars
ocean	7	12	1296	3	oce_a_n
ordain	7	8	1040	3	ordain
pean	6	61	4717	3	pe_a_n
pear	6	97	4523	3	pe_ar_
pearl	7	53	2446	3	pe_arl
pears	7	51	3861	3	pe_ars
peart	7	64	4075	3	pe_art
pecan	9	19	1903	3	peca_n
pedal	8	60	2250	3	peda_l
pedalo	9	38	1115	3	pedalo
pedals	9	43	1603	3	pedals
pedant	9	3	1949	3	pedant
pedate	9	31	1776	3	pedate
pedlar	9	33	1127	3	pedlar_
pedlars	10	32	1021	3	pedlars
pedlary	13	27	754	3	pedlary
pedro	8	3	1315	3	ped_ro
pekan	11	16	1397	3	peka_n
petard	9	50	1380	3	petard
predawn	13	3	535	3	predawn
prewarn	12	44	1015	3	prewarn
radar	6	13	1672	3	radar_
radars	7	13	1467	3	radars
readorn	8	3	1048	3	readorn
rear	4	56	4455	3	re_ar_
rearm	7	59	2357	3	re_arm
rears	5	47	3965	3	re_ars
rebar	7	54	2019	3	rebar_
rebars	8	40	1983	3	rebars
reborn	8	100	1696	3	reborn
redact	9	4	1904	3	redact
redans	7	54	2102	3	redans
redate	7	41	2468	3	redate
redden	8	36	1362	3	redden
redear	7	35	1517	3	redear_
redears	8	28	1445	3	redears
redfin	10	3	1022	3	redfin
redon	6	54	2488	3	red_on
redraw	10	26	985	3	redraw
redrawn	11	24	595	3	redrawn
redry	9	43	1436	3	red_ry
redware	11	3	936	3	redware
reearns	7	4	910	3	reearns
regain	7	45	1776	3	regain
regard	8	52	1577	3	regard
relearn	7	4	797	3	relearn
remain	8	59	1986	3	remain
reman	7	57	3015	3	rema_n
remark	12	35	1237	3	remark
repark	12	35	1171	3	repark
reran	5	73	2910	3	rera_n
resawn	9	39	995	3	resawn
retain	6	45	2328	3	retain
retard	7	50	1893	3	retard
retorn	6	109	2343	3	retorn
return	6	232	2252	3	return
rewan	8	56	2366	3	rewa_n
reward	10	60	1764	3	reward
rewarm	11	59	1349	3	rewarm
reworn	9	81	2220	3	reworn
sear	4	73	5384	3	se_ar_
sears	5	47	4491	3	se_ars
secern	8	10	1022	3	secern
sedans	7	48	1609	3	sedans
sedarim	10	4	711	3	sedarim
sedate	7	30	1981	3	sedate
seder	6	48	2676	3	seder_
seders	7	44	2028	3	seders
senary	9	37	1607	3	senary
sewan	8	59	2129	3	sewa_n
sewar	8	54	2110	3	sewar_
sewars	9	40	1863	3	sewars
sharn	8	48	2370	3	_sharn
sudary	10	3	870	3	sudary
tarn	4	68	4272	3	__tarn
tear	4	52	4288	3	te_ar_
tears	5	54	3646	3	te_ars
teary	8	51	2405	3	te_ary
tern	4	61	3480	3	te__rn
updart	9	3	1074	3	updart
vegan	9	51	1415	3	vega_n
velar	8	58	1763	3	velar_
velars	9	39	1372	3	velars
warn	7	52	3932	3	__warn
wean	7	57	3435	3	we_a_n
wear	7	58	3672	3	we_ar_
wears	8	60	3030	3	we_ars
weary	11	56	2061	3	we_ary
wedeln	10	32	669	3	wedeln
yarn	7	52	3004	3	__yarn
yean	7	58	3458	3	ye_a_n
year	7	65	3425	3	ye_ar_
yearns	9	50	954	3	ye_arns
years	8	45	2767	3	ye_ars
zedoary	20	4	321	3	zedoary

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.720	248181.9
2	DLD Change Limit	112716	323	6.796	16585.6
3	Display Results	323	323	0.106	3047.2
	(SQL Overall)	178691	323	7.622	23444.1