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

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

334 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
zonary	18	3	879	(None)
binary	11	3	1222	2	binary
canary	11	3	1469	2	canary
covary	14	3	874	2	covary
denary	10	53	1686	2	denary
hoary	11	45	1676	2	ho_ary
horary	12	3	1038	2	horary
nary	7	69	3122	2	__nary
nonart	6	3	1919	2	nonart
notary	9	23	1071	2	notary
onery	8	4	1412	2	_onery
ovary	11	4	911	2	_ovary
rosary	9	28	1035	2	rosary
rotary	9	24	1130	2	rotary
senary	9	37	1607	2	senary
sonar	5	65	2342	2	sonar_
sonars	6	48	1897	2	sonars
unary	8	3	1599	2	_unary
votary	12	24	833	2	votary
zona	13	63	2196	2	zona__
zonae	14	51	1644	2	zona_e
zonal	14	51	1685	2	zona_l
zonally	19	3	800	2	zonally
zonate	15	41	1492	2	zonate
zoner	14	45	2034	2	zoner_
zoners	15	51	1599	2	zoners
alary	8	61	2344	3	_alary
ambary	13	40	1054	3	ambary
angary	10	3	1132	3	angary
angry	9	3	1086	3	_angry
apiary	11	39	1038	3	apiary
ariary	9	41	1420	3	ariary
aviary	12	33	841	3	aviary
aweary	12	3	730	3	aweary
azonal	15	6	827	3	azona_l
bleary	11	51	1255	3	bleary
boar	6	61	3429	3	bo_ar_
board	8	55	2300	3	bo_ard
boars	7	52	2960	3	bo_ars
boart	7	88	3593	3	bo_art
bogart	9	6	1719	3	bogart
bolar	7	51	2347	3	bolar_
bonaci	10	3	1096	3	bonaci
boner	7	51	3308	3	boner_
boners	8	48	2543	3	boners
boney	10	52	2731	3	bon_ey
bonny	10	58	1662	3	bon_ny
bony	9	67	3208	3	bon__y
botany	11	3	926	3	botany
boundary	14	4	475	3	boundary
bowery	14	60	1211	3	bowery
boyar	10	60	1376	3	boyar_
boyard	12	54	1128	3	boyard
boyars	11	56	1198	3	boyars
briary	11	49	1200	3	briary
canard	9	3	1476	3	canard
cedary	12	41	960	3	cedary
chary	13	50	2313	3	_chary
clary	10	57	1961	3	_clary
coaly	10	55	2159	3	co_aly
conchy	16	37	1022	3	conchy
coney	10	59	3288	3	con_ey
conky	14	58	1874	3	con_ky
contra	8	33	1470	3	contra
contrary	13	4	749	3	contrary
convey	14	46	1022	3	convey
convoy	14	34	854	3	convoy
cony	9	65	3783	3	con__y
copay	12	65	1631	3	copa_y
coronary	13	4	769	3	coronary
cory	9	69	4151	3	co__ry
country	12	38	804	3	country
coward	12	4	1167	3	coward
cowry	13	55	1248	3	co_wry
datary	10	3	1024	3	datary
deary	9	58	2684	3	_deary
denar	6	52	2329	3	denar_
denari	7	109	1735	3	denari
denars	7	46	2143	3	denars
diary	9	50	1697	3	_diary
dinar	6	63	1989	3	dinar_
dinars	7	54	1756	3	dinars
dona	5	55	2963	3	dona__
donas	6	59	2647	3	dona_s
donate	7	36	1950	3	donate
donkey	14	44	973	3	donkey
donor	6	44	1819	3	donor_
donors	7	51	1579	3	donors
donsy	9	64	1468	3	don_sy
dory	8	58	3623	3	do__ry
dotard	8	3	905	3	dotard
dowery	13	43	1166	3	dowery
dowry	12	63	1248	3	do_wry
dreary	10	46	1167	3	dreary
entry	8	24	1426	3	_entry
feodary	14	4	471	3	feodary
finery	12	45	1289	3	finery
foamy	13	53	1320	3	fo_amy
fondly	13	29	904	3	fondly
foray	11	50	2397	3	fora_y
foundry	14	3	391	3	foundry
friary	12	40	1009	3	friary
gantry	10	38	1011	3	gantry
gentry	10	34	1044	3	gentry
glary	9	60	1854	3	_glary
gnar	5	60	2138	3	_gnar_
gnarl	6	51	1557	3	_gnarl
gnarly	10	46	1038	3	_gnarly
gnarr	6	48	1069	3	_gnarr
gnars	6	67	1885	3	_gnars
gonad	7	52	1605	3	gona_d
gonads	8	45	1173	3	gonads
goner	6	60	2516	3	goner_
goners	7	44	2017	3	goners
gory	8	61	2966	3	go__ry
gowany	13	45	749	3	gowany
granary	11	5	779	3	granary
henry	11	40	1447	3	hen_ry
hoagy	12	47	1047	3	ho_agy
hoar	7	67	2916	3	ho_ar_
hoard	9	49	1831	3	ho_ard
hoars	8	59	2555	3	ho_ars
holard	10	4	1057	3	holard
honan	8	53	1977	3	hona_n
honans	9	48	1450	3	honans
honer	8	53	3209	3	honer_
honers	9	43	2497	3	honers
honey	11	56	2991	3	hon_ey
honkey	16	51	1382	3	honkey
honky	15	62	1852	3	hon_ky
honor	8	57	1862	3	honor_
honorary	14	4	580	3	honorary
honors	9	48	1679	3	honors
hooray	12	30	1137	3	hooray
hungry	13	3	497	3	hungry
hymnary	18	4	303	3	hymnary
inarm	7	3	1442	3	_inarm
joinery	17	36	659	3	joinery
jowar	15	52	1143	3	jowar_
jowars	16	36	965	3	jowars
kinara	10	3	1037	3	kinara
knar	8	58	1872	3	_knar_
knarry	13	3	461	3	_knarry
knars	9	44	1611	3	_knars
laniary	10	6	801	3	laniary
leary	8	59	2738	3	_leary
loamy	10	59	1334	3	lo_amy
lobar	7	3	1301	3	lobar_
lonely	9	29	1247	3	lonely
loner	5	54	3104	3	loner_
loners	6	42	2581	3	loners
longly	10	27	960	3	longly
lorry	8	63	1567	3	lo_rry
lory	7	59	3171	3	lo__ry
loury	8	57	1675	3	lo_ury
lowery	12	41	1271	3	lowery
lunacy	11	3	684	3	lunacy
lunar	5	70	1731	3	lunar_
lunars	6	50	1281	3	lunars
manuary	12	3	777	3	manuary
molar	7	52	2309	3	molar_
molars	8	55	1732	3	molars
monad	8	55	1947	3	mona_d
monads	9	45	1530	3	monads
monandry	14	4	323	3	monandry
monarch	14	4	595	3	monarch
monarchy	18	4	360	3	monarchy
monarda	10	4	661	3	monarda
monas	7	47	3215	3	mona_s
monetary	13	4	652	3	monetary
money	10	48	2684	3	mon_ey
monkery	16	31	745	3	monkery
monkey	15	37	1059	3	monkey
monody	12	3	824	3	monody
mony	9	68	3001	3	mon__y
moory	10	51	1579	3	mo_ory
mopery	13	52	1097	3	mopery
moray	10	54	2379	3	mora_y
mortary	12	36	904	3	mortary
narc	6	71	2795	3	__narc
nard	5	66	3445	3	__nard
nark	8	52	3006	3	__nark
narky	12	60	1780	3	__narky
navy	10	75	1863	3	__navy
nay	6	69	5277	3	__na_y
nona	4	69	2906	3	nona__
nonage	7	3	1368	3	nonage
nonarts	7	3	1130	3	nonarts
nonas	5	51	2665	3	nona_s
nondairy	12	4	471	3	nondairy
nonfarm	12	4	651	3	nonfarm
nongay	10	16	915	3	nongay
nonhardy	15	4	433	3	nonhardy
nonjury	17	4	403	3	nonjury
nonpar	8	16	899	3	nonpar_
nonparty	13	4	555	3	nonparty
nonwar	9	15	942	3	nonwar_
nonwars	10	10	900	3	nonwars
noway	11	11	1284	3	nowa_y
oaky	11	64	1995	3	_o_aky
oar	3	70	5795	3	_o_ar_
oars	4	68	4603	3	_o_ars
ochry	13	34	693	3	_ochry
octonary	13	4	498	3	octonary
ofay	10	64	1610	3	_ofa_y
okay	11	59	1766	3	_oka_y
onagri	7	5	496	3	_onagri
onlay	8	42	1294	3	_onlay
only	7	53	1972	3	_on_ly
onward	10	3	905	3	_onward
oogamy	12	3	563	3	oogamy
ornery	9	3	846	3	ornery
osar	4	68	2095	3	_osar_
ozonate	16	4	686	3	ozonate
panfry	14	45	641	3	panfry
pantry	11	50	1410	3	pantry
penury	11	4	810	3	penury
pinery	11	52	1429	3	pinery
plenary	12	3	754	3	plenary
poetry	11	3	938	3	poetry
polar	7	56	2345	3	polar_
polars	8	44	1935	3	polars
poniard	10	3	758	3	poniard
pony	9	64	3405	3	pon__y
popery	13	45	1170	3	popery
quinary	19	3	693	3	quinary
roar	4	63	2857	3	ro_ar_
roars	5	56	2224	3	ro_ars
ropery	11	43	1387	3	ropery
rosery	9	38	1328	3	rosery
salary	9	5	1521	3	salary
scary	10	52	2259	3	_scary
sentry	9	29	1205	3	sentry
smeary	11	41	1080	3	smeary
snaky	12	51	1391	3	_snaky
snare	5	44	2998	3	_snare
snarf	8	65	2542	3	_snarf
snark	9	54	1994	3	_snark
snarky	13	42	1084	3	_snarky
snarl	5	49	2108	3	_snarl
snarly	9	38	1500	3	_snarly
soapy	10	61	1478	3	so_apy
soar	4	68	3867	3	so_ar_
soars	5	47	3251	3	so_ars
sofar	8	61	1549	3	sofar_
sofars	9	47	1278	3	sofars
solar	5	59	2734	3	solar_
sonant	6	6	2195	3	sonant
sonata	6	3	1322	3	sonata
sonly	8	57	1805	3	son_ly
sonny	8	50	1610	3	son_ny
sonsy	8	64	1637	3	son_sy
sorry	8	46	1825	3	so_rry
souari	6	3	1138	3	souari
sowar	8	58	2134	3	sowar_
sowars	9	43	1801	3	sowars
sudary	10	3	870	3	sudary
sugary	10	3	901	3	sugary
sundry	10	5	794	3	sundry
sunray	9	3	1012	3	sunray
teary	8	51	2405	3	_teary
ternary	10	3	834	3	ternary
toady	9	68	1434	3	to_ady
today	9	64	1695	3	toda_y
tokay	12	55	1305	3	toka_y
tolar	5	55	2411	3	tolar_
tolars	6	48	1794	3	tolars
tonal	5	37	2430	3	tona_l
tonally	10	3	1137	3	tonally
tonearm	9	3	744	3	tonearm
toner	5	53	3624	3	toner_
toners	6	41	2800	3	toners
toney	8	60	2741	3	ton_ey
tony	7	56	3515	3	ton__y
topiary	12	4	581	3	topiary
tory	7	58	4054	3	to__ry
toward	10	3	1106	3	toward
towery	12	40	1209	3	towery
trinary	10	3	917	3	trinary
ulnar	5	60	1398	3	ulnar_
unarm	7	3	1445	3	_unarm
unwary	12	3	982	3	unwary
urinary	10	3	724	3	urinary
vagary	13	3	733	3	vagary
vary	10	52	2606	3	__vary
venery	12	37	1066	3	venery
vinery	12	49	1260	3	vinery
vivary	15	3	698	3	vivary
volar	8	69	1741	3	volar_
volery	12	3	787	3	volery
wary	10	67	4001	3	__wary
weary	11	56	2061	3	_weary
winery	12	50	1428	3	winery
wintry	12	49	892	3	wintry
wonky	15	40	1177	3	won_ky
worry	11	61	1433	3	wo_rry
zanana	15	38	1036	3	zanana
zanily	18	3	1018	3	zanily
zany	16	73	1699	3	z__any
zarf	16	69	2912	3	z__arf
zedoary	20	4	321	3	zedoary
zenana	15	29	798	3	zenana
zincky	24	40	496	3	zincky
zincy	19	54	1351	3	zin_cy
zingara	17	4	551	3	zingara
zingare	17	3	714	3	zingare
zingari	17	4	548	3	zingari
zingaro	17	4	512	3	zingaro
zingy	18	65	1613	3	zin_gy
zinky	21	53	1481	3	zin_ky
zoa	12	85	2999	3	zo_a__
zoaria	15	4	838	3	zo_aria
zocalo	17	3	580	3	zocalo
zoea	13	71	1842	3	zoea__
zoeae	14	44	1248	3	zoea_e
zoeal	14	48	1378	3	zoea_l
zoeas	14	58	1561	3	zoea_s
zonated	17	33	1053	3	zonated
zone	13	52	3108	3	zon__e
zoned	15	40	2026	3	zon_ed
zones	14	55	2804	3	zon_es
zoning	16	29	1433	3	zoning
zonk	17	50	1862	3	zon__k
zonked	20	42	947	3	zonked
zonks	18	48	1517	3	zon_ks
zonula	15	3	722	3	zonula
zonular	16	5	649	3	zonular_
zonule	15	7	748	3	zonule
zooey	17	39	1480	3	zo_oey
zoolatry	20	4	286	3	zoolatry
zoonal	15	5	808	3	zoona_l
zooty	17	54	1535	3	zo_oty
zori	13	77	2292	3	zo__ri
zouave	18	3	357	3	zouave

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	112716	0.780	229091.0
2	DLD Change Limit	112716	334	7.703	14632.7
3	Display Results	334	334	0.093	3591.4
	(SQL Overall)	178691	334	8.576	20836.2