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

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

345 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
guanay	10	3	791	(None)
guanays	11	3	495	1	guanays
gamay	11	64	1911	2	g_amay
grana	6	57	2209	2	grana_
granary	11	5	779	2	granary
granny	10	43	1116	2	granny
guaiac	9	4	615	2	guaiac
guan	5	53	2558	2	guan__
guanaco	10	6	458	2	guanaco
guanase	8	3	621	2	guanase
guanin	7	6	1080	2	guanin
guano	6	92	1398	2	guan_o
guanos	7	38	1199	2	guanos
guans	6	44	1944	2	guan_s
guava	9	3	858	2	guava_
guavas	10	3	716	2	guavas
gunky	13	55	1411	2	gu_nky
gunny	9	44	1366	2	gu_nny
gurney	10	42	941	2	gurney
iguana	7	3	581	2	iguana_
iguanas	8	3	538	2	iguanas
ruana	5	3	1242	2	ruana_
ruanas	6	3	1126	2	ruanas
ana	3	95	5983	3	__ana_
anal	4	80	3752	3	__anal
anas	4	66	4986	3	__anas
any	6	84	4049	3	__an_y
asana	5	3	1548	3	asana_
asanas	6	5	1411	3	asanas
aunty	8	59	1981	3	au_nty
away	10	80	2422	3	__away
banal	7	59	2599	3	_banal
bandy	11	48	2418	3	_bandy
banty	10	66	2400	3	_banty
brandy	12	47	1206	3	brandy
branny	11	51	1183	3	branny
buna	6	47	3072	3	bu_na_
bunas	7	51	2657	3	bu_nas
bunny	10	47	1580	3	bu_nny
bunya	10	38	1009	3	bu_nya
bwana	10	3	1024	3	bwana_
bwanas	11	5	744	3	bwanas
canal	7	54	2804	3	_canal
canary	11	3	1469	3	_canary
candy	11	51	1982	3	_candy
canny	10	58	1769	3	_canny
canty	10	52	2680	3	_canty
chancy	16	40	1086	3	chancy
chanty	14	52	1582	3	chanty
clanky	15	46	907	3	clanky
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
cullay	11	39	1017	3	cullay
cutaway	15	4	443	3	cutaway
dandy	10	44	1670	3	_dandy
dually	10	32	1006	3	dually
dunam	8	3	1373	3	du_nam
dungy	10	47	1364	3	du_ngy
fancy	13	46	1548	3	_fancy
fanny	11	48	1604	3	_fanny
fauna	8	48	1651	3	fauna_
faunae	9	52	1037	3	faunae
faunal	9	47	1159	3	faunal
faunas	9	40	1363	3	faunas
funky	15	43	1513	3	fu_nky
funny	11	46	1483	3	fu_nny
gabby	13	55	1295	3	g_abby
gaby	10	71	2319	3	g_a_by
gaga	6	66	2555	3	g_aga_
gaily	9	50	2097	3	g_aily
gainly	10	4	932	3	gainly
gainsay	11	4	403	3	gainsay
gala	5	56	3516	3	g_ala_
galah	9	59	1763	3	g_alah
galas	6	57	3164	3	g_alas
galax	13	53	1446	3	g_alax
galaxy	17	47	631	3	g_alaxy
gally	9	50	2617	3	g_ally
gama	7	70	3552	3	g_ama_
gamas	8	54	3136	3	g_amas
gamays	12	63	1091	3	g_amays
gamey	11	53	2055	3	g_amey
gammy	13	55	1489	3	g_ammy
gamy	10	54	2753	3	g_a_my
gan	4	80	6013	3	g_an__
gane	5	51	4530	3	g_an_e
ganef	9	63	2246	3	g_anef
ganev	9	55	1386	3	g_anev
gang	6	60	3197	3	g_an_g
gangly	11	39	1158	3	g_angly
gangs	7	62	2257	3	g_angs
gangway	15	4	423	3	g_angway
ganja	13	14	1000	3	g_anja
ganjah	17	14	550	3	g_anjah
ganjas	14	14	911	3	g_anjas
ganof	9	54	2036	3	g_anof
gantry	10	38	1011	3	g_antry
gappy	13	62	1203	3	g_appy
gapy	10	63	2091	3	g_a_py
gassy	9	55	1402	3	g_assy
gaudy	10	66	1146	3	g_audy
gaun	5	64	2771	3	gaun__
gaunt	6	54	3040	3	gaun_t
gauntly	11	3	533	3	gauntly
gauntry	11	5	411	3	gauntry
gauzy	18	48	921	3	g_auzy
gawky	16	56	999	3	g_awky
gawsy	12	45	909	3	g_awsy
gay	7	68	5649	3	g___ay
gayal	9	3	1271	3	g_ayal
gayly	12	45	1309	3	g_ayly
gazar	15	46	1298	3	g_azar
getaway	14	4	401	3	getaway
gharry	13	54	627	3	gharry
giant	6	54	3059	3	gian_t
giants	7	47	1350	3	giants
ginny	9	53	1457	3	g_inny
gladly	11	49	793	3	gladly
glady	10	54	1394	3	gla_dy
glairy	10	44	827	3	glairy
glance	9	43	1231	3	glance
gland	7	52	1771	3	glan_d
glands	8	53	1440	3	glands
glans	6	51	2583	3	glan_s
glary	9	60	1854	3	gla_ry
glassy	10	52	775	3	glassy
glazy	18	74	1098	3	gla_zy
glinty	10	69	1069	3	glinty
gnar	5	60	2138	3	g__nar
gnarly	10	46	1038	3	gnarly
gnat	5	60	3443	3	g__nat
gnatty	10	33	648	3	gnatty
gnaw	8	65	1574	3	g__naw
goanna	7	3	665	3	goanna
goannas	8	3	622	3	goannas
gonad	7	52	1605	3	g_onad
gooney	10	66	1231	3	gooney
goony	9	55	1978	3	goon_y
gowany	13	45	749	3	gowan_y
graal	6	43	1650	3	gra_al
grabby	14	33	618	3	grabby
graham	12	3	785	3	graham
grainy	10	39	1421	3	grainy
grama	8	56	2028	3	grama_
gramary	13	5	590	3	gramary
gramas	9	43	1720	3	gramas
gran	5	63	3501	3	gran__
grand	7	51	2269	3	gran_d
grandad	10	3	845	3	grandad
grandam	11	3	939	3	grandam
grandly	12	3	874	3	grandly
grands	8	42	1824	3	grands
grange	8	37	1620	3	grange
grans	6	48	3254	3	gran_s
grant	6	48	4002	3	gran_t
grants	7	37	2247	3	grants
granum	9	3	1091	3	granum
grapey	12	60	1230	3	grapey
grapy	11	54	1643	3	gra_py
grassy	10	61	909	3	grassy
gravy	12	55	1211	3	gra_vy
gray	8	53	2989	3	g__ray
grayly	13	28	796	3	grayly
grungy	11	34	597	3	grungy
guaco	8	50	1216	3	gua_co
guacos	9	44	1031	3	guacos
guaiacs	10	5	435	3	guaiacs
guanacos	11	6	381	3	guanacos
guanases	9	3	623	3	guanases
guanine	8	8	1054	3	guanine
guanins	8	8	1001	3	guanins
guar	5	69	2329	3	gu__ar
guarana	8	8	630	3	guarana
guaranas	9	9	594	3	guaranas
guarani	8	10	627	3	guarani
guaranty	12	4	415	3	guaranty
guard	7	44	1554	3	gua_rd
guards	8	46	1157	3	guards
guars	6	50	2105	3	gua_rs
guenon	7	3	640	3	guenon
guffaw	16	4	279	3	guffaw
guilty	10	41	823	3	guilty
guinea	7	3	761	3	guinea
guineas	8	3	675	3	guineas
guitar	7	11	744	3	guitar
gulag	7	3	1082	3	gu_lag
gular	6	3	1483	3	gu_lar
gulfy	12	46	1200	3	gu_lfy
gulley	10	42	1316	3	gulley
gully	9	40	2068	3	gu_lly
gulpy	11	46	1276	3	gu_lpy
gumma	10	53	1310	3	gumma_
gummas	11	48	1051	3	gummas
gummy	13	54	1365	3	gu_mmy
gun	4	72	4080	3	gu_n__
gunk	9	54	2357	3	gu_n_k
gunks	10	45	1772	3	gu_nks
gunman	9	29	945	3	gunman
gunned	8	35	1309	3	gunned
gunnel	7	34	1105	3	gunnel
gunnen	7	33	871	3	gunnen
gunner	7	38	1398	3	gunner
gunnery	11	37	637	3	gunnery
gunplay	13	4	323	3	gunplay
guns	5	55	3348	3	gu_n_s
guppy	13	52	1127	3	gu_ppy
gurnard	9	4	477	3	gurnard
gurnet	7	49	2087	3	gurnet
gurneys	11	40	646	3	gurneys
gurry	9	45	1541	3	gu_rry
gushy	12	52	1312	3	gu_shy
gussy	9	53	1432	3	gu_ssy
gusty	9	51	1957	3	gu_sty
gutsy	9	64	1284	3	gu_tsy
gutta	6	46	1338	3	gutta_
guttae	7	32	1058	3	guttae
gutty	9	45	1699	3	gu_tty
guy	7	57	2894	3	gu___y
handy	12	55	2087	3	_handy
hanky	15	54	1829	3	_hanky
hogmanay	17	6	284	3	hogmanay
humanly	15	4	568	3	humanly
hunky	15	54	1773	3	hu_nky
hurray	12	45	991	3	hurray
iguanian	9	4	355	3	iguanian
iguanid	9	4	456	3	iguanid
janty	15	68	1696	3	_janty
jaunty	16	38	851	3	jaunty
jnana	12	15	904	3	jnana_
jnanas	13	20	730	3	jnanas
junky	19	45	1323	3	ju_nky
kana	8	59	2853	3	_kana_
kanas	9	53	2691	3	_kanas
kuna	8	51	2070	3	ku_na_
lanai	5	3	1957	3	_lanai
lanky	12	55	1748	3	_lanky
leanly	9	38	1150	3	leanly
liana	5	39	1589	3	liana_
lianas	6	37	1338	3	lianas
luna	4	62	2985	3	lu_na_
lunacy	11	3	684	3	lunacy
lunar	5	70	1731	3	lu_nar
lunas	5	50	2501	3	lu_nas
luny	7	73	2413	3	lu_n_y
lupanar	9	6	328	3	lupanar
mana	6	53	4196	3	_mana_
manas	7	62	4043	3	_manas
manat	7	60	3999	3	_manat
mangy	11	50	2124	3	_mangy
manly	10	50	2295	3	_manly
many	9	57	3186	3	_man_y
maundy	12	50	678	3	maundy
meanly	11	54	1204	3	meanly
meany	10	46	2048	3	mean_y
nana	4	66	3290	3	_nana_
nanas	5	59	2863	3	_nanas
nancy	10	52	1492	3	_nancy
nanny	8	48	1381	3	_nanny
nay	6	69	5277	3	___nay
nuance	8	5	904	3	nuance
orangy	10	51	1123	3	orangy
outlay	9	27	1179	3	outlay
outsay	9	26	1187	3	outsay
pandy	11	50	2117	3	_pandy
pansy	10	57	1797	3	_pansy
panty	10	59	2930	3	_panty
planar	8	42	1271	3	planar
puna	6	53	3165	3	pu_na_
punas	7	48	2675	3	pu_nas
punky	14	44	1939	3	pu_nky
punny	10	42	1771	3	pu_nny
punty	10	60	2161	3	pu_nty
puny	9	55	2699	3	pu_n_y
purana	8	7	1293	3	purana_
puranas	9	7	1264	3	puranas
qanat	14	44	2684	3	_qanat
quacky	24	37	696	3	quacky
quaggy	20	8	468	3	quaggy
quaky	21	43	1074	3	qua_ky
qualmy	20	28	580	3	qualmy
quandary	21	4	343	3	quandary
quango	16	3	649	3	quango
quant	14	36	2481	3	quan_t
quanta	15	39	1133	3	quanta
quantal	16	36	789	3	quantal
quants	15	36	1414	3	quants
quarry	18	3	747	3	quarry
quasar	15	3	683	3	quasar
quay	16	46	1835	3	qu__ay
quinary	19	3	693	3	quinary
quinsy	18	38	635	3	quinsy
randy	9	50	2208	3	_randy
rangy	9	53	2038	3	_rangy
runaway	13	4	368	3	runaway
runny	8	46	1348	3	ru_nny
runty	8	61	1904	3	ru_nty
runway	12	10	597	3	runway
sandy	9	42	2113	3	_sandy
satay	8	47	1846	3	_satay
sauna	5	41	1755	3	sauna_
saunas	6	39	1543	3	saunas
scanty	11	40	1466	3	scanty
seaway	12	30	999	3	seaway
shandy	13	47	1003	3	shandy
shanny	12	41	1009	3	shanny
shanty	12	47	1512	3	shanty
skanky	12	47	696	3	skanky
slangy	10	54	1139	3	slangy
slanty	9	51	1484	3	slanty
suably	11	28	1453	3	suably
subway	14	4	707	3	subway
sunna	5	50	1606	3	sunna_
sunnah	9	36	935	3	sunnah
sunnas	6	39	1456	3	sunnas
sunny	8	49	1774	3	su_nny
sunray	9	3	1012	3	sunray
swanky	16	44	797	3	swanky
swanny	12	33	682	3	swanny
tangy	9	45	1993	3	_tangy
tansy	8	45	1493	3	_tansy
tranny	9	42	1086	3	tranny
truancy	12	4	499	3	truancy
tuna	4	51	2784	3	tu_na_
tunas	5	42	2412	3	tu_nas
tunny	8	65	1503	3	tu_nny
twangy	13	38	698	3	twangy
twanky	16	44	577	3	twanky
ulna	4	63	1732	3	_ulna_
ulnad	6	56	1145	3	_ulnad
ulnae	5	52	1457	3	_ulnae
ulnar	5	60	1398	3	_ulnar
ulnas	5	57	1653	3	_ulnas
unai	4	48	2478	3	_u_nai
unary	8	3	1599	3	_unary
unau	4	39	2415	3	_u_nau
undy	8	50	1516	3	_u_ndy
unlay	8	46	1370	3	_unlay
unsay	8	32	1284	3	_unsay
vaunty	12	40	906	3	vaunty
waney	11	51	2032	3	_waney
wanly	11	51	1802	3	_wanly
wany	10	64	3236	3	_wan_y
yuan	7	61	2001	3	yuan__
yuans	8	46	1332	3	yuan_s
zany	16	73	1699	3	_zan_y

Search took 8 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	345	6.860	16430.9
3	Display Results	345	345	0.110	3136.4
	(SQL Overall)	178691	345	7.110	25132.3