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

Here are the results of your fuzzy-string dictionary search for “nary” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

332 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
nary	7	69	3122	(None)
narc	6	71	2795	1	narc
nard	5	66	3445	1	nard
nark	8	52	3006	1	nark
narky	12	60	1780	1	narky
navy	10	75	1863	1	navy
nay	6	69	5277	1	na_y
unary	8	3	1599	1	unary
vary	10	52	2606	1	vary
wary	10	67	4001	1	wary
aby	8	102	3806	2	_aby
aery	7	72	3168	2	aery
airy	7	57	3415	2	airy
alary	8	61	2344	2	alary
angary	10	3	1132	2	angary
angry	9	3	1086	2	angry
any	6	84	4048	2	_any
ar	2	113	7938	2	_ar_
arb	5	104	4842	2	_arb
arc	5	102	5090	2	_arc
are	3	78	7457	2	_are
arf	6	74	5337	2	_arf
ark	7	70	4496	2	_ark
arm	5	84	4962	2	_arm
army	9	66	2418	2	_army
ars	3	76	7093	2	_ars
art	3	86	7914	2	_art
arty	7	75	3131	2	_arty
aryl	7	59	2234	2	_aryl
awry	10	76	1968	2	awry
ay	5	117	7389	2	_a_y
baby	11	67	2367	2	baby
bar	5	80	7055	2	bar_
barb	8	52	4006	2	barb
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barf	9	58	4440	2	barf
bark	10	62	4215	2	bark
barky	14	57	2161	2	barky
barm	8	67	3960	2	barm
barmy	12	52	1876	2	barmy
barn	6	64	4464	2	barn
barny	10	58	2173	2	barny
bars	6	65	6409	2	bars
barye	10	50	2149	2	barye
bay	8	96	6164	2	ba_y
binary	11	3	1222	2	binary
bray	9	52	3290	2	bray
bury	9	56	3359	2	bury
cagy	10	63	2199	2	cagy
caky	13	62	2244	2	caky
canary	11	3	1469	2	canary
car	5	91	6556	2	car_
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carny	10	58	2292	2	carny
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
carry	10	58	2378	2	carry
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
cavy	12	59	2000	2	cavy
cay	8	71	5598	2	ca_y
chary	13	50	2313	2	chary
clary	10	57	1961	2	clary
cory	9	69	4151	2	cory
cry	8	97	2624	2	_cry
dairy	9	70	1630	2	dairy
darb	7	60	3353	2	darb
dare	5	58	4886	2	dare
dark	9	51	3321	2	dark
darky	13	60	1883	2	darky
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
davy	11	60	1552	2	davy
day	7	62	5411	2	da_y
deary	9	58	2684	2	deary
denary	10	53	1686	2	denary
diary	9	50	1697	2	diary
dory	8	58	3623	2	dory
dray	8	54	2809	2	dray
dry	7	65	2603	2	_dry
ear	3	68	6788	2	ear_
earl	4	58	3814	2	earl
early	8	53	2412	2	early
earn	4	67	3755	2	earn
ears	4	63	5659	2	ears
easy	7	62	2449	2	easy
eery	7	61	2962	2	eery
entry	8	24	1426	2	entry
eyry	10	63	1588	2	eyry
faery	11	60	1548	2	faery
fairy	11	53	1828	2	fairy
far	6	77	6260	2	far_
farcy	13	52	1709	2	farcy
fard	8	56	3906	2	fard
fare	7	63	5446	2	fare
farl	7	63	3855	2	farl
farm	9	59	3453	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
fay	9	74	5486	2	fa_y
fray	10	54	2890	2	fray
fry	9	62	2650	2	_fry
fury	10	77	2797	2	fury
gaby	10	71	2319	2	gaby
gamy	10	54	2753	2	gamy
gapy	10	63	2091	2	gapy
gar	4	72	5990	2	gar_
garb	7	53	3267	2	garb
gars	5	57	5074	2	gars
gay	7	68	5649	2	ga_y
glary	9	60	1854	2	glary
gnar	5	60	2138	2	gnar_
gnarl	6	51	1557	2	gnarl
gnarly	10	46	1038	2	gnarly
gnarr	6	48	1069	2	gnarr
gnars	6	67	1885	2	gnars
gory	8	61	2966	2	gory
gray	8	53	2989	2	gray
hairy	11	53	1683	2	hairy
hard	8	54	4350	2	hard
hardy	12	56	2206	2	hardy
hare	7	62	5573	2	hare
hark	11	52	3739	2	hark
harl	7	57	4000	2	harl
harm	9	56	3779	2	harm
harp	9	61	3428	2	harp
harpy	13	64	1820	2	harpy
harry	11	53	2295	2	harry
hart	7	68	6577	2	hart
hay	9	73	5877	2	ha_y
hazy	19	181	1919	2	hazy
hoary	11	45	1676	2	hoary
inarm	7	3	1442	2	inarm
jar	10	76	4615	2	jar_
jarl	11	58	2813	2	jarl
jars	11	73	3835	2	jars
jay	13	62	4267	2	ja_y
jury	14	67	1959	2	jury
karn	8	61	2941	2	karn
kart	8	67	5080	2	kart
kaury	12	42	976	2	kaury
kay	10	67	4554	2	ka_y
knar	8	58	1872	2	knar_
knarry	13	3	461	2	knarry
knars	9	44	1611	2	knars
lacy	9	58	2963	2	lacy
lady	8	65	2715	2	lady
laky	11	67	2582	2	laky
lar	3	79	6753	2	lar_
lard	5	67	4200	2	lard
lardy	9	61	1927	2	lardy
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
larky	12	52	1887	2	larky
lars	4	69	5657	2	lars
lay	6	88	6535	2	la_y
lazy	16	64	2307	2	lazy
leary	8	59	2738	2	leary
lory	7	59	3171	2	lory
many	9	57	3184	2	many
mar	5	79	6594	2	mar_
mara	6	74	4456	2	mara
marc	8	70	3462	2	marc
mare	6	47	5932	2	mare
mark	10	51	3805	2	mark
marl	6	63	4161	2	marl
marly	10	69	2561	2	marly
marry	10	48	2169	2	marry
mars	6	62	6186	2	mars
mart	6	68	6597	2	mart
marvy	13	50	1403	2	marvy
may	8	87	5762	2	ma_y
mazy	18	64	1969	2	mazy
miry	9	63	2674	2	miry
na	2	86	5248	2	na__
naan	4	76	2193	2	naan
nab	5	69	5492	2	na_b
nabe	6	60	2949	2	nabe
nabs	6	62	3619	2	nabs
nacre	7	57	1536	2	nacre
nada	5	80	2290	2	nada
nae	3	59	5274	2	na_e
naff	10	51	2893	2	naff
nag	4	64	5081	2	na_g
naggy	10	66	1282	2	naggy
nags	5	54	3602	2	nags
nah	6	98	4700	2	na_h
naif	7	68	3901	2	naif
nail	4	58	3865	2	nail
naira	5	3	1474	2	naira
nairu	5	4	1381	2	nairu
nala	4	69	3039	2	nala
nam	5	59	5339	2	na_m
name	6	56	3741	2	name
nan	3	78	5487	2	na_n
nana	4	66	3289	2	nana
nancy	10	52	1492	2	nancy
nanny	8	48	1381	2	nanny
nans	4	61	3939	2	nans
naoi	4	60	2463	2	naoi
naos	4	74	2973	2	naos
nap	5	67	5320	2	na_p
napa	6	69	2726	2	napa
nape	6	52	3080	2	nape
napery	11	48	981	2	napery
nappy	12	63	1233	2	nappy
naps	6	62	3858	2	naps
narco	7	67	1824	2	narco
narcs	7	61	2202	2	narcs
nards	6	59	2846	2	nards
nares	5	55	4415	2	nares
naric	7	68	2417	2	naric
naris	5	57	3529	2	naris
narks	9	60	2603	2	narks
nasty	8	57	1728	2	nasty
natty	8	57	1914	2	natty
nave	7	57	3231	2	nave
navvy	14	69	668	2	navvy
naw	6	63	4649	2	na_w
nays	7	59	3159	2	nays
nazi	13	62	1987	2	nazi
near	4	52	3650	2	near_
nearby	11	35	605	2	nearby
nearly	9	48	1373	2	nearly
nears	5	55	2942	2	nears
nerd	5	66	2494	2	nerd
nerdy	9	50	1470	2	nerdy
nervy	11	46	1086	2	nervy
nixy	14	57	1451	2	nixy
nor	3	80	4882	2	nor_
nori	4	71	3314	2	nori
norm	6	64	2981	2	norm
nosy	7	63	2289	2	nosy
notary	9	23	1071	2	notary
nurd	5	62	2434	2	nurd
nurl	4	53	2724	2	nurl
oaky	11	64	1995	2	oaky
oar	3	70	5795	2	oar_
oars	4	68	4603	2	oars
onery	8	4	1411	2	onery
ovary	11	4	911	2	ovary
pacy	11	53	2868	2	pacy
paly	9	58	3553	2	paly
par	5	74	6702	2	par_
para	6	52	4217	2	para
pard	7	64	4132	2	pard
pardy	11	55	2395	2	pardy
pare	6	67	6084	2	pare
park	10	52	3749	2	park
parr	6	57	3115	2	parr
parry	10	53	2375	2	parry
pars	6	75	6079	2	pars
part	6	59	6746	2	part
party	10	66	3061	2	party
paty	9	52	3456	2	paty
pay	8	84	6118	2	pa_y
pray	9	63	3153	2	pray
pry	8	57	2805	2	_pry
racy	9	58	2568	2	racy
rare	4	53	4843	2	rare
ray	6	63	6199	2	ra_y
sagy	8	53	2708	2	sagy
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sark	8	49	3897	2	sark
sarky	12	55	2178	2	sarky
saury	8	43	1722	2	saury
say	6	72	6476	2	sa_y
scary	10	52	2259	2	scary
scry	9	60	1776	2	scry
senary	9	37	1607	2	senary
snaky	12	51	1391	2	snaky
snare	5	44	2998	2	snare
snarf	8	65	2542	2	snarf
snark	9	54	1994	2	snark
snarky	13	42	1084	2	snarky
snarl	5	49	2108	2	snarl
snarly	9	38	1500	2	snarly
spry	9	68	1912	2	spry
tar	3	75	7069	2	tar_
tardy	9	47	2046	2	tardy
tare	4	59	5762	2	tare
tarn	4	68	4272	2	tarn
taro	4	68	4691	2	taro
tarp	6	69	3641	2	tarp
tarry	8	54	2251	2	tarry
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
tarty	8	63	2818	2	tarty
teary	8	51	2405	2	teary
tory	7	58	4054	2	tory
tray	7	76	3259	2	tray
try	6	65	2967	2	_try
unarm	7	3	1445	2	unarm
unwary	12	3	982	2	unwary
var	6	61	4833	2	var_
vara	7	55	3088	2	vara
vars	7	57	4207	2	vars
very	10	80	2564	2	very
wady	11	53	2499	2	wady
waly	10	58	3090	2	waly
wany	10	64	3235	2	wany
war	6	72	6242	2	war_
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
wark	11	57	3777	2	wark
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
warty	11	93	2382	2	warty
wavy	13	66	2047	2	wavy
waxy	17	59	1820	2	waxy
way	9	67	5766	2	wa_y
weary	11	56	2061	2	weary
wiry	10	64	2283	2	wiry
wry	9	65	2470	2	_wry
yar	6	72	5383	2	yar_
yard	8	56	3325	2	yard
yare	7	56	3694	2	yare
yarn	7	52	3004	2	yarn
yay	9	69	4871	2	ya_y
zany	16	73	1698	2	zany
zarf	16	69	2912	2	zarf
zonary	18	3	879	2	zonary

Search took 2 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	29872	0.076	2351197.4
2	DLD Change Limit	29872	332	0.970	30795.9
3	Display Results	332	332	0.076	4368.4
	(SQL Overall)	178691	332	1.122	159261.1