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

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

322 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
gowany	13	45	749	(None)
gowan	9	54	1574	1	gowan_
gowans	10	55	1229	1	gowans
botany	11	3	926	2	botany
downy	12	57	1455	2	dow_ny
goban	8	44	1407	2	goban_
gobang	10	37	670	2	gobang
gobans	9	44	1204	2	gobans
gobony	12	3	691	2	gobony
goony	9	55	1978	2	go_ony
gowaned	12	3	576	2	gowaned
gown	8	57	2407	2	gow_n_
gowns	9	51	1510	2	gow_ns
noway	11	11	1284	2	nowa_y
rowan	8	54	1873	2	rowan_
rowans	9	57	1534	2	rowans
sowans	9	42	1589	2	sowans
towny	11	61	1449	2	tow_ny
wany	10	64	3236	2	__wany
agony	9	64	1565	3	ago__ny
ajowan	16	3	489	3	ajowan_
ajowans	17	3	400	3	ajowans
alway	11	61	1392	3	alwa_y
any	6	84	4049	3	___any
away	10	80	2422	3	_awa_y
awny	10	59	1930	3	_aw_ny
bogan	8	75	1900	3	bogan_
bogans	9	57	1481	3	bogans
bonny	10	58	1662	3	bo_nny
bony	9	67	3208	3	bo__ny
borane	8	46	2021	3	borane
bowery	14	60	1211	3	bowery
bowing	12	47	2306	3	bowing
bowman	13	12	985	3	bowman_
brawny	14	47	1060	3	brawny
browny	14	45	1004	3	brow_ny
bwana	10	3	1024	3	_bwana
byway	16	4	753	3	bywa_y
coaly	10	55	2159	3	co_aly
cogway	15	6	618	3	cogwa_y
colony	11	54	1727	3	colony
company	16	197	1114	3	company
cony	9	65	3783	3	co__ny
copay	12	65	1631	3	copa_y
corny	10	60	2327	3	co_rny
cotan	7	15	2178	3	cotan_
cotans	8	13	1792	3	cotans
covary	14	3	874	3	covary
cowage	12	3	1067	3	cowage
coward	12	4	1167	3	coward
cowbane	14	3	767	3	cowbane
cowboy	16	3	706	3	cowboy
cowhand	16	6	593	3	cowhand
cowing	12	45	2632	3	cowing
cowman	13	9	1037	3	cowman_
cowry	13	55	1248	3	cow_ry
cowy	12	64	2736	3	cow__y
dewan	9	57	1804	3	dewan_
dewans	10	52	1514	3	dewans
diwan	9	57	1255	3	diwan_
diwans	10	51	1037	3	diwans
dopant	9	3	1613	3	dopant
dowdy	13	61	1254	3	dow_dy
dowery	13	43	1166	3	dowery
dowing	11	42	2151	3	dowing
down	8	64	2749	3	dow_n_
downs	9	49	1857	3	dow_ns
dowry	12	63	1248	3	dow_ry
fawny	14	47	1171	3	faw_ny
foamy	13	53	1320	3	fo_amy
foray	11	50	2397	3	fora_y
gaby	10	71	2319	3	g__aby
galaxy	17	47	631	3	galaxy
gamay	11	64	1911	3	gama_y
gamy	10	54	2753	3	g__amy
gan	4	80	6013	3	g__an_
gane	5	51	4530	3	g__ane
gang	6	60	3197	3	g__ang
gapy	10	63	2091	3	g__apy
gawky	16	56	999	3	gaw_ky
gawsy	12	45	909	3	gaw_sy
gay	7	68	5649	3	g__a_y
gelant	7	28	2167	3	gelant
geomancy	16	4	415	3	geomancy
giant	6	54	3059	3	g_iant
ginny	9	53	1457	3	g_inny
gitano	7	3	804	3	gitano
glady	10	54	1394	3	g_lady
gland	7	52	1771	3	g_land
glans	6	51	2583	3	g_lans
glary	9	60	1854	3	g_lary
glazy	18	74	1098	3	g_lazy
gleamy	12	39	811	3	gleamy
glean	6	58	1820	3	glean_
gleans	7	50	1474	3	gleans
glowfly	17	4	267	3	glowfly
glowing	12	32	1179	3	glowing
gnawn	9	51	778	3	gnawn_
goa	4	73	4380	3	go_a__
goad	6	68	3098	3	go_a_d
goads	7	70	2285	3	go_ads
goal	5	58	2930	3	go_a_l
goals	6	55	2129	3	go_als
goanna	7	3	665	3	goanna
goas	5	52	3994	3	go_a_s
goat	5	62	5083	3	go_a_t
goats	6	55	2730	3	go_ats
gobangs	11	38	583	3	gobangs
goby	10	60	2108	3	go__by
godly	10	49	1329	3	go_dly
goggly	12	33	705	3	goggly
going	7	52	1849	3	go_ing
golly	9	51	2110	3	go_lly
gonad	7	52	1605	3	gona_d
gonads	8	45	1173	3	gonads
gone	5	56	3904	3	go__ne
gong	6	68	2719	3	go__ng
goodby	13	40	628	3	goodby
goodly	11	41	930	3	goodly
goody	10	56	2039	3	go_ody
gooey	9	55	2286	3	go_oey
goofy	12	49	1562	3	go_ofy
googly	11	41	788	3	googly
gooky	13	58	1803	3	go_oky
goon	5	72	3617	3	go_on_
gooney	10	66	1231	3	gooney
goons	6	53	2677	3	go_ons
goopy	11	58	1662	3	go_opy
goosey	10	59	1351	3	goosey
goosy	9	60	1888	3	go_osy
goral	6	51	2575	3	gora_l
gorals	7	69	1765	3	gorals
gorily	10	6	1250	3	gorily
goring	8	41	1957	3	goring
gormand	11	5	745	3	gormand
gorsy	9	59	1578	3	go_rsy
gory	8	61	2966	3	go__ry
gossan	7	4	723	3	gossan_
gossans	8	3	678	3	gossans
gouty	9	52	1736	3	go_uty
gowd	9	65	1998	3	gow__d
gowds	10	58	1404	3	gow_ds
gowk	12	55	1647	3	gow__k
gowks	13	60	1195	3	gow_ks
gowned	11	44	1013	3	gowned
gowning	12	25	883	3	gowning
goy	7	78	4455	3	go___y
grainy	10	39	1421	3	grainy
gran	5	63	3501	3	g_ran_
grana	6	57	2209	3	g_rana
grand	7	51	2269	3	g_rand
granny	10	43	1116	3	granny
grans	6	48	3254	3	g_rans
grant	6	48	4002	3	g_rant
grapy	11	54	1643	3	g_rapy
gravy	12	55	1211	3	g_ravy
gray	8	53	2989	3	g_ra_y
greasy	10	41	946	3	greasy
greeny	10	48	1145	3	greeny
groan	6	56	1842	3	groan_
groans	7	48	1506	3	groans
growing	12	35	1247	3	growing
growly	13	49	917	3	grow_ly
grown	9	53	1735	3	grow_n_
growthy	17	7	328	3	growthy
guan	5	53	2558	3	g_uan_
guanay	10	3	791	3	g_uanay
guano	6	92	1398	3	g_uano
guans	6	44	1944	3	g_uans
gunny	9	44	1366	3	g_unny
gwine	9	55	1366	3	g_wine
hoagy	12	47	1047	3	ho_agy
hoary	11	45	1676	3	ho_ary
hogan	9	78	1770	3	hogan_
hogans	10	59	1431	3	hogans
hominy	14	45	1148	3	hominy
honan	8	53	1977	3	honan_
honans	9	48	1450	3	honans
horary	12	3	1038	3	horary
horny	11	56	1962	3	ho_rny
howdy	15	57	1141	3	how_dy
hwan	10	57	1689	3	_hwan_
jawan	15	7	1038	3	jawan_
jawans	16	5	784	3	jawans
johnny	19	3	219	3	johnny
jowar	15	52	1143	3	jowa_r
jowars	16	36	965	3	jowars
jowing	17	42	1604	3	jowing
jowly	18	64	1090	3	jow_ly
koan	8	54	2503	3	ko_an_
koans	9	58	1862	3	ko_ans
koruny	13	3	444	3	koruny
lawny	11	59	1201	3	law_ny
litany	9	3	905	3	litany
loamy	10	59	1334	3	lo_amy
loan	4	74	3645	3	lo_an_
loans	5	60	2646	3	lo_ans
logan	6	81	2328	3	logan_
logans	7	63	1906	3	logans
logway	13	3	591	3	logwa_y
loony	8	69	1896	3	lo_ony
loran	5	59	2509	3	loran_
lorans	6	51	1760	3	lorans
lowboy	14	3	590	3	lowboy
lowery	12	41	1271	3	lowery
lowing	10	46	2327	3	lowing
lowland	11	3	469	3	lowland
lowly	11	41	1333	3	low_ly
lown	7	69	2929	3	low_n_
many	9	57	3186	3	__many
meany	10	46	2048	3	_meany
moan	6	58	3202	3	mo_an_
moans	7	46	2437	3	mo_ans
mony	9	68	3001	3	mo__ny
moony	10	48	1827	3	mo_ony
moray	10	54	2379	3	mora_y
mowing	12	41	1909	3	mowing
mown	9	54	2444	3	mow_n_
notary	9	23	1071	3	notary
noways	12	12	773	3	noways
oaky	11	64	1995	3	_o_aky
ofay	10	64	1610	3	_ofa_y
okay	11	59	1766	3	_oka_y
oogamy	12	3	563	3	oogamy
oogeny	10	11	792	3	oogeny
orang	6	51	1994	3	_orang
orangy	10	51	1123	3	_orangy
ovary	11	4	911	3	_ovary
owing	9	62	2272	3	_owing
own	6	64	2970	3	_ow_n_
owns	7	68	1958	3	_ow_ns
pony	9	64	3405	3	po__ny
porny	10	60	2019	3	po_rny
ratany	9	34	1187	3	ratany
rewan	8	56	2366	3	rewan_
roan	4	72	3420	3	ro_an_
roans	5	49	2644	3	ro_ans
roband	9	23	1072	3	roband
roman	7	54	2482	3	roman_
romano	8	49	1294	3	romano
romans	8	46	2024	3	romans
rosary	9	28	1035	3	rosary
rosiny	9	44	1453	3	rosiny
rotary	9	24	1130	3	rotary
rowdy	12	57	1153	3	row_dy
rowen	8	49	2115	3	rowen_
rowens	9	45	1530	3	rowens
rowing	10	36	2330	3	rowing
sewan	8	59	2129	3	sewan_
sewans	9	52	1590	3	sewans
soapy	10	61	1478	3	so_apy
solan	5	53	2815	3	solan_
soland	7	51	1504	3	soland
solano	6	53	1418	3	solano
solans	6	41	2249	3	solans
soman	7	50	2490	3	soman_
somans	8	46	1930	3	somans
sonant	6	6	2195	3	sonant
sonny	8	50	1610	3	so_nny
sowar	8	58	2134	3	sowa_r
sowars	9	43	1801	3	sowars
sowens	9	36	1315	3	sowens
sowing	10	42	2291	3	sowing
sown	7	51	2745	3	sow_n_
swamy	13	67	1440	3	_swamy
swan	7	66	3131	3	_swan_
swang	9	55	1972	3	_swang
swank	12	53	1823	3	_swank
swanky	16	44	797	3	_swanky
swanny	12	33	682	3	_swanny
swans	8	46	2501	3	_swans
sway	10	71	2823	3	_swa_y
swoony	12	40	826	3	swoony
tawny	11	47	1365	3	taw_ny
tetany	9	5	984	3	tetany
toady	9	68	1434	3	to_ady
today	9	64	1695	3	toda_y
tokay	12	55	1305	3	toka_y
tolan	5	51	2401	3	tolan_
tolane	6	43	1658	3	tolane
tolans	6	43	1927	3	tolans
toman	7	57	2405	3	toman_
tomans	8	54	1913	3	tomans
tony	7	56	3515	3	to__ny
towage	10	3	983	3	towage
toward	10	3	1106	3	toward
towaway	16	4	415	3	towaway
towery	12	40	1209	3	towery
towing	10	38	2319	3	towing
town	7	69	2870	3	tow_n_
towns	8	60	1888	3	tow_ns
towy	10	53	2547	3	tow__y
twang	9	45	1185	3	_twang
twangy	13	38	698	3	_twangy
twanky	16	44	577	3	_twanky
twiny	11	60	1281	3	_twiny
unwary	12	3	982	3	unwary
volant	9	3	1632	3	volant
votary	12	24	833	3	votary
vowing	13	37	1527	3	vowing
wady	11	53	2499	3	__wady
waly	10	58	3090	3	__waly
wan	6	67	6194	3	__wan_
wand	8	58	3388	3	__wand
wane	7	63	4472	3	__wane
waney	11	51	2032	3	__waney
wank	11	56	3251	3	__wank
wanly	11	51	1802	3	__wanly
wans	7	64	5227	3	__wans
want	7	61	5617	3	__want
wary	10	67	4001	3	__wary
wavy	13	66	2047	3	__wavy
waxy	17	59	1820	3	__waxy
way	9	67	5766	3	__wa_y
winy	10	70	3432	3	__winy
woman	10	58	1800	3	woman_
womanly	15	3	585	3	womanly
womans	11	46	1365	3	womans
wowing	13	39	1539	3	wowing
yowing	13	37	1554	3	yowing
zany	16	73	1699	3	__zany
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.736	242786.7
2	DLD Change Limit	112716	322	5.686	19823.4
3	Display Results	322	322	0.093	3462.4
	(SQL Overall)	178691	322	6.515	27427.6