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

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

349 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
wary	10	67	4001	(None)
awry	10	76	1968	1	awry
nary	7	69	3122	1	nary
vary	10	52	2606	1	vary
wady	11	53	2499	1	wady
waly	10	58	3090	1	waly
wany	10	64	3236	1	wany
war	6	72	6242	1	war_
ward	8	65	4225	1	ward
ware	7	62	5472	1	ware
wark	11	57	3777	1	wark
warm	9	59	3567	1	warm
warn	7	52	3932	1	warn
warp	9	56	3500	1	warp
wars	7	86	5980	1	wars
wart	7	78	6608	1	wart
warty	11	93	2382	1	warty
wavy	13	66	2047	1	wavy
waxy	17	59	1820	1	waxy
way	9	67	5766	1	wa_y
weary	11	56	2061	1	weary
wiry	10	64	2283	1	wiry
wry	9	65	2470	1	w_ry
aby	8	102	3806	2	_aby
aery	7	72	3168	2	aery
airy	7	57	3415	2	airy
alary	8	61	2344	2	alary
any	6	84	4049	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
award	9	71	1804	2	award
aware	8	64	2002	2	aware
away	10	80	2422	2	away
aweary	12	3	730	2	aweary
awny	10	59	1930	2	awny
ay	5	117	7389	2	_a_y
baby	11	67	2368	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	4441	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
bray	9	52	3290	2	bray
bury	9	56	3359	2	bury
cagy	10	63	2199	2	cagy
caky	13	62	2244	2	caky
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
diary	9	50	1697	2	diary
dory	8	58	3623	2	dory
dray	8	54	2809	2	dray
dry	7	65	2603	2	_dry
dwarf	12	60	1524	2	dwarf
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
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
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	3429	2	harp
harpy	13	64	1821	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
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
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	3186	2	many
mar	5	79	6595	2	mar_
mara	6	74	4457	2	mara
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
mark	10	51	3806	2	mark
marl	6	63	4162	2	marl
marly	10	69	2561	2	marly
marry	10	48	2169	2	marry
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
marvy	13	50	1403	2	marvy
may	8	87	5763	2	ma_y
mazy	18	64	1970	2	mazy
miry	9	63	2675	2	miry
narc	6	71	2795	2	narc
nard	5	66	3445	2	nard
nark	8	52	3006	2	nark
narky	12	60	1780	2	narky
navy	10	75	1863	2	navy
nay	6	69	5277	2	na_y
oaky	11	64	1995	2	oaky
oar	3	70	5795	2	oar_
oars	4	68	4603	2	oars
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
spry	9	68	1912	2	spry
swamy	13	67	1440	2	swamy
sward	9	42	2146	2	sward
sware	8	58	2821	2	sware
swarf	11	53	2465	2	swarf
swarm	10	62	1884	2	swarm
swart	8	62	3464	2	swart
swarty	12	58	1238	2	swarty
sway	10	71	2823	2	swa_y
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
unary	8	3	1599	2	unary
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
wab	8	70	5183	2	wa_b
wabs	9	73	3723	2	wabs
wack	13	53	3091	2	wack
wacky	17	47	1493	2	wacky
wad	7	70	5389	2	wa_d
waddy	13	53	1299	2	waddy
wade	8	52	3706	2	wade
wadi	8	62	2817	2	wadi
wads	8	73	4314	2	wads
wae	6	75	5695	2	wa_e
waes	7	60	4860	2	waes
wafery	15	39	869	2	wafery
waff	13	42	2804	2	waff
waft	10	61	3900	2	waft
wag	7	64	5175	2	wa_g
wage	8	48	3408	2	wage
wags	8	61	4055	2	wags
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wain	7	58	4020	2	wain
wair	7	58	3005	2	wair
wairs	8	64	2406	2	wairs
wait	7	55	5369	2	wait
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
walk	11	56	2561	2	walk
wall	7	62	3610	2	wall
wally	11	46	2509	2	wally
wame	9	50	3548	2	wame
wan	6	67	6194	2	wa_n
wand	8	58	3388	2	wand
wane	7	63	4472	2	wane
waney	11	51	2032	2	waney
wank	11	56	3251	2	wank
wanly	11	51	1802	2	wanly
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wap	8	65	5337	2	wa_p
waps	9	66	4208	2	waps
wards	9	77	3440	2	wards
wared	9	63	3987	2	wared
wares	8	82	5058	2	wares
warily	12	29	1509	2	warily
warks	12	79	3240	2	warks
warmly	14	22	806	2	warmly
warms	10	77	2685	2	warms
warns	8	72	3100	2	warns
warps	10	71	2642	2	warps
warts	8	148	4040	2	warts
was	6	87	6756	2	wa_s
wash	10	60	3381	2	wash
washy	14	59	1184	2	washy
wasp	9	56	2685	2	wasp
waspy	13	54	1099	2	waspy
wast	7	56	5585	2	wast
wastry	12	38	877	2	wastry
wat	6	73	7892	2	wa_t
watery	12	39	1449	2	watery
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
wauk	11	52	2059	2	wauk
waul	7	69	2731	2	waul
waur	7	68	1990	2	waur
wave	10	52	3473	2	wave
wavery	15	46	1005	2	wavery
wavey	14	51	1554	2	wavey
waw	9	70	4638	2	wa_w
wawl	10	53	2194	2	wawl
waws	10	68	3490	2	waws
wax	13	70	4118	2	wa_x
ways	10	77	3795	2	ways
wear	7	58	3672	2	wear_
wears	8	60	3030	2	wears
were	7	62	3833	2	were
wert	7	97	4982	2	wert
wharf	14	3	1582	2	wharf
whey	13	50	1871	2	whey
why	12	69	2001	2	w_hy
wily	10	64	2881	2	wily
winy	10	70	3432	2	winy
wire	7	58	3981	2	wire
word	8	98	3200	2	word
wordy	12	69	1616	2	wordy
wore	7	71	4467	2	wore
work	11	55	2884	2	work
worm	9	61	2949	2	worm
wormy	13	75	1425	2	wormy
worn	7	56	3175	2	worn
worry	11	61	1433	2	worry
wort	7	66	5475	2	wort
wrap	9	68	2197	2	wrap
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	1699	2	zany
zarf	16	69	2912	2	zarf

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.280	638182.1
2	DLD Change Limit	29872	349	0.766	38997.4
3	Display Results	349	349	0.080	4362.5
	(SQL Overall)	178691	349	1.126	158695.4