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

Here are the results of your fuzzy-string dictionary search for “mana” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

342 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
mana	6	53	4196	(None)
ana	3	95	5983	1	_ana
kana	8	59	2854	1	kana
mama	8	62	3159	1	mama
man	5	74	6587	1	man_
manas	7	62	4043	1	manas
manat	7	60	3999	1	manat
mane	6	50	5203	1	mane
manga	8	50	2621	1	manga
mania	7	56	3415	1	mania
manna	7	55	2254	1	manna
mano	6	65	3681	1	mano
mans	6	63	5455	1	mans
manta	7	56	2991	1	manta
many	9	57	3186	1	many
mara	6	74	4457	1	mara
masa	6	50	3472	1	masa
maya	9	58	2459	1	maya
mina	6	51	3693	1	mina
myna	9	58	1530	1	myna
nana	4	66	3290	1	nana
aa	2	191	7995	2	_a_a
aba	5	128	5095	2	_aba
aga	4	104	4723	2	_aga
aha	6	112	4664	2	_aha
ala	3	124	6360	2	_ala
ama	5	108	5330	2	_ama
amarna	8	3	979	2	amarna
amia	6	68	3690	2	amia
amnia	7	59	1864	2	amnia
an	2	118	7908	2	_an_
anal	4	80	3752	2	_anal
anas	4	66	4986	2	_anas
and	4	72	4418	2	_and
ane	3	78	6695	2	_ane
anga	5	68	3136	2	_anga
ani	3	77	5118	2	_ani
anna	4	55	2901	2	anna
anoa	4	56	3447	2	_anoa
ansa	4	59	2777	2	_ansa
ant	3	72	7079	2	_ant
anta	4	68	3958	2	_anta
any	6	84	4049	2	_any
asana	5	3	1548	2	asana
ava	6	101	3932	2	_ava
awa	6	119	3967	2	_awa
baa	5	106	5042	2	ba_a
baba	8	88	2835	2	baba
ban	5	83	6684	2	ban_
banal	7	59	2599	2	banal
band	7	67	4092	2	band
banda	8	52	2311	2	banda
bane	6	52	5043	2	bane
bang	7	48	3701	2	bang
bani	6	53	3496	2	bani
bank	10	58	3575	2	bank
bans	6	65	5514	2	bans
buna	6	47	3072	2	buna
bwana	10	3	1024	2	bwana
caca	8	55	2808	2	caca
can	5	77	6014	2	can_
canal	7	54	2804	2	canal
cane	6	66	5312	2	cane
canna	7	59	1933	2	canna
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
casa	6	56	3086	2	casa
dada	6	64	2245	2	dada
dan	4	68	5967	2	dan_
dang	6	51	3155	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
data	5	60	2665	2	data
dona	5	55	2963	2	dona
etna	4	64	1526	2	etna
faena	8	50	1420	2	faena
fan	6	71	5886	2	fan_
fane	7	53	4357	2	fane
fang	8	54	3256	2	fang
fanga	9	61	1963	2	fanga
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fauna	8	48	1651	2	fauna
fava	10	68	2026	2	fava
gaga	6	66	2555	2	gaga
gala	5	56	3516	2	gala
gama	7	70	3552	2	gama
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3198	2	gang
ganja	13	14	1000	2	ganja
grana	6	57	2209	2	grana
haha	10	78	2106	2	haha
hand	8	68	3371	2	hand
hang	8	55	3556	2	hang
hank	11	51	3414	2	hank
hansa	8	54	1678	2	hansa
hant	7	54	6159	2	hant
jane	11	50	3148	2	jane
java	14	73	1664	2	java
jnana	12	15	904	2	jnana
kaka	7	65	1869	2	kaka
kanas	9	53	2691	2	kanas
kane	8	51	3398	2	kane
kapa	10	60	2130	2	kapa
kata	8	56	2603	2	kata
kava	11	58	1971	2	kava
kina	8	56	3201	2	kina
kuna	8	51	2071	2	kuna
lama	6	66	3529	2	lama
lanai	5	3	1957	2	lanai
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lang	5	66	3739	2	lang
lank	8	47	3445	2	lank
lava	7	67	2542	2	lava
liana	5	39	1589	2	liana
luna	4	62	2985	2	luna
ma	4	100	6066	2	m__a
maar	6	60	2506	2	maar
mabe	8	57	3336	2	mabe
mac	7	80	5393	2	ma_c
macaw	12	3	1176	2	macaw
mace	8	73	4579	2	mace
mach	11	61	3448	2	mach
mack	12	57	3365	2	mack
macs	8	67	4251	2	macs
mad	6	89	5872	2	ma_d
madam	10	3	1622	2	madam
made	7	54	4025	2	made
mads	7	68	4538	2	mads
mae	5	76	5911	2	ma_e
maenad	9	3	941	2	maenad
maes	6	69	4840	2	maes
mafia	10	44	1803	2	mafia
mag	6	79	5648	2	ma_g
mage	7	57	3913	2	mage
magi	7	63	2953	2	magi
magma	10	45	1357	2	magma
mags	7	54	4453	2	mags
maid	7	55	3767	2	maid
mail	6	55	4345	2	mail
maim	8	58	3149	2	maim
main	6	53	4552	2	main
mains	7	56	3511	2	mains
mair	6	61	3378	2	mair
makar	11	56	1497	2	makar
make	10	55	3789	2	make
mako	10	56	2236	2	mako
malar	7	64	2444	2	malar
male	6	60	5230	2	male
mall	6	46	3937	2	mall
malm	8	51	2998	2	malm
malt	6	62	5481	2	malt
mamas	9	59	3077	2	mamas
mamba	11	63	1752	2	mamba
mamma	8	63	1791	2	mamma
manage	9	38	1890	2	manage
manana	8	48	1607	2	manana
manats	8	46	2346	2	manats
maned	8	66	3410	2	maned
manes	7	66	4896	2	manes
mangas	9	41	2293	2	mangas
mange	8	49	3020	2	mange
mango	8	57	2433	2	mango
mangy	11	50	2125	2	mangy
maniac	10	39	1797	2	maniac
manias	8	40	2903	2	manias
manic	9	46	2944	2	manic
manila	8	45	1830	2	manila
manly	10	50	2295	2	manly
mannan	8	54	1362	2	mannan
mannas	8	50	1980	2	mannas
manor	7	80	2393	2	manor
manos	7	49	3362	2	manos
manse	7	55	2823	2	manse
mantas	8	57	2536	2	mantas
mantra	8	41	1609	2	mantra
mantua	8	44	1202	2	mantua
manual	8	3	1346	2	manual
manus	7	59	2493	2	manus
map	7	72	5512	2	ma_p
maps	8	61	4105	2	maps
mar	5	79	6595	2	ma_r
maras	7	54	4329	2	maras
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
maria	7	50	3288	2	maria
marina	8	46	2341	2	marina
mark	10	51	3806	2	mark
marka	11	46	2079	2	marka
marl	6	63	4162	2	marl
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
mas	5	81	7582	2	ma_s
masas	7	56	3041	2	masas
mash	9	60	3940	2	mash
mask	10	52	2736	2	mask
mass	6	60	4494	2	mass
massa	7	55	1892	2	massa
mast	6	59	5996	2	mast
mat	5	80	8394	2	ma_t
mate	6	51	5422	2	mate
math	9	54	3745	2	math
mats	6	54	6029	2	mats
matt	6	57	5266	2	matt
matza	16	3	1181	2	matza
maud	7	53	2540	2	maud
maul	6	48	3072	2	maul
maun	6	57	2721	2	maun
maund	8	55	1545	2	maund
maut	6	54	4845	2	maut
maw	8	70	5010	2	ma_w
mawn	9	44	2414	2	mawn
maws	9	64	3714	2	maws
max	12	90	4545	2	ma_x
maxi	13	70	2356	2	maxi
may	8	87	5763	2	ma_y
mayan	10	56	1690	2	mayan
mayas	10	59	2438	2	mayas
mayo	9	65	2430	2	mayo
mays	9	69	4003	2	mays
maze	15	54	3498	2	maze
mazy	18	64	1970	2	mazy
mean	6	55	3809	2	mean_
means	7	58	3123	2	means
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
mega	7	76	2087	2	mega
men	5	92	5285	2	men_
menad	8	59	1898	2	menad
mend	7	53	3403	2	mend
meno	6	60	3136	2	meno
mensa	7	53	1867	2	mensa
menta	7	44	2442	2	menta
menu	6	51	3023	2	menu
mesa	6	70	2548	2	mesa
meta	6	59	3241	2	meta
mica	8	64	2826	2	mica
minae	7	56	2772	2	minae
minas	7	54	3411	2	minas
mind	7	54	3439	2	mind
mine	6	72	5618	2	mine
mini	6	56	3457	2	mini
mink	10	66	3654	2	mink
mint	6	67	5807	2	mint
minx	13	77	2336	2	minx
moa	5	72	4918	2	m_oa
moan	6	58	3202	2	moan_
moans	7	46	2437	2	moans
mola	6	60	3563	2	mola
mon	5	75	6158	2	mon_
monad	8	55	1947	2	monad
monas	7	47	3215	2	monas
monk	10	59	2852	2	monk
mono	6	60	3672	2	mono
mons	6	81	5226	2	mons
mony	9	68	3001	2	mony
mora	6	66	4127	2	mora
moxa	13	69	1774	2	moxa
mun	5	61	4386	2	mun_
muni	6	58	2441	2	muni
muns	6	55	3592	2	muns
mura	6	56	3330	2	mura
mynah	13	56	956	2	mynah
mynas	10	58	1523	2	mynas
na	2	86	5248	2	__na
naan	4	76	2193	2	naan
nada	5	80	2291	2	nada
nala	4	69	3039	2	nala
nan	3	78	5488	2	nan_
nanas	5	59	2863	2	nanas
nans	4	61	3940	2	nans
napa	6	69	2726	2	napa
nona	4	69	2906	2	nona
omasa	7	4	948	2	omasa
paca	8	51	3224	2	paca
pan	5	84	6645	2	pan_
panda	8	50	2261	2	panda
pane	6	49	5029	2	pane
pang	7	53	3630	2	pang
panga	8	53	2354	2	panga
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
papa	8	58	2714	2	papa
para	6	52	4217	2	para
pina	6	58	4264	2	pina
puna	6	53	3165	2	puna
qanat	14	44	2684	2	qanat
raga	5	59	3081	2	raga
raia	4	66	3838	2	raia
raja	11	79	1868	2	raja
ran	3	82	6662	2	ran_
rand	5	58	3957	2	rand
rang	5	69	3917	2	rang
rani	4	66	4011	2	rani
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
raya	7	52	2482	2	raya
ruana	5	3	1242	2	ruana
saga	5	53	3117	2	saga
sand	5	53	3847	2	sand
sane	4	59	5434	2	sane
sang	5	54	4124	2	sang
sanga	6	60	2380	2	sanga
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
sauna	5	41	1755	2	sauna
taka	8	76	2359	2	taka
tala	4	59	3805	2	tala
tan	3	71	6758	2	tan_
tang	5	61	3869	2	tang
tanga	6	49	2371	2	tanga
tank	8	51	3403	2	tank
tanka	9	38	1749	2	tanka
tans	4	61	5483	2	tans
tapa	6	51	2915	2	tapa
taxa	11	68	2010	2	taxa
tuna	4	51	2784	2	tuna
ulna	4	63	1733	2	ulna
van	6	62	4633	2	van_
vanda	9	45	1592	2	vanda
vane	7	55	3469	2	vane
vang	8	49	2605	2	vang
vans	7	62	3674	2	vans
vara	7	55	3088	2	vara
varna	8	45	1617	2	varna
vasa	7	65	2297	2	vasa
vena	7	61	2629	2	vena
vina	7	63	3181	2	vina
wan	6	67	6194	2	wan_
wand	8	58	3388	2	wand
wane	7	63	4472	2	wane
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
yang	8	56	2608	2	yang
yank	11	54	2367	2	yank
zany	16	73	1699	2	zany
zanza	13	7	870	2	zanza
zona	13	63	2196	2	zona

Search took 2 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	29872	0.280	638182.1
2	DLD Change Limit	29872	342	0.783	38150.7
3	Display Results	342	342	0.076	4500.0
	(SQL Overall)	178691	342	1.139	156884.1