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

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

456 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
datary	10	3	1024	(None)
alary	8	61	2344	2	_alary
ataxy	15	3	731	2	_ataxy
canary	11	3	1469	2	canary
dairy	9	70	1630	2	da_iry
damar	8	41	1774	2	damar_
damars	9	38	1500	2	damars
dastard	9	27	970	2	dastard
data	5	60	2665	2	data__
dater	6	53	3231	2	dater_
daters	7	48	2737	2	daters
datura	7	3	803	2	datura
daubry	12	44	548	2	daubry
deary	9	58	2684	2	d_eary
denary	10	53	1686	2	denary
diary	9	50	1697	2	d_iary
dietary	11	5	866	2	dietary
dotard	8	3	905	2	dotard
dreary	10	46	1167	2	dreary
eatery	9	53	1635	2	eatery
lactary	12	3	785	2	lactary
notary	9	23	1071	2	notary
ratany	9	34	1187	2	ratany
rotary	9	24	1130	2	rotary
salary	9	5	1521	2	salary
satara	6	3	1553	2	satara
satay	8	47	1846	2	sata_y
tatar	5	61	2206	2	tatar_
tatars	6	46	1979	2	tatars
vagary	13	3	733	2	vagary
votary	12	24	833	2	votary
watery	12	39	1449	2	watery
acari	7	50	2028	3	_acari
actuary	12	4	561	3	actuary
aery	7	72	3168	3	_a_ery
afar	7	67	2078	3	_afar_
afars	8	57	1651	3	_afars
agar	5	87	2641	3	_agar_
agars	6	61	2064	3	_agars
airy	7	57	3415	3	_a_iry
ajar	11	62	1770	3	_ajar_
alar	4	63	4007	3	_alar_
alarm	7	66	2142	3	_alarm
altar	5	55	2064	3	altar_
altars	6	45	1815	3	altars
amatory	12	3	864	3	amatory
ambary	13	40	1054	3	ambary
ambry	12	35	1210	3	_ambry
angary	10	3	1132	3	angary
angry	9	3	1087	3	_angry
apart	7	43	3067	3	_apart
apery	10	65	1790	3	_apery
apiary	11	39	1038	3	apiary
ariary	9	41	1420	3	ariary
array	8	63	1714	3	_array
artery	9	9	1145	3	artery
astray	9	56	1554	3	astray
atap	6	67	2245	3	_ata_p
ataps	7	64	1483	3	_ataps
ataraxy	17	4	398	3	_ataraxy
atomy	10	74	1519	3	_atomy
atony	8	72	1885	3	_atony
atopy	10	68	1339	3	_atopy
attar	5	65	1669	3	attar_
attars	6	45	1531	3	attars
autarky	14	4	470	3	autarky
avatar	9	3	752	3	avatar_
avatars	10	3	644	3	avatars
aviary	12	33	841	3	aviary
award	9	71	1804	3	_award
aware	8	64	2002	3	_aware
away	10	80	2422	3	_awa_y
aweary	12	3	730	3	aweary
awry	10	76	1968	3	_a_wry
bakery	15	59	1100	3	bakery
bastard	10	30	1242	3	bastard
bastardy	14	32	600	3	bastardy
batboy	13	8	753	3	batboy
battery	12	49	1181	3	battery
batty	10	54	2224	3	bat_ty
bawdry	15	51	646	3	bawdry
bayard	12	44	1166	3	bayard
bazar	16	38	1600	3	bazar_
bazars	17	46	1311	3	bazars
betray	11	15	1144	3	betray
binary	11	3	1222	3	binary
bleary	11	51	1255	3	bleary
botany	11	3	926	3	botany
briary	11	49	1200	3	briary
calory	11	3	1284	3	calory
calvary	15	3	718	3	calvary
canard	9	3	1476	3	canard
carry	10	58	2378	3	ca_rry
catalo	8	3	1485	3	catalo
catarrh	12	4	501	3	catarrh
catchy	16	55	958	3	catchy
catenary	13	4	658	3	catenary
cater	7	48	4072	3	cater_
caters	8	53	3650	3	caters
cattery	12	38	1160	3	cattery
catty	10	45	2041	3	cat_ty
cautery	12	34	959	3	cautery
cavalry	15	5	496	3	cavalry
cavitary	16	6	496	3	cavitary
cedary	12	41	960	3	cedary
chary	13	50	2313	3	_chary
clary	10	57	1961	3	_clary
covary	14	3	874	3	covary
dada	6	64	2244	3	dada__
dadas	7	58	1986	3	dada_s
daddy	11	62	1256	3	da_ddy
daffy	15	55	1028	3	da_ffy
dafter	10	48	1334	3	dafter_
daftly	13	3	544	3	daftly
daily	9	59	2233	3	da_ily
dainty	10	53	1147	3	dainty
daisy	9	59	1531	3	da_isy
dalasi	7	6	1062	3	dalasi
dally	9	53	2474	3	da_lly
damage	10	4	1078	3	damage
daman	8	48	2116	3	dama_n
damans	9	47	1598	3	damans
damask	13	3	584	3	damask
dammar	11	43	890	3	dammar_
dammars	12	30	819	3	dammars
damply	14	33	789	3	damply
dandy	10	44	1670	3	da_ndy
dangly	11	42	1227	3	dangly
dankly	14	41	946	3	dankly
darb	7	60	3353	3	d__arb
darbar	9	5	995	3	darbar_
darbars	10	5	1009	3	darbars
dare	5	58	4886	3	d__are
darer	6	52	3079	3	darer_
darers	7	59	2187	3	darers
dark	9	51	3321	3	d__ark
darkey	14	52	1242	3	darkey
darkly	14	54	1107	3	darkly
darky	13	60	1883	3	da_rky
darn	5	64	3462	3	d__arn
dart	5	58	5787	3	d__art
darter	7	53	2036	3	darter_
darters	8	40	1760	3	darters
dashy	12	56	1238	3	da_shy
dastardly	14	27	380	3	dastardly
dastards	10	27	808	3	dastards
datable	10	17	1423	3	datable
dataries	9	3	1403	3	dataries
datcha	12	6	656	3	datcha
date	5	64	4332	3	dat__e
dated	7	55	3099	3	dat_ed
datedly	12	3	602	3	datedly
dates	6	56	3915	3	dat_es
dating	8	53	2648	3	dating
dative	10	3	1181	3	dative
dato	5	61	2994	3	dat__o
datos	6	52	2278	3	dat_os
datto	6	54	1642	3	dat_to
dattos	7	43	1190	3	dattos
datum	8	3	1063	3	dat_um
datums	9	3	635	3	datums
daturas	8	3	878	3	daturas
daturic	10	4	703	3	daturic
daubery	13	39	621	3	daubery
dauby	11	52	1122	3	da_uby
davy	11	60	1552	3	d__avy
day	7	62	5411	3	d__a_y
daycare	13	5	509	3	daycare
dayfly	16	3	381	3	dayfly
daymare	13	7	563	3	daymare
daystar	11	4	344	3	daystar_
daystars	12	4	390	3	daystars
deanery	11	3	761	3	deanery
dear	5	53	4360	3	d_ear_
dearly	10	46	1532	3	d_early
dears	6	57	3688	3	d_ears
deathly	14	33	686	3	deathly
deathy	13	42	1023	3	deat_hy
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
decry	11	55	1435	3	d_ecry
decury	12	7	796	3	decury
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
depart	9	47	2056	3	depart
deray	9	50	2418	3	dera_y
derry	9	47	2137	3	d_erry
descry	12	5	618	3	descry
detach	12	3	1041	3	detach
detail	7	45	1643	3	detail
detain	7	46	1738	3	detain
deter	6	50	2804	3	deter_
deters	7	47	2468	3	deters
dewar	9	58	1773	3	dewar_
dewars	10	51	1707	3	dewars
digamy	13	3	589	3	digamy
dilatory	12	27	928	3	dilatory
dinar	6	63	1989	3	dinar_
dinars	7	54	1756	3	dinars
disarm	9	3	1047	3	disarm
dita	5	60	3252	3	dita__
ditas	6	59	2367	3	dita_s
dithery	14	31	894	3	dithery
ditsy	9	56	1256	3	dit_sy
dittany	11	3	565	3	dittany
ditty	9	50	1929	3	dit_ty
ditzy	18	65	1328	3	dit_zy
dory	8	58	3623	3	d__ory
dotage	8	27	1161	3	dotage
dotal	6	49	1962	3	dota_l
dotardly	13	4	384	3	dotardly
dotards	9	3	725	3	dotards
doter	6	54	2862	3	doter_
doters	7	44	2391	3	doters
dotty	9	45	1610	3	dot_ty
doty	8	61	2822	3	dot__y
dowery	13	43	1166	3	dowery
dowry	12	63	1248	3	d_owry
dramady	14	4	356	3	dramady
drapery	13	38	794	3	drapery
dray	8	54	2809	3	d_ra_y
dreamy	12	50	999	3	dreamy
drear	6	50	1690	3	drear_
drears	7	46	1425	3	drears
dry	7	65	2603	3	d___ry
dupery	12	37	874	3	dupery
duty	8	53	2145	3	dut__y
dwarf	12	60	1524	3	d_warf
eater	5	46	3984	3	eater_
eaters	6	55	3595	3	eaters
entry	8	24	1426	3	ent_ry
estray	9	57	1333	3	estray
estuary	10	3	468	3	estuary
eutaxy	16	4	330	3	eutaxy
factory	15	10	835	3	factory
faery	11	60	1548	3	fa_ery
fairy	11	53	1828	3	fa_iry
fakery	16	50	926	3	fakery
fantasy	13	3	615	3	fantasy
fatal	8	48	1937	3	fata_l
fatally	13	3	989	3	fatally
fatly	11	57	1680	3	fat_ly
fatty	11	51	1741	3	fat_ty
friary	12	40	1009	3	friary
galaxy	17	47	631	3	galaxy
gamay	11	64	1911	3	gama_y
gantry	10	38	1011	3	gantry
gater	6	45	3365	3	gater_
gaters	7	47	2864	3	gaters
gator	6	44	1604	3	gator_
gators	7	41	1584	3	gators
gazar	15	46	1298	3	gazar_
gazars	16	48	1155	3	gazars
glary	9	60	1854	3	_glary
gramary	13	5	591	3	gramary
granary	11	5	779	3	granary
haar	7	73	2349	3	ha_ar_
haars	8	56	2047	3	ha_ars
haftara	13	13	609	3	haftara
hairy	11	53	1683	3	ha_iry
harry	11	53	2295	3	ha_rry
hater	8	50	3475	3	hater_
haters	9	49	3040	3	haters
hazard	19	3	840	3	hazard
hoary	11	45	1676	3	_hoary
horary	12	3	1038	3	horary
jaggary	19	30	486	3	jaggary
japery	18	43	914	3	japery
kabar	11	48	1555	3	kabar_
kabars	12	45	1395	3	kabars
kantar	10	3	1115	3	kantar_
kantars	11	3	1003	3	kantars
kata	8	56	2602	3	kata__
katas	9	59	2209	3	kata_s
kaury	12	42	976	3	ka_ury
laari	5	44	1571	3	la_ari
labara	8	37	1289	3	labara
lahar	8	31	1426	3	lahar_
lahars	9	40	1316	3	lahars
laniary	10	6	801	3	laniary
lately	9	34	1384	3	lately
later	5	48	4392	3	later_
lathery	13	39	1112	3	lathery
lathy	11	52	1506	3	lat_hy
lazar	14	41	1364	3	lazar_
lazars	15	38	1239	3	lazars
leary	8	59	2738	3	_leary
litany	9	3	905	3	litany
maar	6	60	2506	3	ma_ar_
maars	7	46	2163	3	ma_ars
makar	11	56	1497	3	makar_
makars	12	46	1263	3	makars
malady	12	3	786	3	malady
malar	7	64	2444	3	malar_
malarky	16	4	543	3	malarky
malars	8	50	2068	3	malars
mammary	13	3	599	3	mammary
mandatary	15	4	324	3	~~man~~datary
manuary	12	3	777	3	manuary
marry	10	48	2169	3	ma_rry
martyry	15	3	337	3	martyry
mastery	12	42	1432	3	mastery
mater	7	44	3886	3	mater_
maters	8	50	3239	3	maters
matey	10	70	2266	3	mat_ey
mattery	12	38	1071	3	mattery
mature	8	3	1347	3	mature
mazard	18	3	876	3	mazard
mortary	12	36	904	3	mortary
napery	11	48	981	3	napery
nary	7	69	3122	3	__nary
natal	5	39	2149	3	nata_l
natant	6	3	1873	3	natant
natatory	11	4	661	3	natatory
natty	8	57	1914	3	nat_ty
nature	6	3	1126	3	nature
navar	8	39	1273	3	navar_
navars	9	28	1057	3	navars
nectary	12	4	622	3	nectary
nitery	9	44	1217	3	nitery
oater	5	54	3373	3	oater_
oaters	6	50	2979	3	oaters
oratory	10	3	940	3	oratory
ostiary	10	3	646	3	ostiary
ottar	5	43	1399	3	ottar_
ottars	6	41	1222	3	ottars
outcry	11	3	799	3	outcry
ovary	11	4	911	3	_ovary
palmary	14	33	855	3	palmary
paltry	11	49	1040	3	paltry
panfry	14	45	641	3	panfry
pantry	11	50	1410	3	pantry
papacy	15	4	749	3	papacy
papery	13	48	1274	3	papery
parry	10	53	2375	3	pa_rry
pastry	11	49	1303	3	pastry
pataca	10	3	1119	3	pataca
patchy	16	50	957	3	patchy
pater	7	47	4072	3	pater_
paters	8	49	3583	3	paters
patly	10	50	2058	3	pat_ly
patsy	10	57	1720	3	pat_sy
patty	10	47	2361	3	pat_ty
paty	9	52	3456	3	pat__y
petard	9	50	1380	3	petard
radar	6	13	1672	3	radar_
radars	7	13	1467	3	radars
ratably	12	17	1151	3	ratably
ratal	5	50	2511	3	rata_l
ratals	6	42	1958	3	ratals
ratan	5	37	2266	3	rata_n
ratans	6	38	1937	3	ratans
rater	5	49	4328	3	rater_
raters	6	39	3658	3	raters
ratify	12	26	1004	3	ratify
rattly	9	41	1154	3	rattly
ratty	8	48	1959	3	rat_ty
retard	7	50	1893	3	retard
retiary	10	3	833	3	retiary
retry	8	47	1808	3	ret_ry
rhatany	13	5	369	3	rhatany
ritard	7	48	1208	3	ritard
rosary	9	28	1035	3	rosary
safari	9	11	1022	3	safari
salutary	11	4	511	3	salutary
samara	8	3	1385	3	samara
sanitary	11	4	675	3	sanitary
satang	7	57	1156	3	satang
sataras	7	3	1506	3	sataras
satays	9	44	1168	3	satays
satiny	9	38	1798	3	satiny
satire	6	32	1800	3	satire
satori	6	4	1584	3	satori
satrap	8	62	1255	3	satrap
satrapy	12	49	793	3	satrapy
satyr	8	4	848	3	satyr_
satyrs	9	3	796	3	satyrs
saury	8	43	1722	3	sa_ury
savory	12	43	1056	3	savory
scary	10	52	2259	3	_scary
sectary	12	3	827	3	sectary
senary	9	37	1607	3	senary
sitar	5	48	2054	3	sitar_
sitars	6	54	1759	3	sitars
smeary	11	41	1080	3	smeary
stagy	9	66	1889	3	_stagy
star	4	80	3776	3	_star_
stare	5	44	4026	3	_stare
stark	9	54	2562	3	_stark
starry	9	49	1167	3	starry
stars	5	58	3657	3	_stars
start	5	56	4231	3	_start
statuary	11	4	403	3	statuary
stay	7	83	3372	3	_sta_y
story	8	67	2303	3	_story
stray	8	85	2557	3	_stray
sudary	10	3	870	3	sudary
sudatory	12	4	584	3	sudatory
sugary	10	3	901	3	sugary
tabard	9	3	1333	3	tabard
talar	5	62	2538	3	talar_
talars	6	60	2168	3	talars
tamari	8	3	1341	3	tamari
tantara	7	24	1082	3	tantara
tar	3	75	7069	3	__tar_
tardy	9	47	2046	3	__tardy
tare	4	59	5762	3	__tare
tarn	4	68	4272	3	__tarn
taro	4	68	4691	3	__taro
tarp	6	69	3642	3	__tarp
tarry	8	54	2251	3	ta_rry
tars	4	67	6395	3	__tars
tart	4	75	6618	3	__tart
tartar	6	32	1475	3	tartar_
tartare	7	30	1268	3	tartare
tartars	7	33	1340	3	tartars
tarty	8	63	2818	3	__tarty
tatami	8	3	919	3	tatami
tater	5	41	3861	3	tater_
taters	6	49	3220	3	taters
tatty	8	47	2018	3	tat_ty
tawdry	13	39	525	3	tawdry
teary	8	51	2405	3	_teary
tetany	9	5	984	3	tetany
tory	7	58	4054	3	__tory
tray	7	76	3259	3	__tray
try	6	65	2967	3	__t_ry
tuatara	7	4	551	3	tuatara
uakari	10	4	686	3	uakari
unary	8	3	1599	3	_unary
unitary	10	3	861	3	unitary
unwary	12	3	982	3	unwary
vapory	14	39	876	3	vapory
vary	10	52	2606	3	__vary
vaward	13	49	872	3	vaward
vivary	15	3	698	3	vivary
wafery	15	39	869	3	wafery
wary	10	67	4001	3	__wary
wastery	13	46	1099	3	wastery
wastry	12	38	877	3	wastry
watap	10	21	1167	3	wata_p
watape	11	20	848	3	watape
wataps	11	24	868	3	wataps
water	8	47	3331	3	water_
waters	9	50	3063	3	waters
wavery	15	46	1005	3	wavery
weary	11	56	2061	3	_weary
zonary	18	3	879	3	zonary

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.403	443402.0
2	DLD Change Limit	112716	456	5.876	19182.4
3	Display Results	456	456	0.140	3257.1
	(SQL Overall)	178691	456	6.419	27837.8