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

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

261 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
aviary	12	33	841	(None)
apiary	11	39	1038	1	apiary
ariary	9	41	1420	1	ariary
airy	7	57	3415	2	a_i_ry
alary	8	61	2344	2	a_lary
ambary	13	40	1054	2	ambary
angary	10	3	1132	2	angary
avian	8	46	1605	2	avia_n
avians	9	37	1156	2	avians
aviate	9	3	1520	2	aviate
avidly	13	54	878	2	avidly
aweary	12	3	730	2	aweary
briary	11	49	1200	2	briary
caviar	11	3	1016	2	caviar_
caviare	12	3	837	2	caviare
caviars	12	3	862	2	caviars
cavitary	16	6	496	2	cavitary
diary	9	50	1697	2	_diary
friary	12	40	1009	2	friary
laniary	10	6	801	2	laniary
ovary	11	4	911	2	ov_ary
vagary	13	3	733	2	vagary
vary	10	52	2606	2	_v_ary
vivary	15	3	698	2	_vivary
abbacy	15	3	662	3	abbacy
aboard	9	3	1261	3	aboard
acari	7	50	2028	3	a_cari
acidly	12	52	1179	3	acidly
acidy	11	72	1489	3	aci_dy
acinar	8	3	1048	3	acinar_
actuary	12	4	561	3	actuary
advisory	15	13	294	3	advisory
aery	7	72	3168	3	a__ery
afar	7	67	2078	3	a_far_
afars	8	57	1651	3	a_fars
afeard	10	5	826	3	afeard
affray	15	3	497	3	affray
afire	8	62	1591	3	afi_re
agar	5	87	2641	3	a_gar_
agars	6	61	2064	3	a_gars
aglare	7	3	1242	3	aglare
air	3	80	5839	3	a_i_r_
airn	4	64	3383	3	a_i_rn
airs	4	64	4742	3	a_i_rs
airt	4	57	5778	3	a_i_rt
aiver	8	57	2516	3	aiver_
aivers	9	48	2232	3	aivers
ajar	11	62	1770	3	a_jar_
alar	4	63	4007	3	a_lar_
alarm	7	66	2142	3	a_larm
alias	5	58	3460	3	alia_s
allay	8	56	2039	3	alla_y
altar	5	55	2064	3	altar_
altars	6	45	1815	3	altars
alway	11	61	1392	3	alwa_y
ambari	10	30	1217	3	ambari
ambery	13	38	1113	3	ambery
ambry	12	35	1210	3	a_mbry
amia	6	68	3690	3	amia__
amiably	14	3	830	3	amiably
amias	7	58	3147	3	amia_s
amir	6	51	2975	3	ami_r_
amirs	7	59	2492	3	ami_rs
amity	10	4	1609	3	ami_ty
anear	5	54	2032	3	anear_
anears	6	37	1718	3	anears
angry	9	3	1086	3	a_ngry
animacy	14	4	610	3	animacy
antiar	6	3	1717	3	antiar_
antiars	7	3	1462	3	antiars
apart	7	43	3067	3	a_part
apery	10	65	1790	3	a_pery
apian	7	50	1833	3	apia_n
aria	4	62	4542	3	aria__
arias	5	54	3802	3	aria_s
aridly	10	55	1370	3	aridly
armory	11	42	1147	3	armory
array	8	63	1714	3	arra_y
artery	9	9	1145	3	artery
assay	8	7	1028	3	assa_y
astray	9	56	1554	3	astray
aswarm	11	10	791	3	aswarm
ataxy	15	3	731	3	a_taxy
attar	5	65	1669	3	attar_
attars	6	45	1531	3	attars
augury	10	36	666	3	augury
aurar	5	44	2025	3	aurar_
autarky	14	4	470	3	autarky
ava	6	101	3932	3	av_a__
avail	8	3	1388	3	av_ail
avails	9	3	969	3	avails
avant	8	62	2466	3	av_ant
avast	8	55	1936	3	av_ast
avatar	9	3	752	3	avatar_
avatars	10	3	644	3	avatars
aver	7	59	3188	3	av_er_
avers	8	51	2731	3	av_ers
avert	8	60	2949	3	av_ert
avgas	9	69	1213	3	avga_s
aviaries	11	3	978	3	aviaries
aviarist	11	4	1011	3	aviarist
aviated	11	3	1026	3	aviated
aviates	10	3	1306	3	aviates
aviatic	12	3	924	3	aviatic
aviator	10	22	966	3	aviator
aviators	11	16	990	3	aviators
aviatrix	18	4	214	3	aviatrix
avid	8	83	2596	3	avi__d
avidin	10	35	1084	3	avidin
avidity	14	3	648	3	avidity
avion	8	42	1834	3	avi_on
avions	9	41	1439	3	avions
aviso	8	57	1396	3	avi_so
avisos	9	54	1048	3	avisos
award	9	71	1804	3	a_ward
aware	8	64	2002	3	a_ware
away	10	80	2422	3	a_wa_y
awry	10	76	1968	3	a__wry
axial	12	45	1519	3	axia_l
axially	17	3	723	3	axially
axillary	18	23	510	3	axillary
basilary	13	4	506	3	basilary
bialy	10	51	1932	3	_bialy
biliary	12	3	821	3	biliary
binary	11	3	1222	3	binary
bleary	11	51	1255	3	bleary
breviary	16	4	261	3	breviary
briar	7	57	1815	3	briar_
briard	9	43	1129	3	briard
briars	8	48	1482	3	briars
briery	11	45	1077	3	briery
calvary	15	3	718	3	calvary
canary	11	3	1469	3	canary
cavalry	15	5	496	3	cavalry
caviares	13	3	799	3	caviares
cavity	14	3	1001	3	cavi_ty
cedary	12	41	960	3	cedary
chary	13	50	2313	3	_chary
ciliary	12	4	792	3	ciliary
clary	10	57	1961	3	_clary
covary	14	3	874	3	covary
dairy	9	70	1630	3	dai_ry
datary	10	3	1024	3	datary
deary	9	58	2684	3	_deary
denary	10	53	1686	3	denary
devilry	14	3	397	3	devilry
dreary	10	46	1167	3	dreary
every	11	52	1545	3	ev_ery
evilly	12	3	659	3	evilly
fairy	11	53	1828	3	fai_ry
fiar	7	64	2733	3	_fiar_
fiars	8	67	2083	3	_fiars
fiery	11	47	1479	3	_fiery
firry	11	57	1353	3	_firry
friar	8	54	1427	3	friar_
friarly	13	31	621	3	friarly
friars	9	38	1209	3	friars
gavial	10	3	1008	3	gavia_l
gavials	11	3	660	3	gavials
glairy	10	44	827	3	glairy
glary	9	60	1854	3	_glary
hairy	11	53	1683	3	hai_ry
havior	12	4	820	3	havior_
haviors	13	4	738	3	haviors
hoary	11	45	1676	3	_hoary
horary	12	3	1038	3	horary
ivory	11	3	737	3	iv_ory
jaggary	19	30	486	3	jaggary
janisary	18	4	362	3	janisary
janizary	27	4	248	3	janizary
lactary	12	3	784	3	lactary
laminary	13	33	725	3	laminary
laniard	8	6	852	3	laniard
lapidary	14	5	409	3	lapidary
leary	8	59	2738	3	_leary
liar	4	72	2968	3	_liar_
liard	6	54	1859	3	_liard
liars	5	47	2316	3	_liars
livery	12	49	1090	3	livery
mammary	13	3	599	3	mammary
manuary	12	3	777	3	manuary
miliary	12	4	946	3	miliary
miry	9	63	2675	3	_mi_ry
nary	7	69	3122	3	__nary
navar	8	39	1273	3	nav_ar_
navars	9	28	1057	3	nav_ars
notary	9	23	1071	3	notary
olivary	13	4	516	3	olivary
ostiary	10	3	646	3	ostiary
ovipara	12	4	254	3	ovipara
ovulary	13	4	491	3	ovulary
palmary	14	33	855	3	palmary
pavior	11	3	853	3	pavior_
paviors	12	3	760	3	paviors
plagiary	14	4	364	3	plagiary
primary	14	3	770	3	primary
priory	11	41	1026	3	priory
quinary	19	3	693	3	quinary
retiary	10	3	833	3	retiary
rivalry	13	5	403	3	rivalry
rosary	9	28	1035	3	rosary
rotary	9	24	1130	3	rotary
salary	9	5	1521	3	salary
salivary	14	4	473	3	salivary
sanitary	11	4	675	3	sanitary
savior	9	7	1017	3	savior_
saviors	10	5	899	3	saviors
savory	12	43	1056	3	sav_ory
savoury	13	36	587	3	savoury
scary	10	52	2259	3	_scary
senary	9	37	1607	3	senary
smeary	11	41	1080	3	smeary
spiry	10	50	1735	3	spi_ry
sudary	10	3	870	3	sudary
sugary	10	3	901	3	sugary
teary	8	51	2405	3	_teary
tiara	5	3	1591	3	_tiara
topiary	12	4	581	3	topiary
trinary	10	3	917	3	trinary
unary	8	3	1599	3	_unary
unitary	10	3	861	3	unitary
unwary	12	3	982	3	unwary
urinary	10	3	724	3	urinary
vainly	12	5	850	3	vainly
vair	7	56	2414	3	vai_r_
vairs	8	50	1913	3	vai_rs
vapory	14	39	876	3	vapory
var	6	61	4833	3	_v_ar_
vara	7	55	3088	3	_v_ara
vars	7	57	4207	3	_v_ars
vaward	13	49	872	3	vaward
vealy	11	58	1777	3	_vealy
veery	11	58	1625	3	_veery
very	10	80	2564	3	_v_ery
via	6	56	3624	3	_via__
viably	14	19	983	3	_viably
vial	7	67	3109	3	_via_l
vials	8	58	2238	3	_vials
viand	9	5	1107	3	_viand
vicar	10	5	1386	3	_vicar_
vicarly	15	3	646	3	_vicarly
vicars	11	7	1226	3	_vicars
vichy	16	3	904	3	_vichy
vier	7	54	2815	3	_vier_
viers	8	56	2195	3	_viers
viewy	14	51	810	3	_viewy
vinery	12	49	1260	3	_vinery
viny	10	60	2595	3	_vi_ny
viral	8	64	1959	3	_viral
virl	7	62	2447	3	_vi_rl
visard	10	39	1012	3	_visard
vizard	19	45	885	3	_vizard
votary	12	24	833	3	votary
wary	10	67	4001	3	__wary
wavery	15	46	1005	3	wav_ery
wavier	12	46	1308	3	wavier_
wavily	15	21	948	3	wavi_ly
weary	11	56	2061	3	_weary
whirry	15	47	706	3	whirry
wiry	10	64	2283	3	_wi_ry
zonary	18	3	879	3	zonary

Search took 6 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.360	496363.9
2	DLD Change Limit	112716	261	4.873	23130.7
3	Display Results	261	261	0.080	3262.5
	(SQL Overall)	178691	261	5.313	33632.8