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

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

441 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
banana	8	32	1341	(None)
bananas	9	33	1222	1	bananas
bandana	10	17	946	1	bandana
manana	8	48	1607	1	manana
zanana	15	38	1036	1	zanana
anna	4	55	2901	2	_an_na
asana	5	3	1548	2	_asana
balata	8	6	1467	2	balata
banal	7	59	2599	2	bana_l
banda	8	52	2310	2	ban_da
bandanas	11	17	857	2	bandanas
bandanna	11	17	407	2	bandanna
banian	8	3	1538	2	banian_
banians	9	3	1203	2	banians
baning	9	51	2783	2	baning
banns	7	53	2123	2	ban_ns
banyan	11	3	948	2	banyan_
banyans	12	3	791	2	banyans
bonanza	18	4	384	2	bonanza
bwana	10	3	1024	2	b_wana
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	2253	2	man_na
nagana	7	4	894	2	nagana
nana	4	66	3289	2	__nana
panada	9	41	1305	2	panada
panama	10	42	1334	2	panama
zananas	16	31	956	2	zananas
zenana	15	29	798	2	zenana
abaca	9	51	1804	3	_abaca
abaka	11	43	1382	3	_abaka
abaya	10	44	1317	3	_abaya
agama	8	58	1557	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	5982	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
baa	5	106	5042	3	b__a_a
baaed	8	52	1816	3	ba_aed
baaing	9	49	1616	3	baaing
baal	6	70	3311	3	ba_a_l
baals	7	61	2270	3	ba_als
baas	6	68	4467	3	ba_a_s
baba	8	88	2834	3	b__aba
babas	9	63	2573	3	baba_s
babka	13	78	1291	3	ba_bka
bacalao	11	4	661	3	bacalao
bacca	11	10	1218	3	ba_cca
baccara	13	4	714	3	baccara
bacon	9	56	2059	3	bacon_
bacons	10	49	1758	3	bacons
bacula	10	31	1267	3	bacula
badass	9	4	929	3	badass
badland	11	4	765	3	badland
badman	11	38	1384	3	badman_
bagass	9	3	893	3	bagass
bagman	11	46	1381	3	bagman_
bairn	7	75	1553	3	bairn_
bairns	8	67	1087	3	bairns
baiza	16	48	1322	3	ba_iza
baking	13	56	2662	3	baking
baklava	16	4	310	3	baklava
baklawa	16	4	340	3	baklawa
balance	11	5	1026	3	balance
balas	7	69	3721	3	bala_s
balatas	9	3	1183	3	balatas
balboa	10	38	996	3	balboa
baling	9	48	2969	3	baling
balsa	7	79	2041	3	ba_lsa
ban	5	83	6683	3	b__an_
banally	12	4	922	3	banally
banco	9	40	1939	3	ban_co
bancos	10	47	1389	3	bancos
band	7	67	4090	3	b__and
bandage	11	3	1102	3	bandage
bandaid	11	3	1047	3	bandaid
bandannas	12	16	328	3	bandannas
bandas	9	51	2054	3	bandas
bandeau	10	3	852	3	bandeau
banded	10	52	2317	3	banded
bander	9	39	2822	3	bander
banding	11	49	2141	3	banding
bandit	9	38	2113	3	bandit
bandog	10	3	872	3	bandog
bandora	10	3	881	3	bandora
bands	8	52	3342	3	ban_ds
bandsaw	13	3	480	3	bandsaw
bandy	11	48	2418	3	ban_dy
bane	6	52	5042	3	b__ane
baned	8	54	3635	3	ban_ed
banes	7	49	4558	3	ban_es
bang	7	48	3699	3	b__ang
banged	10	49	2372	3	banged
banger	9	44	2363	3	banger
banging	11	40	1986	3	banging
bangle	9	40	1895	3	bangle
bangs	8	56	2777	3	ban_gs
bani	6	53	3495	3	b__ani
banish	11	14	1604	3	banish
banjax	22	3	476	3	banjax
banjo	14	38	1244	3	ban_jo
banjos	15	37	889	3	banjos
bank	10	58	3574	3	b__ank
banked	13	50	2144	3	banked
banker	12	42	2273	3	banker
banking	14	46	2135	3	banking
bankit	12	36	1704	3	bankit
banks	11	55	2790	3	ban_ks
banksia	13	3	594	3	banksia
banned	9	47	2134	3	banned
banner	8	44	2150	3	banner
bannet	8	49	2533	3	bannet
banning	10	38	1823	3	banning
bans	6	65	5513	3	b__ans
bantam	10	3	1406	3	bantam
bantams	11	4	906	3	bantams
banteng	10	4	636	3	banteng
banter	8	48	2533	3	banter
banty	10	66	2400	3	ban_ty
banzai	17	3	765	3	banzai
banzais	18	3	716	3	banzais
barca	9	13	1943	3	ba_rca
baring	9	51	3585	3	baring
barman	10	35	1970	3	barman_
barn	6	64	4464	3	ba_rn_
barning	10	43	2035	3	barning
barns	7	63	3514	3	ba_rns
barny	10	58	2173	3	ba_rny
baron	7	81	3124	3	baron_
barong	9	60	1582	3	barong
barons	8	50	2538	3	barons
barony	11	59	1530	3	barony
barranca	12	4	558	3	barranca
baryta	11	43	1029	3	baryta
basal	7	57	2228	3	basa_l
basalt	8	35	1958	3	basalt
basin	7	50	2692	3	basin_
basinal	9	3	1003	3	basinal
basing	9	54	2766	3	basing
basins	8	57	2276	3	basins
bating	9	51	3225	3	bating
batman	10	52	1406	3	batman_
baton	7	58	2242	3	baton_
batons	8	55	1942	3	batons
bayamo	13	3	560	3	bayamo
bayard	12	44	1166	3	bayard
baying	12	52	2258	3	baying
bayman	13	37	1270	3	bayman_
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	baza_r
bazars	17	46	1311	3	bazars
bean	6	64	4386	3	b_ean_
beaning	10	38	2068	3	beaning
beano	7	54	2155	3	b_eano
beans	7	57	3469	3	b_eans
began	8	63	1957	3	began_
bemata	10	4	1169	3	bemata
bename	10	33	1607	3	bename
benne	7	65	2112	3	ben_ne
benni	7	47	1536	3	ben_ni
benny	10	52	1736	3	ben_ny
bezant	17	8	1454	3	bezant
bhang	11	55	1292	3	b_hang
bhangra	13	4	317	3	bhangra
binal	7	53	2382	3	bina_l
binary	11	3	1222	3	binary
binate	8	4	1977	3	binate
bisnaga	10	4	285	3	bisnaga
biznaga	19	4	234	3	biznaga
bland	8	53	2045	3	b_land
blank	11	54	1855	3	b_lank
blatant	9	3	1067	3	blatant
bogan	8	75	1900	3	bogan_
bogans	9	57	1481	3	bogans
bonaci	10	3	1096	3	bonaci
bonanzas	19	4	311	3	bonanzas
boning	9	42	2329	3	boning
bonita	8	3	1294	3	bonita
bonne	7	51	2471	3	bon_ne
bonny	10	58	1662	3	bon_ny
borane	8	46	2021	3	borane
botany	11	3	926	3	botany
bran	6	57	4038	3	b_ran_
brand	8	51	2449	3	b_rand
brank	11	52	2228	3	b_rank
branny	11	51	1183	3	bran_ny
brans	7	54	3743	3	b_rans
brant	7	47	4217	3	b_rant
brava	10	64	1479	3	b_rava
braza	16	52	1425	3	b_raza
buna	6	47	3072	3	b__una
bunas	7	51	2657	3	buna_s
bunn	6	50	2365	3	bun_n_
bunns	7	47	1829	3	bun_ns
bunny	10	47	1580	3	bun_ny
bunya	10	38	1009	3	bun_ya
buran	7	52	2530	3	buran_
burans	8	50	1930	3	burans
butane	8	3	1365	3	butane
bwanas	11	5	744	3	bwana_s
byname	13	25	636	3	byname
byzant	20	9	681	3	byzant
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	1247	3	catena
choana	11	3	844	3	choana
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	1108	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	611	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	991	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	580	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	2852	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	1036	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	4194	3	__mana
manage	9	38	1890	3	manage
manas	7	62	4042	3	mana_s
manat	7	60	3998	3	mana_t
manats	8	46	2346	3	manats
mandala	10	3	1020	3	mandala
manga	8	50	2619	3	man_ga
mania	7	56	3414	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	2990	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_
mbaqanga	22	4	102	3	mbaqanga
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	5487	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	3939	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	1275	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	1721	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	2368	3	tan_ga
tanka	9	38	1748	3	tan_ka
tantara	7	24	1081	3	tantara
tantra	6	37	1335	3	tantra
tarama	8	4	1272	3	tarama
tartana	7	30	1019	3	tartana
tenant	6	3	2247	3	tenant
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
zanza	13	7	870	3	zan_za
zenanas	16	28	623	3	zenanas

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.140	1276364.3
2	DLD Change Limit	112716	441	5.876	19182.4
3	Display Results	441	441	0.140	3150.0
	(SQL Overall)	178691	441	6.156	29027.1