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

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

327 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
deodar	8	3	771	(None)
deodara	9	4	524	1	deodara
deodars	9	3	762	1	deodars
cedar	8	40	1432	2	ce_dar
deader	8	42	2047	2	deader
dear	5	53	4360	2	de__ar
debar	8	55	1786	2	de_bar
decoder	11	37	1229	2	decoder
dedal	7	57	1902	2	de_dal
denar	6	52	2329	2	de_nar
deodand	10	3	571	2	deodand
deodaras	10	4	469	2	deodaras
dewar	9	58	1773	2	de_war
doodad	9	3	642	2	doodad
feodary	14	4	471	2	feodary
anodal	7	25	1212	3	anodal
apodal	9	28	983	3	apodal
areolar	7	7	922	3	areolar
beader	9	46	2379	3	beader
bear	6	68	4464	3	be__ar
bedder	10	42	1579	3	bedder
beggar	10	32	822	3	beggar
beldam	11	4	1011	3	beldam
benday	12	38	1081	3	benday
bender	9	52	2330	3	bender
bezoar	17	3	691	3	bezoar
boar	6	61	3429	3	_bo_ar
bolar	7	51	2347	3	_bolar
boyar	10	60	1376	3	_boyar
cedarn	9	40	844	3	ce_darn
cedars	9	33	1283	3	ce_dars
cedary	12	41	960	3	ce_dary
ceder	8	53	2224	3	ce_der
cellar	8	45	1498	3	cellar
chadar	12	3	935	3	chadar
cheddar	14	25	473	3	cheddar
coda	7	70	2935	3	_coda_
codas	8	47	2424	3	_codas
coder	8	61	3422	3	_coder
dada	6	64	2245	3	d_ada_
dadas	7	58	1986	3	d_adas
daedal	8	4	908	3	daedal
damar	8	41	1775	3	d_amar
dammar	11	43	891	3	dammar
dander	8	112	2299	3	dander
darbar	9	5	996	3	darbar
dead	6	54	3424	3	de__ad
deaden	8	37	1432	3	deaden
deadly	11	38	1147	3	deadly
deadman	11	23	842	3	deadman
deadpan	11	22	523	3	deadpan
deads	7	57	2691	3	dead_s
deaf	8	58	3840	3	de__af
deafer	10	41	1481	3	deafer
deair	6	58	1719	3	de_air
deal	5	63	4741	3	de__al
dealer	7	41	2214	3	dealer
dean	5	60	3948	3	de__an
dearer	7	48	2280	3	dearer
dears	6	57	3688	3	de__ars
deary	9	58	2684	3	de__ary
debag	9	42	1230	3	de_bag
debark	13	42	1094	3	de_bark
debars	9	42	1804	3	de_bars
debeak	13	3	676	3	debeak
debeard	11	3	735	3	debeard
debonair	11	4	288	3	debonair
deboner	10	31	1048	3	deboner
debtor	9	3	833	3	debtor
decadal	11	3	724	3	decadal
decade	10	42	1616	3	decade
decaf	11	49	1944	3	de_caf
decal	8	55	2323	3	de_cal
decare	9	39	1915	3	de_care
decay	11	47	1848	3	de_cay
deciare	10	7	1066	3	deciare
decider	11	42	1318	3	decider
decker	13	52	1599	3	decker
declare	10	4	1123	3	declare
declaw	12	6	670	3	declaw
decode	10	44	1474	3	decod_e
decoded	12	32	1239	3	decoded
decoders	12	28	1041	3	decoders
decodes	11	39	1498	3	decodes
decolor	10	8	703	3	decolor
decor	8	47	1757	3	de_cor
decoyer	13	34	868	3	decoyer
dedans	8	59	1507	3	de_dans
deed	6	53	4090	3	deed__
deeded	9	46	1554	3	deeded
deedier	9	30	1159	3	deedier
deeds	7	54	2376	3	deed_s
deedy	10	43	1589	3	deed_y
deejay	17	3	452	3	deejay
deeper	9	36	1350	3	deeper
deer	5	67	3902	3	de__er
deewan	10	26	755	3	deewan
defat	9	54	2669	3	de_fat
defeat	10	38	1716	3	defeat
defer	9	46	1975	3	de_fer
deffer	13	44	1130	3	deffer
defier	10	51	1865	3	defier
defoam	12	3	856	3	defoam
defrag	11	3	646	3	defrag
defray	13	3	764	3	defray
defter	10	42	1592	3	defter
degas	7	51	1916	3	de_gas
deicer	9	41	1441	3	deicer
dekare	11	28	1156	3	de_kare
delay	9	48	2063	3	de_lay
delead	8	41	1234	3	delead
delta	6	61	1777	3	delta_
deltas	7	44	1482	3	deltas
deluder	9	16	833	3	deluder
delver	10	49	1349	3	delver
demark	13	42	1102	3	de_mark
demean	9	5	1056	3	demean
demode	10	40	1346	3	demod_e
demoded	12	36	1112	3	demoded
demur	8	3	1116	3	de_mur
denari	7	109	1735	3	de_nari
denars	7	46	2143	3	de_nars
denary	10	53	1686	3	de_nary
denial	7	47	2051	3	denial
denier	7	44	2069	3	denier
denser	7	41	1519	3	denser
dental	7	43	1917	3	dental
denuder	9	16	760	3	denuder
deodands	11	4	460	3	deodands
deoxy	16	4	888	3	deo_xy
depart	9	47	2056	3	de_part
deposal	10	3	715	3	deposal
deposer	10	40	1184	3	deposer
derat	6	50	4408	3	de_rat
deray	9	50	2418	3	de_ray
derider	9	32	1497	3	derider
derma	8	49	1852	3	derma_
dermal	9	36	1435	3	dermal
dermas	9	41	1682	3	dermas
desman	9	3	1169	3	desman
despair	10	4	546	3	despair
desugar	9	4	403	3	desugar
deter	6	50	2804	3	de_ter
detour	7	7	819	3	detour
deva	8	57	2098	3	de_va_
devas	9	62	1888	3	de_vas
devoir	10	7	603	3	devoir
devour	10	7	670	3	devour
dewan	9	57	1804	3	de_wan
dewars	10	51	1707	3	de_wars
dewax	16	55	1085	3	de_wax
dewier	10	40	1346	3	dewier
dewlap	12	6	484	3	dewlap
dexter	14	38	1089	3	dexter
dhoora	10	3	565	3	dhoora
dinar	6	63	1989	3	d_inar
diode	7	47	1612	3	diod_e
diodes	8	39	1578	3	diodes
dioxan	14	6	577	3	dioxan
dipolar	10	5	685	3	dipolar
disbar	9	3	851	3	disbar
doat	5	69	4767	3	d_o_at
dobra	8	50	1310	3	d_obra
dodder	9	47	1291	3	dodder
dodge	8	66	1813	3	d_odge
dodger	9	58	1705	3	d_odger
dodgy	11	66	1146	3	d_odgy
dodo	6	60	2492	3	d_od_o
dodos	7	58	1939	3	d_odos
doer	5	77	3470	3	d_o_er
dogear	8	3	819	3	dogear
dollar	7	41	1098	3	dollar
dolor	6	76	1796	3	d_olor
domal	8	56	1920	3	d_omal
dona	5	55	2963	3	d_ona_
donas	6	59	2647	3	d_onas
donor	6	44	1819	3	d_onor
doodads	10	3	509	3	doodads
doodle	8	32	1285	3	doodle
doodler	9	33	1015	3	doodler
doodoo	8	10	889	3	doodoo
doody	10	55	1791	3	dood_y
door	5	69	2851	3	d_o_or
doozer	16	39	1046	3	doozer
dopa	7	72	2090	3	d_opa_
dopas	8	50	1906	3	d_opas
doper	8	61	2839	3	d_oper
dor	4	72	5392	3	d_o__r
dorr	5	66	2772	3	d_o_rr
doser	6	62	2856	3	d_oser
dotal	6	49	1962	3	d_otal
dotard	8	3	905	3	d_otard
doter	6	54	2862	3	d_oter
dour	5	63	3043	3	d_o_ur
doura	6	65	1866	3	d_oura
dower	9	50	2770	3	d_ower
dozer	15	84	1927	3	d_ozer
drear	6	50	1690	3	d_rear
droner	7	47	1767	3	droner
drover	10	46	1459	3	drover
durbar	9	6	872	3	durbar
ear	3	68	6788	3	_e__ar
eggar	7	45	888	3	_eggar
eider	6	46	2475	3	_eider
elder	6	40	2002	3	_elder
embar	9	40	1160	3	_embar
endear	7	41	1001	3	_endear
ender	6	43	2586	3	_ender
escar	7	40	1199	3	_escar
eskar	9	45	745	3	_eskar
fear	7	53	3779	3	fe__ar
fedora	10	3	859	3	fedora
feeder	10	35	1384	3	feeder
fender	10	37	1872	3	fender
feod	8	155	2300	3	feod__
feods	9	95	1685	3	feod_s
feuar	8	3	1024	3	fe_uar
feudal	10	3	768	3	feudal
feudary	14	4	427	3	feudary
gaydar	11	3	550	3	gaydar
gear	5	59	3497	3	ge__ar
gelder	8	46	1371	3	gelder
gender	8	35	1793	3	gender
geode	7	4	1259	3	geod_e
geodes	8	4	1215	3	geodes
geodic	10	4	800	3	geodic
geoidal	9	3	671	3	geoidal
header	10	44	2254	3	header
hear	7	61	4388	3	he__ar
heder	9	56	2364	3	he_der
heeder	10	42	1604	3	heeder
herder	10	45	1646	3	herder
heyday	16	3	514	3	heyday
hoar	7	67	2916	3	_ho_ar
hodad	10	3	1135	3	_hodad
isobar	8	3	614	3	isobar
jemadar	17	4	337	3	jemadar
jemidar	17	4	416	3	jemidar
jeopard	17	4	411	3	jeopard
jowar	15	52	1143	3	_jowar
kebar	11	51	1353	3	ke_bar
keddah	15	3	427	3	keddah
leader	7	48	2465	3	leader
lear	4	70	4595	3	le__ar
lekvar	13	3	304	3	lekvar
lender	7	39	2128	3	lender
leopard	10	4	529	3	leopard
leotard	8	4	619	3	leotard
lewder	10	47	961	3	lewder
lidar	6	3	1273	3	_lidar
lobar	7	3	1301	3	_lobar
medal	8	62	2133	3	me_dal
medlar	9	30	1046	3	medlar
melder	9	39	1581	3	melder
mender	9	35	2079	3	mender
modal	8	59	1924	3	_modal
molar	7	52	2309	3	_molar
near	4	52	3650	3	ne__ar
nectar	8	3	885	3	nectar
needer	7	36	1495	3	needer
nodal	6	47	1779	3	_nodal
oar	3	70	5795	3	__o_ar
oda	4	81	3305	3	__oda_
odah	8	70	1893	3	__odah
odas	5	72	3026	3	__odas
odor	5	57	1809	3	__odor
osar	4	68	2095	3	__osar
pear	6	97	4523	3	pe__ar
pedal	8	60	2250	3	pe_dal
pedlar	9	33	1127	3	pedlar
polar	7	56	2345	3	_polar
prowar	11	41	1094	3	prowar
qindar	16	31	717	3	qindar
radar	6	13	1672	3	_radar
reader	7	36	2829	3	reader
rear	4	56	4455	3	re__ar
rebar	7	54	2019	3	re_bar
redan	6	61	2501	3	re_dan
redder	8	39	1814	3	redder
redear	7	35	1517	3	redear
regear	7	35	1274	3	regear
rehear	9	37	1322	3	rehear
render	7	40	2414	3	render
reorder	8	23	948	3	reorder
retear	6	31	1548	3	retear
rewear	9	30	1200	3	rewear
roar	4	63	2857	3	_ro_ar
sardar	7	30	1318	3	sardar
sear	4	73	5384	3	se__ar
secpar	10	3	793	3	secpar
sedan	6	56	2042	3	se_dan
seder	6	48	2676	3	se_der
seeder	7	43	2077	3	seeder
seggar	8	35	781	3	seggar
sendal	7	33	1499	3	sendal
sender	7	38	2441	3	sender
serdab	9	3	783	3	serdab
serovar	10	4	614	3	serovar
sewar	8	54	2110	3	se_war
shofar	12	3	631	3	shofar
sirdar	7	26	910	3	sirdar
soar	4	68	3867	3	_so_ar
soda	5	63	2939	3	_soda_
sodas	6	41	2354	3	_sodas
sofar	8	61	1549	3	_sofar
solar	5	59	2734	3	_solar
sonar	5	65	2342	3	_sonar
sowar	8	58	2134	3	_sowar
tear	4	52	4288	3	te__ar
tedder	8	33	1216	3	tedder
tender	7	41	2184	3	tender
teopan	8	3	935	3	teopan
today	9	64	1695	3	_today
tolar	5	55	2411	3	_tolar
trocar	8	4	877	3	trocar
velar	8	58	1763	3	ve_lar
vender	10	34	1842	3	vender
vendor	10	35	980	3	vendor
volar	8	69	1741	3	_volar
wear	7	58	3672	3	we__ar
wedder	11	36	1230	3	wedder
weeder	10	33	1551	3	weeder
welder	10	29	1441	3	welder
weldor	10	31	765	3	weldor
year	7	65	3425	3	ye__ar
yeoman	11	3	882	3	yeoman
zedoary	20	4	321	3	zedoary

Search took 7 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.376	475242.0
2	DLD Change Limit	112716	327	5.530	20382.6
3	Display Results	327	327	0.110	2972.7
	(SQL Overall)	178691	327	6.016	29702.6