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

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

303 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
zanana	15	38	1036	(None)
banana	8	32	1341	1	banana
manana	8	48	1607	1	manana
zananas	16	31	956	1	zananas
zenana	15	29	798	1	zenana
anna	4	55	2901	2	_an_na
asana	5	3	1548	2	_asana
bananas	9	33	1222	2	bananas
bandana	10	17	946	2	bandana
cabana	10	39	1356	2	cabana
canna	7	59	1933	2	can_na
jacana	15	3	793	2	jacana
jnana	12	15	904	2	_jnana
kanaka	9	35	752	2	kanaka
lantana	7	3	960	2	lantana
mananas	9	34	1473	2	mananas
manna	7	55	2254	2	man_na
nagana	7	4	894	2	nagana
nana	4	66	3290	2	__nana
panada	9	41	1305	2	panada
panama	10	42	1335	2	panama
zanza	13	7	870	2	zan_za
zenanas	16	28	623	2	zenanas
abaca	9	51	1804	3	_abaca
abaka	11	43	1382	3	_abaka
abaya	10	44	1317	3	_abaya
agama	8	58	1558	3	_agama
alan	4	68	4408	3	_alan_
aland	6	55	2641	3	_aland
alane	5	61	3561	3	_alane
alang	6	60	2351	3	_alang
alans	5	56	3617	3	_alans
alant	5	57	4229	3	_alant
amarna	8	3	979	3	_amarna
ana	3	95	5983	3	___ana
anabas	8	3	1408	3	_anabas
anal	4	80	3752	3	_ana_l
ananke	10	3	828	3	_ananke
anas	4	66	4986	3	_ana_s
anent	5	49	3184	3	_anent
anga	5	68	3135	3	_an_ga
angina	7	4	1313	3	_angina
anima	7	46	2007	3	_anima
annal	5	65	2076	3	_annal
annas	5	58	2488	3	_annas
annona	6	4	887	3	annona
anoa	4	56	3447	3	_an_oa
anon	4	61	3485	3	_anon_
ansa	4	59	2777	3	_an_sa
anta	4	68	3958	3	_an_ta
antra	5	65	2192	3	_antra
arcana	8	9	1258	3	arcana
arena	5	53	2381	3	_arena
asanas	6	5	1411	3	_asanas
avant	8	62	2466	3	_avant
azan	13	65	2178	3	_azan_
azans	14	65	1688	3	_azans
balata	8	6	1467	3	balata
banal	7	59	2599	3	bana_l
banda	8	52	2310	3	ban_da
bandanas	11	17	857	3	bandanas
bandanna	11	17	407	3	bandanna
banian	8	3	1538	3	banian_
banians	9	3	1203	3	banians
baning	9	51	2783	3	baning
banns	7	53	2123	3	ban_ns
banyan	11	3	948	3	banyan_
banyans	12	3	791	3	banyans
bonanza	18	4	384	3	bonanza
bwana	10	3	1024	3	_bwana
cabala	10	35	1691	3	cabala
cabanas	11	24	1303	3	cabanas
canal	7	54	2804	3	cana_l
canals	8	44	2166	3	canals
canape	10	9	1351	3	canape
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
canasta	9	3	836	3	canasta
cancan	10	3	1410	3	cancan_
cancans	11	3	1187	3	cancans
cancha	13	44	1161	3	cancha
canine	8	38	2670	3	canine
caning	9	41	2862	3	caning
cannas	8	45	1840	3	cannas
canny	10	58	1769	3	can_ny
canola	8	3	1362	3	canola
canon	7	47	2530	3	canon_
canons	8	55	2206	3	canons
cantala	9	41	1467	3	cantala
cantata	9	38	1181	3	cantata
cantina	9	34	1725	3	cantina
canula	8	3	1296	3	canula
canzona	18	3	607	3	canzona
carina	8	43	2532	3	carina
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
catena	8	3	1248	3	catena
choana	11	3	844	3	choana
czarina	18	4	595	3	czarina
daman	8	48	2116	3	daman_
damans	9	47	1598	3	damans
damiana	10	4	656	3	damiana
donna	6	62	1503	3	don_na
emanant	9	4	1109	3	emanant
faena	8	50	1420	3	fa_ena
fanega	10	5	578	3	fanega
fanga	9	61	1962	3	fan_ga
fanny	11	48	1604	3	fan_ny
fanon	8	46	1901	3	fanon_
fanons	9	61	1521	3	fanons
farina	9	46	1823	3	farina
fauna	8	48	1651	3	fa_una
galanga	9	3	601	3	galanga
galena	7	49	1109	3	galena
ganja	13	14	1000	3	gan_ja
gazania	17	4	612	3	gazania
goanna	7	3	665	3	goan_na
grana	6	57	2209	3	_grana
guarana	8	8	630	3	guarana
halala	9	47	1509	3	halala
hamada	12	3	992	3	hamada
haniwa	12	3	674	3	haniwa
hansa	8	54	1678	3	han_sa
hariana	10	3	1024	3	hariana
hawala	12	36	891	3	hawala
hazan	17	38	1361	3	hazan_
hazans	18	34	1165	3	hazans
henna	8	44	1404	3	hen_na
honan	8	53	1977	3	honan_
honans	9	48	1450	3	honans
iguana	7	3	581	3	iguana
inane	5	28	2034	3	_inane
jacanas	16	3	826	3	jacanas
japan	14	4	1123	3	japan_
japans	15	3	982	3	japans
jarina	13	40	1406	3	jarina
jawan	15	7	1038	3	jawan_
jawans	16	5	784	3	jawans
jnanas	13	20	730	3	_jnanas
kabaka	11	34	850	3	kabaka
kabala	12	40	1155	3	kabala
kabaya	15	38	712	3	kabaya
kahuna	13	9	410	3	kahuna
kamala	12	33	996	3	kamala
kana	8	59	2853	3	__kana
kanakas	10	32	721	3	kanakas
kanas	9	53	2691	3	kana_s
kanban	12	3	862	3	kanban_
kanbans	13	3	772	3	kanbans
kinara	10	3	1037	3	kinara
labara	8	37	1289	3	labara
lacuna	8	11	812	3	lacuna
lagan	6	65	2034	3	lagan_
lagans	7	57	1778	3	lagans
laguna	7	12	722	3	laguna
lamina	8	49	2044	3	lamina
lanai	5	3	1957	3	lana_i
lanais	6	3	1679	3	lanais
lanate	6	4	2126	3	lanate
lantanas	8	3	826	3	lantanas
lasagna	8	4	354	3	lasagna
latina	6	56	2114	3	latina
lauan	5	52	1679	3	lauan_
lauans	6	51	1353	3	lauans
liana	5	39	1589	3	_liana
malanga	10	3	666	3	malanga
mana	6	53	4196	3	__mana
manage	9	38	1890	3	manage
manas	7	62	4043	3	mana_s
manat	7	60	3999	3	mana_t
manats	8	46	2346	3	manats
mandala	10	3	1021	3	mandala
manga	8	50	2620	3	man_ga
mania	7	56	3415	3	man_ia
manila	8	45	1830	3	manila
mannan	8	54	1362	3	mannan
mannans	9	36	1152	3	mannans
mannas	8	50	1980	3	mannas
manta	7	56	2991	3	man_ta
mantra	8	41	1609	3	mantra
mantua	8	44	1202	3	mantua
maraca	10	3	1415	3	maraca
maranta	9	3	1169	3	maranta
marina	8	46	2341	3	marina
masala	8	3	1181	3	masala
mayan	10	56	1690	3	mayan_
naan	4	76	2193	3	na_an_
naans	5	58	1525	3	na_ans
nada	5	80	2290	3	__nada
naganas	8	4	798	3	naganas
nala	4	69	3039	3	__nala
nan	3	78	5488	3	__nan_
nanas	5	59	2863	3	nana_s
nandina	8	3	891	3	nandina
nanny	8	48	1381	3	nan_ny
nans	4	61	3940	3	__nans
napa	6	69	2726	3	__napa
natant	6	3	1873	3	natant
nona	4	69	2906	3	__nona
organa	7	8	921	3	organa
paean	7	72	2272	3	paean_
paeans	8	51	1826	3	paeans
pagan	8	61	2116	3	pagan_
pagans	9	57	1792	3	pagans
paisana	9	40	1022	3	paisana
pajama	17	31	765	3	pajama
palapa	10	3	1067	3	palapa
panacea	11	3	778	3	panacea
panadas	10	33	1221	3	panadas
panamas	11	31	1276	3	panamas
panda	8	50	2261	3	pan_da
pandani	10	3	990	3	pandani
panga	8	53	2353	3	pan_ga
panini	8	3	1427	3	panini
panino	8	3	1568	3	panino
panne	7	66	2365	3	pan_ne
papaya	13	3	750	3	papaya
parang	9	37	1551	3	parang
pataca	10	3	1119	3	pataca
patina	8	60	2219	3	patina
pavan	10	65	1847	3	pavan_
pavane	11	41	1344	3	pavane
pavans	11	57	1559	3	pavans
penang	9	25	1111	3	penang
penna	7	45	2020	3	pen_na
pinang	9	26	1159	3	pinang
pinata	8	38	1722	3	pinata
pinna	7	53	2018	3	pin_na
pirana	8	7	1326	3	pirana
purana	8	7	1293	3	purana
qabala	17	39	919	3	qabala
qanat	14	44	2684	3	qana_t
qanats	15	41	1281	3	qanats
ramada	9	3	1018	3	ramada
ramona	8	4	1241	3	ramona
randan	7	3	1525	3	randan_
randans	8	3	1321	3	randans
ranula	6	3	1181	3	ranula
ratan	5	37	2266	3	ratan_
ratans	6	38	1937	3	ratans
ratany	9	34	1187	3	ratany
ruana	5	3	1242	3	_ruana
salina	6	42	2112	3	salina
samara	8	3	1385	3	samara
sancta	8	3	983	3	sancta
sanga	6	60	2379	3	san_ga
saning	7	51	2764	3	saning
saran	5	37	3030	3	saran_
sarans	6	42	2443	3	sarans
sardana	8	3	864	3	sardana
satang	7	57	1156	3	satang
satara	6	3	1553	3	satara
sauna	5	41	1755	3	sa_una
savanna	10	4	371	3	savanna
savant	9	4	1604	3	savant
senna	5	46	1798	3	sen_na
sonant	6	6	2195	3	sonant
sonata	6	3	1322	3	sonata
sunna	5	50	1606	3	sun_na
tanga	6	49	2369	3	tan_ga
tanka	9	38	1748	3	tan_ka
tantara	7	24	1082	3	tantara
tantra	6	37	1335	3	tantra
tarama	8	4	1273	3	tarama
tartana	7	30	1019	3	tartana
tenant	6	3	2247	3	tenant
tzarina	16	3	505	3	tzarina
vacant	11	4	1513	3	vacant
vagina	10	27	1093	3	vagina
vanda	9	45	1592	3	van_da
vanman	11	3	979	3	vanman_
varna	8	45	1617	3	va_rna
wakanda	15	4	401	3	wakanda
wangan	10	3	1122	3	wangan_
wangans	11	4	950	3	wangans
waning	10	36	2380	3	waning
yantra	9	44	962	3	yantra
zamarra	18	4	378	3	zamarra
zamia	16	51	1521	3	za_mia
zander	16	34	1711	3	zander
zanier	15	43	1471	3	zanier
zanies	15	32	1967	3	zanies
zanily	18	3	1018	3	zanily
zany	16	73	1699	3	z__any
zanzas	14	8	705	3	zanzas
zareba	17	3	642	3	zareba
zariba	17	3	698	3	zariba
zayin	17	45	1204	3	zayin_
zayins	18	40	971	3	zayins
zazen	13	3	728	3	zazen_
zazens	14	3	583	3	zazens
zenaida	17	91	478	3	zenaida
zingani	17	4	481	3	zingani
zingano	17	4	420	3	zingano
zingara	17	4	551	3	zingara
zinnia	15	3	601	3	zinnia
zona	13	63	2196	3	z__ona
zonae	14	51	1644	3	zona_e
zonal	14	51	1685	3	zona_l
zonary	18	3	879	3	zonary
zonate	15	41	1492	3	zonate
zoning	16	29	1433	3	zoning
zonula	15	3	722	3	zonula

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.390	458182.1
2	DLD Change Limit	112716	303	6.656	16934.5
3	Display Results	303	303	0.093	3258.1
	(SQL Overall)	178691	303	7.139	25030.3