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

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

337 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
vagary	13	3	733	(None)
agar	5	87	2641	2	_agar_
agars	6	61	2064	2	_agars
alary	8	61	2344	2	_alary
angary	10	3	1132	2	angary
aviary	12	33	841	2	aviary
canary	11	3	1469	2	canary
datary	10	3	1024	2	datary
jaggary	19	30	486	2	jaggary
salary	9	5	1521	2	salary
sugary	10	3	901	2	sugary
vagal	9	46	1363	2	vaga_l
vagally	14	3	583	2	vagally
vapory	14	39	876	2	vapory
vary	10	52	2606	2	v__ary
vaward	13	49	872	2	vaward
vivary	15	3	698	2	vivary
votary	12	24	833	2	votary
acari	7	50	2028	3	_acari
aery	7	72	3168	3	_a_ery
afar	7	67	2078	3	_afar_
afars	8	57	1651	3	_afars
aga	4	104	4723	3	_aga__
again	6	52	1811	3	_again
agama	8	58	1557	3	_agama
agape	8	56	1484	3	_agape
agaric	9	35	1362	3	_agaric
agas	5	59	3884	3	_aga_s
agate	6	65	2514	3	_agate
agave	9	53	1403	3	_agave
agaze	15	61	1366	3	_agaze
ager	5	59	3584	3	_ager_
agers	6	50	2785	3	_agers
aggro	7	3	800	3	_aggro
aglare	7	3	1242	3	_aglare
agley	9	69	1733	3	_agley
agly	8	68	2180	3	_ag_ly
agony	9	64	1565	3	_agony
agora	6	9	1433	3	_agora
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
ambary	13	40	1053	3	ambary
ambry	12	35	1209	3	_ambry
angry	9	3	1086	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
ataxy	15	3	731	3	_ataxy
augury	10	36	666	3	augury
avatar	9	3	752	3	avatar_
avatars	10	3	644	3	avatars
avgas	9	69	1213	3	avga_s
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
bagass	9	3	893	3	bagass
baggy	12	56	1568	3	bag_gy
bakery	15	59	1100	3	bakery
bawdry	15	51	646	3	bawdry
bayard	12	44	1166	3	bayard
bazar	16	38	1600	3	bazar_
bazars	17	46	1311	3	bazars
beggary	14	31	615	3	beggary
bigamy	14	3	633	3	bigamy
binary	11	3	1222	3	binary
bleary	11	51	1255	3	bleary
bogart	9	6	1719	3	bogart
briary	11	49	1200	3	briary
cager	8	52	2922	3	cager_
cagers	9	56	2418	3	cagers
cagey	11	59	1782	3	cag_ey
cagily	12	4	1156	3	cagily
cagy	10	63	2199	3	cag__y
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
cavalry	15	5	496	3	cavalry
cedary	12	41	960	3	cedary
chary	13	50	2313	3	_chary
cigar	8	9	1179	3	cigar_
cigars	9	9	1071	3	cigars
clary	10	57	1961	3	_clary
covary	14	3	874	3	covary
dairy	9	70	1630	3	da_iry
damar	8	41	1773	3	damar_
damars	9	38	1499	3	damars
daubry	12	44	548	3	daubry
deary	9	58	2684	3	_deary
denary	10	53	1686	3	denary
diary	9	50	1697	3	_diary
digamy	13	3	588	3	digamy
dreary	10	46	1167	3	dreary
eager	6	55	2696	3	eager_
eagerly	11	3	605	3	eagerly
eagers	7	45	2368	3	eagers
eagre	6	43	1532	3	eag_re
eatery	9	53	1635	3	eatery
eggar	7	45	888	3	eggar_
eggars	8	39	897	3	eggars
faery	11	60	1548	3	fa_ery
faggy	13	65	1437	3	fag_gy
fairy	11	53	1828	3	fa_iry
fakery	16	50	926	3	fakery
friary	12	40	1009	3	friary
gaby	10	71	2319	3	__gaby
gaga	6	66	2555	3	gaga__
gagaku	12	4	381	3	gagaku
gager	7	47	2629	3	gager_
gagers	8	40	2132	3	gagers
galaxy	17	47	631	3	galaxy
gamay	11	64	1910	3	gama_y
gamy	10	54	2753	3	__gamy
gantry	10	38	1011	3	gantry
gapy	10	63	2091	3	__gapy
gar	4	72	5990	3	__gar_
garb	7	53	3267	3	__garb
gars	5	57	5074	3	__gars
gay	7	68	5649	3	__ga_y
gazar	15	46	1298	3	gazar_
gazars	16	48	1155	3	gazars
glary	9	60	1854	3	_glary
gory	8	61	2966	3	__gory
gramary	13	5	590	3	gramary
granary	11	5	779	3	granary
gray	8	53	2989	3	__gray
haar	7	73	2349	3	ha_ar_
haars	8	56	2047	3	ha_ars
haggard	13	37	718	3	haggard
hairy	11	53	1683	3	ha_iry
hangar	10	41	1450	3	hangar_
hangars	11	43	1348	3	hangars
harry	11	53	2295	3	ha_rry
hazard	19	3	840	3	hazard
hegari	10	3	951	3	hegari
hoary	11	45	1676	3	_hoary
horary	12	3	1038	3	horary
imagery	13	12	420	3	imagery
jager	13	43	1813	3	jager_
jagers	14	44	1572	3	jagers
jaggery	19	33	690	3	jaggery
jaggy	17	59	1314	3	jag_gy
jagra	13	3	817	3	jag_ra
jagras	14	3	846	3	jagras
jaguar	14	3	528	3	jaguar_
jaguars	15	3	522	3	jaguars
japery	18	43	914	3	japery
kabar	11	48	1555	3	kabar_
kabars	12	45	1395	3	kabars
kaury	12	42	976	3	ka_ury
laari	5	44	1571	3	la_ari
labara	8	37	1289	3	labara
lactary	12	3	784	3	lactary
lagan	6	65	2034	3	laga_n
lagans	7	57	1778	3	lagans
lager	6	51	3286	3	lager_
lagers	7	48	2614	3	lagers
laggard	10	34	762	3	laggard
lahar	8	31	1426	3	lahar_
lahars	9	40	1316	3	lahars
laniary	10	6	801	3	laniary
lazar	14	41	1364	3	lazar_
lazars	15	38	1239	3	lazars
leary	8	59	2738	3	_leary
legacy	12	5	665	3	legacy
maar	6	60	2505	3	ma_ar_
maars	7	46	2163	3	ma_ars
maguey	12	3	683	3	maguey
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
mangaby	15	3	535	3	mangaby
manuary	12	3	777	3	manuary
margay	12	3	1059	3	marga_y
marry	10	48	2169	3	ma_rry
mazard	18	3	876	3	mazard
megara	9	3	1009	3	megara
nagana	7	4	894	3	nagana
naggy	10	66	1282	3	nag_gy
napery	11	48	981	3	napery
nary	7	69	3122	3	__nary
navar	8	39	1273	3	navar_
navars	9	28	1057	3	navars
notary	9	23	1071	3	notary
oogamy	12	3	563	3	oogamy
ovary	11	4	911	3	_ovary
ovulary	13	4	491	3	ovulary
pagan	8	61	2116	3	paga_n
pagans	9	57	1792	3	pagans
pager	8	47	2820	3	pager_
pagers	9	44	2325	3	pagers
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
plagiary	14	4	364	3	plagiary
puggry	13	37	482	3	puggry
radar	6	13	1672	3	radar_
radars	7	13	1466	3	radars
raga	5	59	3081	3	raga__
ragas	6	53	2606	3	raga_s
raggy	10	61	1657	3	rag_gy
ratany	9	34	1187	3	ratany
regard	8	52	1577	3	regard
rosary	9	28	1035	3	rosary
rotary	9	24	1130	3	rotary
safari	9	11	1022	3	safari
saga	5	53	3117	3	saga__
sagas	6	60	2588	3	saga_s
sagely	10	28	1138	3	sagely
sager	6	54	3205	3	sager_
saggar	8	40	1085	3	saggar_
saggard	10	35	895	3	saggard
saggars	9	36	1068	3	saggars
saggy	10	59	1746	3	sag_gy
saguaro	8	4	551	3	saguaro
sagy	8	53	2708	3	sag__y
samara	8	3	1385	3	samara
sangar	7	36	1768	3	sangar_
sangars	8	31	1625	3	sangars
satara	6	3	1553	3	satara
satay	8	47	1846	3	sata_y
saury	8	43	1722	3	sa_ury
savagery	15	4	322	3	savagery
savory	12	43	1056	3	savory
scary	10	52	2259	3	_scary
senary	9	37	1607	3	senary
smeary	11	41	1080	3	smeary
sudary	10	3	870	3	sudary
sugar	6	3	1291	3	sugar_
sugars	7	3	1242	3	sugars
tabard	9	3	1333	3	tabard
tagrag	8	3	704	3	tagrag
talar	5	62	2538	3	talar_
talars	6	60	2168	3	talars
tamari	8	3	1338	3	tamari
tarry	8	54	2251	3	ta_rry
tatar	5	61	2206	3	tatar_
tatars	6	46	1979	3	tatars
tawdry	13	39	525	3	tawdry
teary	8	51	2405	3	_teary
uakari	10	4	686	3	uakari
unary	8	3	1599	3	_unary
unwary	12	3	982	3	unwary
vacancy	17	4	444	3	vacancy
vacant	11	4	1513	3	vacant
vacate	11	3	1455	3	vacate
vagaries	12	3	1029	3	vagaries
vagi	8	67	1936	3	vag__i
vagile	10	3	1054	3	vagile
vagina	10	27	1093	3	vagina
vagrancy	17	4	345	3	vagrancy
vagrant	11	4	1066	3	vagrant
vagrom	12	3	594	3	vagrom
vague	9	65	1311	3	vag_ue
vaguely	14	4	369	3	vaguely
vaguer	10	44	844	3	vaguer
vagus	9	67	1381	3	vag_us
vainly	12	5	850	3	vainly
vair	7	56	2414	3	va_ir_
vairs	8	50	1913	3	va_irs
valkyr	16	3	240	3	valkyr
valley	12	43	1160	3	valley
valor	8	36	1489	3	valor_
valors	9	34	1377	3	valors
valvar	12	38	865	3	valvar_
vampy	15	53	940	3	va_mpy
vanguard	13	4	389	3	vanguard
vanity	12	3	1193	3	vanity
vanward	14	5	694	3	vanward
vapor	10	40	1309	3	vapor_
vapors	11	38	1269	3	vapors
vapoury	15	28	480	3	vapoury
var	6	61	4833	3	v__ar_
vara	7	55	3088	3	v__ara
varas	8	60	2819	3	vara_s
vars	7	57	4207	3	v__ars
vasa	7	65	2297	3	vasa__
vasal	8	55	1629	3	vasa_l
vastly	12	50	872	3	vastly
vasty	11	62	1592	3	va_sty
vaulty	12	38	844	3	vaulty
vaunty	12	40	906	3	vaunty
vawards	14	45	757	3	vawards
vealy	11	58	1777	3	v_ealy
veery	11	58	1625	3	v_eery
vegan	9	51	1415	3	vega_n
vegans	10	39	1085	3	vegans
velar	8	58	1763	3	velar_
velars	9	39	1372	3	velars
venery	12	37	1066	3	venery
very	10	80	2564	3	v__ery
vestry	12	3	862	3	vestry
vicar	10	5	1386	3	vicar_
vicarly	15	3	646	3	vicarly
vicars	11	7	1226	3	vicars
viga	8	56	2296	3	viga__
vigas	9	48	1788	3	viga_s
vigor	9	26	1242	3	vigor_
vigors	10	29	1148	3	vigors
vinegary	15	4	389	3	vinegary
vinery	12	49	1259	3	vinery
visard	10	39	1012	3	visard
vizard	19	45	885	3	vizard
volar	8	69	1741	3	volar_
volery	12	3	787	3	volery
vuggy	13	58	948	3	vug_gy
vulgar	10	42	682	3	vulgar_
vulgarly	15	4	316	3	vulgarly
vulgars	11	30	653	3	vulgars
wafery	15	39	869	3	wafery
wager	9	59	2505	3	wager_
wagers	10	51	2220	3	wagers
waggery	15	27	690	3	waggery
waggly	14	34	729	3	waggly
wary	10	67	4001	3	__wary
wastry	12	38	877	3	wastry
watery	12	39	1449	3	watery
wavery	15	46	1005	3	wavery
weary	11	56	2061	3	_weary
yager	9	56	1675	3	yager_
yagers	10	51	1453	3	yagers
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.140	1276364.3
2	DLD Change Limit	112716	337	5.750	19602.8
3	Display Results	337	337	0.110	3063.6
	(SQL Overall)	178691	337	6.000	29781.8