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

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

298 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
wany	10	64	3236	(None)
any	6	84	4049	1	_any
awny	10	59	1930	1	awny
many	9	57	3186	1	many
wady	11	53	2499	1	wady
waly	10	58	3090	1	waly
wan	6	67	6194	1	wan_
wand	8	58	3388	1	wand
wane	7	63	4472	1	wane
waney	11	51	2032	1	waney
wank	11	56	3251	1	wank
wanly	11	51	1802	1	wanly
wans	7	64	5227	1	wans
want	7	61	5617	1	want
wary	10	67	4001	1	wary
wavy	13	66	2047	1	wavy
waxy	17	59	1820	1	waxy
way	9	67	5766	1	wa_y
winy	10	70	3432	1	winy
zany	16	73	1699	1	zany
aby	8	102	3806	2	_aby
an	2	118	7908	2	_an_
ana	3	95	5983	2	_ana
and	4	72	4417	2	_and
ane	3	78	6695	2	_ane
ani	3	77	5118	2	_ani
ant	3	72	7079	2	_ant
away	10	80	2422	2	away
awn	6	80	3591	2	awn_
awns	7	53	2443	2	awns
awry	10	76	1968	2	awry
ay	5	117	7389	2	_a_y
baby	11	67	2368	2	baby
ban	5	83	6684	2	ban_
band	7	67	4091	2	band
bandy	11	48	2418	2	bandy
bane	6	52	5043	2	bane
bang	7	48	3700	2	bang
bani	6	53	3496	2	bani
bank	10	58	3575	2	bank
bans	6	65	5514	2	bans
banty	10	66	2400	2	banty
barny	10	58	2173	2	barny
bay	8	96	6164	2	ba_y
bony	9	67	3208	2	bony
bwana	10	3	1024	2	bwana
cagy	10	63	2199	2	cagy
caky	13	62	2244	2	caky
can	5	77	6014	2	can_
candy	11	51	1982	2	candy
cane	6	66	5312	2	cane
canny	10	58	1769	2	canny
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
canty	10	52	2680	2	canty
carny	10	58	2292	2	carny
cavy	12	59	2000	2	cavy
cay	8	71	5598	2	ca_y
cony	9	65	3783	2	cony
dan	4	68	5967	2	dan_
dandy	10	44	1670	2	dandy
dang	6	51	3154	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
davy	11	60	1552	2	davy
day	7	62	5411	2	da_y
deny	8	60	2712	2	deny
easy	7	62	2449	2	easy
fan	6	71	5886	2	fan_
fancy	13	46	1548	2	fancy
fane	7	53	4357	2	fane
fang	8	54	3255	2	fang
fanny	11	48	1604	2	fanny
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fawny	14	47	1171	2	fawny
fay	9	74	5486	2	fa_y
gaby	10	71	2319	2	gaby
gamy	10	54	2753	2	gamy
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3197	2	gang
gapy	10	63	2091	2	gapy
gay	7	68	5649	2	ga_y
gowany	13	45	749	2	gowany
hand	8	68	3371	2	hand
handy	12	55	2087	2	handy
hang	8	55	3555	2	hang
hank	11	51	3414	2	hank
hanky	15	54	1829	2	hanky
hant	7	54	6159	2	hant
hay	9	73	5877	2	ha_y
hazy	19	181	1919	2	hazy
hwan	10	57	1689	2	hwan_
jane	11	50	3148	2	jane
janty	15	68	1696	2	janty
jay	13	62	4267	2	ja_y
kana	8	59	2853	2	kana
kane	8	51	3397	2	kane
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
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lang	5	66	3738	2	lang
lank	8	47	3445	2	lank
lanky	12	55	1748	2	lanky
lawny	11	59	1201	2	lawny
lay	6	88	6535	2	la_y
lazy	16	64	2307	2	lazy
liny	7	81	4132	2	liny
luny	7	73	2413	2	luny
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
mangy	11	50	2124	2	mangy
manly	10	50	2295	2	manly
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
may	8	87	5763	2	ma_y
mazy	18	64	1970	2	mazy
meany	10	46	2048	2	meany
mony	9	68	3001	2	mony
nan	3	78	5488	2	nan_
nana	4	66	3290	2	nana
nancy	10	52	1492	2	nancy
nanny	8	48	1381	2	nanny
nans	4	61	3940	2	nans
nary	7	69	3122	2	nary
navy	10	75	1863	2	navy
nay	6	69	5277	2	na_y
oaky	11	64	1995	2	oaky
pacy	11	53	2868	2	pacy
paly	9	58	3553	2	paly
pan	5	84	6645	2	pan_
pandy	11	50	2117	2	pandy
pane	6	49	5029	2	pane
pang	7	53	3629	2	pang
pans	6	58	5573	2	pans
pansy	10	57	1797	2	pansy
pant	6	60	6126	2	pant
panty	10	59	2930	2	panty
paty	9	52	3456	2	paty
pay	8	84	6118	2	pa_y
piny	9	118	3835	2	piny
pony	9	64	3405	2	pony
puny	9	55	2699	2	puny
racy	9	58	2568	2	racy
rainy	8	59	2108	2	rainy
ran	3	82	6662	2	ran_
rand	5	58	3957	2	rand
randy	9	50	2208	2	randy
rang	5	69	3916	2	rang
rangy	9	53	2038	2	rangy
rani	4	66	4011	2	rani
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
ray	6	63	6199	2	ra_y
sagy	8	53	2708	2	sagy
sand	5	53	3847	2	sand
sandy	9	42	2113	2	sandy
sane	4	59	5434	2	sane
sang	5	54	4123	2	sang
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
say	6	72	6476	2	sa_y
swamy	13	67	1440	2	swamy
swan	7	66	3131	2	swan_
swang	9	55	1972	2	swang
swank	12	53	1823	2	swank
swanky	16	44	797	2	swanky
swanny	12	33	682	2	swanny
swans	8	46	2501	2	swans
sway	10	71	2823	2	swa_y
tan	3	71	6757	2	tan_
tang	5	61	3867	2	tang
tangy	9	45	1993	2	tangy
tank	8	51	3402	2	tank
tans	4	61	5482	2	tans
tansy	8	45	1493	2	tansy
tawny	11	47	1365	2	tawny
tiny	7	61	3463	2	tiny
tony	7	56	3515	2	tony
twang	9	45	1185	2	twang
twangy	13	38	698	2	twangy
twanky	16	44	577	2	twanky
twiny	11	60	1281	2	twiny
van	6	62	4633	2	van_
vane	7	55	3469	2	vane
vang	8	49	2604	2	vang
vans	7	62	3673	2	vans
vary	10	52	2606	2	vary
viny	10	60	2595	2	viny
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
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
wains	8	69	3087	2	wains
wair	7	58	3005	2	wair
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
wands	9	64	2548	2	wands
waned	9	58	3178	2	waned
wanes	8	50	4088	2	wanes
wanks	12	61	2448	2	wanks
wants	8	79	3221	2	wants
wap	8	65	5337	2	wa_p
waps	9	66	4208	2	waps
war	6	72	6242	2	wa_r
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
warns	8	72	3100	2	warns
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
warty	11	93	2382	2	warty
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
wat	6	73	7892	2	wa_t
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
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
wean	7	57	3435	2	wean_
weans	8	53	2674	2	weans
weary	11	56	2061	2	weary
weeny	11	53	1616	2	weeny
wen	6	62	4960	2	wen_
wend	8	53	3045	2	wend
wenny	11	44	1246	2	wenny
wens	7	63	3793	2	wens
went	7	60	5187	2	went
whang	12	48	1338	2	whang
whey	13	50	1871	2	whey
whiny	14	49	1557	2	whiny
why	12	69	2001	2	w_hy
wily	10	64	2881	2	wily
win	6	64	5629	2	win_
wind	8	55	3385	2	wind
windy	12	61	1810	2	windy
wine	7	49	5342	2	wine
winey	11	53	2543	2	winey
wing	8	63	3922	2	wing
wingy	12	65	2103	2	wingy
wink	11	64	3502	2	wink
wino	7	59	3361	2	wino
wins	7	59	4917	2	wins
wiry	10	64	2283	2	wiry
won	6	62	5206	2	won_
wonk	11	61	2530	2	wonk
wonky	15	40	1177	2	wonky
wons	7	49	4204	2	wons
wont	7	58	4250	2	wont
wrang	9	47	1611	2	wrang
wry	9	65	2470	2	w_ry
wyn	9	59	2144	2	wyn_
wynd	11	61	1446	2	wynd
wynn	10	58	1129	2	wynn
wyns	10	57	1703	2	wyns
yang	8	56	2607	2	yang
yank	11	54	2367	2	yank
yay	9	69	4871	2	ya_y

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.313	570897.8
2	DLD Change Limit	29872	298	0.920	32469.6
3	Display Results	298	298	0.063	4730.2
	(SQL Overall)	178691	298	1.296	137878.9