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

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

331 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
bananas	9	33	1222	(None)
banana	8	32	1341	1	banana_
bandanas	11	17	857	1	bandanas
mananas	9	34	1473	1	mananas
zananas	16	31	956	1	zananas
anabas	8	3	1408	2	_anabas
annas	5	58	2488	2	_an_nas
asanas	6	5	1411	2	_asanas
balatas	9	3	1183	2	balatas
bandana	10	17	946	2	bandana_
bandannas	12	16	328	2	bandannas
bandas	9	51	2054	2	ban_das
banians	9	3	1203	2	banian_s
banns	7	53	2123	2	ban_n_s
banyans	12	3	791	2	banyan_s
bonanzas	19	4	311	2	bonanzas
bwanas	11	5	744	2	b_wanas
cabanas	11	24	1303	2	cabanas
cannas	8	45	1840	2	can_nas
jacanas	16	3	826	2	jacanas
jnanas	13	20	730	2	_jnanas
kanakas	10	32	721	2	kanakas
lantanas	8	3	826	2	lantanas
manana	8	48	1607	2	manana_
mannas	8	50	1980	2	man_nas
naganas	8	4	798	2	naganas
nanas	5	59	2863	2	__nanas
panadas	10	33	1221	2	panadas
panamas	11	31	1276	2	panamas
zanana	15	38	1036	2	zanana_
zenanas	16	28	623	2	zenanas
abacas	10	44	1472	3	_abacas
abakas	12	39	1174	3	_abakas
abayas	11	40	1170	3	_abayas
agamas	9	74	1345	3	_agamas
alands	7	54	1837	3	_alands
alans	5	56	3617	3	_alan_s
alants	6	77	2202	3	_alants
ananke	10	3	828	3	_ananke
anankes	11	3	876	3	_anankes
anas	4	66	4986	3	___anas
anatase	7	3	894	3	_anatase
angas	6	58	2798	3	_an_gas
anginas	8	3	1095	3	_anginas
animas	8	44	1872	3	_animas
anlas	5	56	2693	3	_an_las
anna	4	55	2901	3	_an_na_
annal	5	65	2076	3	_an_nal
annals	6	64	1592	3	_annals
annonas	7	3	879	3	annonas
anoas	5	72	2649	3	_an_oas
antas	5	54	3203	3	_an_tas
arenas	6	50	2199	3	_arenas
asana	5	3	1548	3	_asana_
azans	14	65	1688	3	_azan_s
baals	7	61	2270	3	ba_a_ls
baas	6	68	4467	3	b__a_as
baases	8	52	1801	3	ba_ases
babas	9	63	2573	3	b__abas
babkas	14	60	1014	3	ba_bkas
bacalao	11	4	661	3	bacalao
bacalaos	12	4	586	3	bacalaos
baccaras	14	4	691	3	baccaras
bacons	10	49	1758	3	bacon_s
badass	9	4	929	3	bada_ss
badlands	12	3	667	3	badlands
bagass	9	3	893	3	baga_ss
bairns	8	67	1087	3	bairn_s
baizas	17	38	1082	3	ba_izas
bakings	14	43	1202	3	bakings
baklavas	17	4	278	3	baklavas
baklawas	17	4	321	3	baklawas
balance	11	5	1026	3	balance
balances	12	7	997	3	balances
balas	7	69	3721	3	b__alas
balases	9	38	1543	3	balases
balata	8	6	1468	3	balata_
balboas	11	37	1007	3	balboas
balsas	8	64	1752	3	ba_lsas
banal	7	59	2599	3	b__anal
banally	12	4	922	3	banally
bancos	10	47	1389	3	ban_cos
banda	8	52	2310	3	ban_da_
bandages	12	3	1063	3	bandages
bandanna	11	17	407	3	bandanna
bandeau	10	3	852	3	bandeau
bandeaus	11	4	650	3	bandeaus
banders	10	43	2456	3	banders
bandies	10	41	2486	3	bandies
bandits	10	38	1479	3	bandits
bandogs	11	3	836	3	bandogs
bandoras	11	3	874	3	bandoras
bands	8	52	3342	3	b__ands
bandsaw	13	3	480	3	bandsaw
bandsaws	14	4	462	3	bandsaws
banes	7	49	4558	3	b__anes
bangers	10	40	2035	3	bangers
bangles	10	36	1741	3	bangles
bangs	8	56	2777	3	b__angs
banian	8	3	1538	3	ban_ian
baning	9	51	2783	3	banin_g
banjax	22	3	476	3	ban_jax
banjaxes	24	4	339	3	banjaxes
banjoes	16	31	731	3	banjoes
banjos	15	37	889	3	ban_jos
bankers	13	39	1909	3	bankers
bankings	15	48	940	3	bankings
bankits	13	34	1015	3	bankits
banks	11	55	2790	3	b__anks
banksias	14	4	589	3	banksias
banned	9	47	2134	3	ban_ned
banner	8	44	2150	3	ban_ner
banners	9	40	1871	3	banners
bannet	8	49	2533	3	ban_net
bannets	9	40	1384	3	bannets
bans	6	65	5514	3	b__an_s
bantam	10	3	1406	3	ban_tam
bantams	11	4	906	3	bantams
bantengs	11	3	459	3	bantengs
banters	9	46	2311	3	banters
banties	9	43	2476	3	banties
banyan	11	3	948	3	ban_yan
banzai	17	3	765	3	ban_zai
banzais	18	3	716	3	banzais
barcas	10	10	1660	3	ba_rcas
barns	7	63	3514	3	ba_rn_s
barongs	10	53	1083	3	barongs
barons	8	50	2538	3	baron_s
barrancas	13	4	509	3	barrancas
barytas	12	37	828	3	barytas
basalts	9	35	896	3	basalts
basinal	9	3	1003	3	basinal
basins	8	57	2276	3	basin_s
batons	8	55	1942	3	baton_s
bayamos	14	3	466	3	bayamos
bayards	13	37	968	3	bayards
bazaar	17	30	640	3	baza_ar
bazaars	18	27	588	3	bazaars
bazars	17	46	1311	3	baza_rs
beanos	8	55	1651	3	b_eanos
beans	7	57	3469	3	b_ean_s
benames	11	28	1460	3	benames
bennes	8	60	1901	3	ben_nes
bennis	8	43	1480	3	ben_nis
bezants	18	7	734	3	bezants
bhangras	14	4	369	3	bhangras
bhangs	12	44	966	3	b_hangs
bisnagas	11	4	284	3	bisnagas
biznagas	20	4	197	3	biznagas
blanks	12	41	1289	3	b_lanks
bogans	9	57	1481	3	bogan_s
bonacis	11	3	1032	3	bonacis
bonanza	18	4	384	3	bonanza
bonitas	9	3	945	3	bonitas
bonnes	8	56	2145	3	bon_nes
boranes	9	37	2040	3	boranes
brands	9	51	1894	3	b_rands
branks	12	48	1738	3	b_ranks
brans	7	54	3743	3	b_ran_s
brants	8	57	2305	3	b_rants
bravas	11	49	1332	3	b_ravas
brazas	17	58	1243	3	b_razas
bunas	7	51	2657	3	b__unas
bunns	7	47	1829	3	bun_n_s
bunyas	11	35	943	3	bun_yas
burans	8	50	1930	3	buran_s
butanes	9	3	1274	3	butanes
bwana	10	3	1024	3	b_wana_
bynames	14	25	624	3	bynames
byzants	21	5	322	3	byzants
cabalas	11	35	1600	3	cabalas
cabana	10	39	1356	3	cabana_
canals	8	44	2167	3	cana_ls
canapes	11	12	1308	3	canapes
canards	10	3	1120	3	canards
canastas	10	3	769	3	canastas
cancans	11	3	1187	3	cancan_s
canchas	14	32	1240	3	canchas
canines	9	37	2403	3	canines
canna	7	59	1933	3	can_na_
canolas	9	3	1399	3	canolas
canons	8	55	2206	3	canon_s
cantalas	10	40	1352	3	cantalas
cantatas	10	34	1009	3	cantatas
cantinas	10	27	1378	3	cantinas
canulas	9	3	1285	3	canulas
canvas	11	38	1333	3	can_vas
canzonas	19	3	538	3	canzonas
carinas	9	36	2241	3	carinas
casabas	11	3	998	3	casabas
casavas	12	3	782	3	casavas
catenas	9	3	1311	3	catenas
damans	9	47	1598	3	daman_s
damianas	11	5	557	3	damianas
donnas	7	55	1132	3	don_nas
faenas	9	44	1276	3	fa_enas
fanegas	11	4	571	3	fanegas
fangas	10	50	1719	3	fan_gas
fanons	9	61	1521	3	fanon_s
farinas	10	32	1524	3	farinas
faunas	9	40	1363	3	fa_unas
galangas	10	4	617	3	galangas
galenas	8	33	1034	3	galenas
ganjas	14	14	911	3	gan_jas
gazanias	18	4	573	3	gazanias
goannas	8	3	622	3	goan_nas
guaranas	9	9	594	3	guaranas
halalas	10	42	1408	3	halalas
hamadas	13	3	967	3	hamadas
hansas	9	46	1604	3	han_sas
harianas	11	3	916	3	harianas
hawalas	13	34	835	3	hawalas
hazans	18	34	1165	3	hazan_s
hennas	9	42	1180	3	hen_nas
honans	9	48	1450	3	honan_s
iguanas	8	3	538	3	iguanas
inanes	6	25	1980	3	_inanes
jacana	15	3	793	3	jacana_
japans	15	3	982	3	japan_s
jarinas	14	37	1219	3	jarinas
jawans	16	5	784	3	jawan_s
jnana	12	15	904	3	_jnana_
kabakas	12	36	740	3	kabakas
kabalas	13	39	1106	3	kabalas
kabayas	16	31	680	3	kabayas
kahunas	14	7	395	3	kahunas
kamalas	13	33	912	3	kamalas
kanaka	9	35	752	3	kanaka_
kanas	9	53	2691	3	__kanas
kanbans	13	3	772	3	kanban_s
kinaras	11	5	912	3	kinaras
lacunas	9	13	817	3	lacunas
lagans	7	57	1778	3	lagan_s
lagunas	8	15	682	3	lagunas
laminas	9	36	1587	3	laminas
lanais	6	3	1679	3	lana_is
lantana	7	3	960	3	lantana_
lasagnas	9	4	367	3	lasagnas
latinas	7	44	1646	3	latinas
lauans	6	51	1353	3	lauan_s
lianas	6	37	1338	3	_lianas
malangas	11	3	686	3	malangas
manages	10	34	1896	3	manages
manas	7	62	4043	3	__manas
manats	8	46	2346	3	mana_ts
mandalas	11	3	944	3	mandalas
mangas	9	41	2292	3	man_gas
manias	8	40	2903	3	man_ias
manilas	9	39	1587	3	manilas
manna	7	55	2254	3	man_na_
mannan	8	54	1362	3	man_nan
mannans	9	36	1152	3	mannans
mantas	8	57	2536	3	man_tas
mantras	9	38	1586	3	mantras
mantuas	9	34	1099	3	mantuas
maracas	11	3	1377	3	maracas
marantas	10	3	1002	3	marantas
marinas	9	35	1939	3	marinas
masalas	9	3	1205	3	masalas
mbaqangas	23	5	110	3	mbaqangas
naans	5	58	1525	3	na_an_s
nadas	6	63	2081	3	__nadas
nagana	7	4	894	3	nagana_
nalas	5	55	2836	3	__nalas
nana	4	66	3290	3	__nana_
nandinas	9	3	658	3	nandinas
nans	4	61	3940	3	__nan_s
napas	7	59	2435	3	__napas
nonas	5	51	2665	3	__nonas
paeans	8	51	1826	3	paean_s
pagans	9	57	1792	3	pagan_s
paisanas	10	28	887	3	paisanas
pajamas	18	27	815	3	pajamas
palapas	11	3	1149	3	palapas
panaceas	12	3	676	3	panaceas
panada	9	41	1305	3	panada_
panama	10	42	1335	3	panama_
pandanus	11	3	643	3	pandanus
pandas	9	55	2196	3	pan_das
pangas	9	99	2110	3	pan_gas
pannes	8	55	2285	3	pan_nes
papayas	14	3	727	3	papayas
parangs	10	43	1437	3	parangs
patacas	11	3	1100	3	patacas
patinas	9	63	1852	3	patinas
pavanes	12	36	1265	3	pavanes
pavans	11	57	1559	3	pavan_s
penangs	10	26	837	3	penangs
pinangs	10	26	779	3	pinangs
pinatas	9	37	1150	3	pinatas
pinnas	8	53	1551	3	pin_nas
piranas	9	9	1260	3	piranas
puranas	9	7	1264	3	puranas
qabalas	18	28	950	3	qabalas
qanats	15	41	1281	3	qana_ts
ramadas	10	3	930	3	ramadas
ramonas	9	3	1109	3	ramonas
randans	8	3	1321	3	randan_s
ranulas	7	3	1177	3	ranulas
ratans	6	38	1937	3	ratan_s
ruanas	6	3	1126	3	_ruanas
saganash	12	4	307	3	saganash
salinas	7	31	1609	3	salinas
samaras	9	3	1291	3	samaras
sangas	7	52	2265	3	san_gas
sarans	6	42	2443	3	saran_s
sardanas	9	3	782	3	sardanas
satangs	8	47	971	3	satangs
sataras	7	3	1506	3	sataras
saunas	6	39	1543	3	sa_unas
savannas	11	4	373	3	savannas
savants	10	3	865	3	savants
sennas	6	42	1423	3	sen_nas
sonants	7	5	1123	3	sonants
sonatas	7	5	1029	3	sonatas
sunnas	6	39	1456	3	sun_nas
tankas	10	46	1376	3	tan_kas
tantaras	8	26	954	3	tantaras
tantras	7	31	1209	3	tantras
taramas	9	6	1270	3	taramas
tarantas	8	3	919	3	tarantas
tartanas	8	25	889	3	tartanas
tenants	7	3	1101	3	tenants
vaginas	11	29	881	3	vaginas
vandas	10	39	1599	3	van_das
varnas	9	42	1282	3	va_rnas
wakandas	16	4	341	3	wakandas
wangans	11	4	950	3	wangan_s
yantras	10	25	900	3	yantras
zanzas	14	8	705	3	zan_zas
zenana	15	29	798	3	zenana_

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	134027	0.423	422437.4
2	DLD Change Limit	134027	331	6.373	21030.4
3	Display Results	331	331	0.110	3009.1
	(SQL Overall)	178691	331	6.906	25874.7