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

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

367 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
mara	6	74	4457	(None)
maar	6	60	2506	1	maar
mama	8	62	3159	1	mama
mana	6	53	4196	1	mana
mar	5	79	6595	1	mar_
maras	7	54	4329	1	maras
marc	8	70	3463	1	marc
mare	6	47	5933	1	mare
maria	7	50	3288	1	maria
mark	10	51	3806	1	mark
marka	11	46	2079	1	marka
marl	6	63	4162	1	marl
mars	6	62	6187	1	mars
mart	6	68	6598	1	mart
masa	6	50	3472	1	masa
maya	9	58	2459	1	maya
mora	6	66	4127	1	mora
mura	6	56	3330	1	mura
para	6	52	4217	1	para
vara	7	55	3088	1	vara
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
ana	3	95	5983	2	_ana
ar	2	113	7938	2	_ar_
arak	8	69	2957	2	_arak
arb	5	104	4842	2	_arb
arc	5	102	5090	2	_arc
are	3	78	7457	2	_are
area	4	58	4339	2	_area
arf	6	74	5337	2	_arf
aria	4	62	4542	2	_aria
ark	7	70	4496	2	_ark
arm	5	84	4962	2	_arm
ars	3	76	7093	2	_ars
art	3	86	7914	2	_art
aura	4	58	3625	2	aura
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
bar	5	80	7055	2	bar_
barb	8	52	4006	2	barb
barca	9	13	1943	2	barca
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barf	9	58	4441	2	barf
bark	10	62	4215	2	bark
barm	8	67	3960	2	barm
barn	6	64	4464	2	barn
bars	6	65	6409	2	bars
bora	6	61	4163	2	bora
bra	5	63	3946	2	_bra
bura	6	61	3953	2	bura
caca	8	55	2808	2	caca
car	5	91	6556	2	car_
carat	7	50	4879	2	carat
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
casa	6	56	3086	2	casa
dada	6	64	2244	2	dada
darb	7	60	3353	2	darb
dare	5	58	4886	2	dare
dark	9	51	3321	2	dark
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
data	5	60	2665	2	data
dura	5	52	3211	2	dura
ear	3	68	6788	2	ear_
earl	4	58	3814	2	earl
earn	4	67	3755	2	earn
ears	4	63	5659	2	ears
era	3	57	4150	2	_era
eyra	7	62	1755	2	eyra
far	6	77	6260	2	far_
farad	9	57	2067	2	farad
fard	8	56	3906	2	fard
fare	7	63	5446	2	fare
farl	7	63	3855	2	farl
farm	9	59	3453	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
fava	10	68	2026	2	fava
fora	7	59	3739	2	fora
gaga	6	66	2555	2	gaga
gala	5	56	3516	2	gala
gama	7	70	3552	2	gama
gar	4	72	5990	2	gar_
garb	7	53	3267	2	garb
garda	7	3	1676	2	garda
gars	5	57	5074	2	gars
haar	7	73	2349	2	haar
haha	10	78	2106	2	haha
hard	8	54	4350	2	hard
hare	7	62	5573	2	hare
hark	11	52	3739	2	hark
harl	7	57	4000	2	harl
harm	9	56	3779	2	harm
harp	9	61	3429	2	harp
hart	7	68	6577	2	hart
hora	7	61	3656	2	hora
jagra	13	3	817	2	jagra
jar	10	76	4615	2	jar_
jarl	11	58	2813	2	jarl
jars	11	73	3835	2	jars
java	14	73	1664	2	java
jura	11	60	2489	2	jura
kaka	7	65	1868	2	kaka
kana	8	59	2853	2	kana
kapa	10	60	2129	2	kapa
karat	9	68	3759	2	karat
karma	11	34	1500	2	karma
karn	8	61	2941	2	karn
kart	8	67	5080	2	kart
kata	8	56	2602	2	kata
kava	11	58	1970	2	kava
kora	8	64	3155	2	kora
labra	7	54	1546	2	labra
lama	6	66	3529	2	lama
lar	3	79	6753	2	lar_
lard	5	67	4200	2	lard
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
larva	8	3	1248	2	larva
laura	5	41	1620	2	laura
lava	7	67	2542	2	lava
lira	4	69	2868	2	lira
ma	4	100	6066	2	m__a
maars	7	46	2163	2	maars
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
macro	9	47	1817	2	macro
macs	8	67	4251	2	macs
mad	6	89	5871	2	ma_d
madam	10	3	1622	2	madam
made	7	54	4024	2	made
madras	9	43	1643	2	madras
madre	8	57	2017	2	madre
mads	7	68	4537	2	mads
mae	5	76	5911	2	ma_e
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	3766	2	maid
mail	6	55	4345	2	mail
maim	8	58	3149	2	maim
main	6	53	4552	2	main
mair	6	61	3378	2	mair
mairs	7	62	2830	2	mairs
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
man	5	74	6587	2	ma_n
manas	7	62	4043	2	manas
manat	7	60	3999	2	manat
mane	6	50	5203	2	mane
manga	8	50	2621	2	manga
mania	7	56	3415	2	mania
manna	7	55	2254	2	manna
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
manta	7	56	2991	2	manta
mantra	8	41	1609	2	mantra
many	9	57	3186	2	many
map	7	72	5512	2	ma_p
maps	8	61	4105	2	maps
maraca	10	3	1415	2	maraca
maraud	9	3	894	2	maraud
march	12	56	2289	2	march
marcs	9	57	2662	2	marcs
mares	7	64	5763	2	mares
margay	12	3	1059	2	margay
marge	8	53	2833	2	marge
marina	8	46	2341	2	marina
markas	12	47	1700	2	markas
markka	11	41	659	2	markka
marks	11	59	3348	2	marks
marls	7	55	3516	2	marls
marly	10	69	2561	2	marly
marram	10	3	1388	2	marram
marry	10	48	2169	2	marry
marse	7	62	3115	2	marse
marsh	10	53	2085	2	marsh
marts	7	74	4223	2	marts
marvy	13	50	1403	2	marvy
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
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
mbira	9	7	797	2	mbira
mega	7	76	2087	2	mega
megara	9	3	1009	2	megara
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
mesa	6	70	2548	2	mesa
meta	6	59	3241	2	meta
mica	8	64	2825	2	mica
micra	9	62	1497	2	micra
mikra	11	46	1031	2	mikra
mina	6	51	3692	2	mina
mir	5	70	4677	2	mir_
mire	6	67	4823	2	mire
miri	6	67	3037	2	miri
mirk	10	67	2950	2	mirk
mirs	6	69	4057	2	mirs
miry	9	63	2675	2	miry
mirza	16	4	1044	2	mirza
moa	5	72	4918	2	m_oa
moira	7	10	1202	2	moira
mola	6	60	3563	2	mola
mor	5	68	5500	2	mor_
morae	7	58	3119	2	morae
moral	7	55	3343	2	moral
moras	7	64	3878	2	moras
moray	10	54	2379	2	moray
more	6	71	5452	2	more
morn	6	62	3756	2	morn
mors	6	59	5006	2	mors
mort	6	67	5883	2	mort
moxa	13	69	1774	2	moxa
mudra	8	39	1243	2	mudra
mural	7	52	2511	2	mural
muras	7	53	2958	2	muras
mure	6	59	4133	2	mure
murk	10	55	2725	2	murk
murr	6	52	2513	2	murr
murra	7	45	1908	2	murra
myna	9	58	1530	2	myna
nada	5	80	2290	2	nada
naira	5	3	1474	2	naira
nala	4	69	3039	2	nala
nana	4	66	3290	2	nana
napa	6	69	2726	2	napa
narc	6	71	2795	2	narc
nard	5	66	3445	2	nard
nark	8	52	3006	2	nark
nary	7	69	3122	2	nary
oar	3	70	5795	2	oar_
oars	4	68	4603	2	oars
okra	8	64	1357	2	okra
omasa	7	4	948	2	omasa
ora	3	72	5083	2	_ora
orra	4	61	2072	2	orra
paca	8	51	3224	2	paca
papa	8	58	2714	2	papa
par	5	74	6702	2	par_
parae	7	63	3570	2	parae
paras	7	61	4304	2	paras
pard	7	64	4132	2	pard
pare	6	67	6084	2	pare
park	10	52	3749	2	park
parka	11	51	2088	2	parka
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
part	6	59	6746	2	part
raga	5	59	3081	2	raga
raia	4	66	3838	2	raia
raja	11	79	1868	2	raja
rare	4	53	4843	2	rare
raya	7	52	2482	2	raya
sabra	7	53	1785	2	sabra
sacra	7	45	1699	2	sacra
saga	5	53	3117	2	saga
samara	8	3	1385	2	samara
saran	5	37	3030	2	saran
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sark	8	49	3897	2	sark
sera	4	61	4139	2	sera
smarm	9	55	1760	2	smarm
smart	7	58	3409	2	smart
sora	4	57	4691	2	sora
sura	4	57	4029	2	sura
taka	8	76	2359	2	taka
tala	4	59	3805	2	tala
tapa	6	51	2915	2	tapa
tar	3	75	7069	2	tar_
tare	4	59	5762	2	tare
tarn	4	68	4272	2	tarn
taro	4	68	4691	2	taro
tarp	6	69	3642	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
taxa	11	68	2009	2	taxa
tiara	5	3	1591	2	tiara
tora	4	75	4599	2	tora
umbra	9	4	851	2	umbra
var	6	61	4833	2	var_
varas	8	60	2819	2	varas
varia	8	58	2420	2	varia
varna	8	45	1617	2	varna
vars	7	57	4207	2	vars
vary	10	52	2606	2	vary
vasa	7	65	2297	2	vasa
vera	7	68	2884	2	vera
war	6	72	6242	2	war_
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
wark	11	57	3777	2	wark
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
yar	6	72	5383	2	yar_
yard	8	56	3325	2	yard
yare	7	56	3694	2	yare
yarn	7	52	3004	2	yarn
zarf	16	69	2912	2	zarf

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.296	603685.8
2	DLD Change Limit	29872	367	0.970	30795.9
3	Display Results	367	367	0.093	3946.2
	(SQL Overall)	178691	367	1.359	131487.1