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

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

346 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
maras	7	54	4329	(None)
maars	7	46	2163	1	maars
madras	9	43	1643	1	madras
mamas	9	59	3077	1	mamas
manas	7	62	4043	1	manas
mara	6	74	4457	1	mara_
marcs	9	57	2662	1	marcs
mares	7	64	5763	1	mares
markas	12	47	1700	1	markas
marks	11	59	3348	1	marks
marls	7	55	3516	1	marls
mars	6	62	6187	1	mar_s
marts	7	74	4223	1	marts
masas	7	56	3041	1	masas
mayas	10	59	2438	1	mayas
moras	7	64	3878	1	moras
muras	7	53	2958	1	muras
paras	7	61	4304	1	paras
varas	8	60	2819	1	varas
aas	3	109	7539	2	_a_as
abas	6	86	4208	2	_abas
agas	5	59	3884	2	_agas
alas	4	63	5812	2	_alas
amas	6	77	4629	2	_amas
amias	7	58	3147	2	amias
anas	4	66	4986	2	_anas
arak	8	69	2957	2	_arak
araks	9	48	2088	2	_araks
arbs	6	68	3473	2	_arbs
arcs	6	78	3478	2	_arcs
areas	5	59	3577	2	_areas
ares	4	58	7102	2	_ares
arfs	7	60	2996	2	_arfs
arias	5	54	3802	2	_arias
arks	8	59	3687	2	_arks
arms	6	61	3749	2	_arms
arras	5	56	2613	2	arras
ars	3	76	7093	2	_ar_s
arts	4	96	5026	2	_arts
auras	5	59	3256	2	auras
baas	6	68	4467	2	ba_as
babas	9	63	2573	2	babas
balas	7	69	3721	2	balas
barbs	9	59	2819	2	barbs
barcas	10	10	1660	2	barcas
bards	8	71	3964	2	bards
bares	7	54	5713	2	bares
barfs	10	48	2600	2	barfs
barks	11	57	3581	2	barks
barms	9	61	2846	2	barms
barns	7	63	3514	2	barns
bars	6	65	6409	2	bar_s
boras	7	59	3830	2	boras
bras	6	57	4645	2	_bras
buras	7	47	3630	2	buras
cacas	9	56	2798	2	cacas
camas	9	63	3352	2	camas
carat	7	50	4879	2	carat
carats	8	59	2902	2	carats
carbs	9	60	3146	2	carbs
cards	8	51	3793	2	cards
cares	7	73	6918	2	cares
carks	11	55	3421	2	carks
carls	7	70	3742	2	carls
carns	7	59	3756	2	carns
carps	9	69	3225	2	carps
carrs	7	57	3085	2	carrs
cars	6	73	6476	2	car_s
carts	7	89	4629	2	carts
casas	7	53	2784	2	casas
charas	11	42	2361	2	charas
dadas	7	58	1986	2	dadas
darbs	8	53	2326	2	darbs
dares	6	61	4670	2	dares
darks	10	67	2787	2	darks
darns	6	69	2789	2	darns
darts	6	76	3573	2	darts
duras	6	57	2773	2	duras
earls	5	61	2751	2	earls
earns	5	59	2756	2	earns
ears	4	63	5659	2	ear_s
eras	4	54	4150	2	_eras
eyras	8	47	1592	2	eyras
farad	9	57	2067	2	farad
farads	10	47	1327	2	farads
fards	9	66	2984	2	fards
fares	8	58	5287	2	fares
farls	8	57	3111	2	farls
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
favas	11	56	1859	2	favas
galas	6	57	3164	2	galas
gamas	8	54	3136	2	gamas
garbs	8	63	2141	2	garbs
gars	5	57	5074	2	gar_s
haars	8	56	2047	2	haars
hahas	11	71	1844	2	hahas
harass	9	3	1394	2	harass
hards	9	64	3565	2	hards
hares	8	62	5554	2	hares
harks	12	63	3343	2	harks
harls	8	56	3450	2	harls
harms	10	68	2901	2	harms
harps	10	59	2687	2	harps
harts	8	84	4159	2	harts
horas	8	63	3310	2	horas
jagras	14	3	846	2	jagras
jarls	12	61	2096	2	jarls
jars	11	73	3835	2	jar_s
javas	15	59	1542	2	javas
kaas	8	65	3184	2	ka_as
kakas	8	51	1734	2	kakas
kanas	9	53	2691	2	kanas
kapas	11	60	2173	2	kapas
karat	9	68	3759	2	karat
karats	10	64	2049	2	karats
karmas	12	30	1373	2	karmas
karns	9	66	2414	2	karns
karts	9	76	3011	2	karts
katas	9	59	2209	2	katas
kavas	12	59	1995	2	kavas
koras	9	59	2711	2	koras
lamas	7	55	3279	2	lamas
lards	6	53	3186	2	lards
lares	5	48	5263	2	lares
laris	5	47	3746	2	laris
larks	9	52	2781	2	larks
lars	4	69	5657	2	lar_s
larvas	9	3	1023	2	larvas
lauras	6	34	1433	2	lauras
lavas	8	54	2222	2	lavas
liras	5	60	2198	2	liras
maar	6	60	2506	2	ma_ar
mabes	9	63	3153	2	mabes
macaw	12	3	1176	2	macaw
macaws	13	3	702	2	macaws
maces	9	71	3996	2	maces
machs	12	57	2256	2	machs
macks	13	51	2760	2	macks
macros	10	40	1701	2	macros
macs	8	67	4251	2	ma_cs
madam	10	3	1622	2	madam
madams	11	3	1094	2	madams
madrasa	10	38	788	2	madrasa
madres	9	37	1818	2	madres
mads	7	68	4537	2	ma_ds
maes	6	69	4840	2	ma_es
mafias	11	39	1357	2	mafias
mages	8	50	3602	2	mages
magmas	11	55	1250	2	magmas
mags	7	54	4453	2	ma_gs
magus	8	53	1875	2	magus
maids	8	63	2714	2	maids
mails	7	60	3778	2	mails
maims	9	63	2179	2	maims
mains	7	56	3511	2	mains
mairs	7	62	2830	2	mairs
makar	11	56	1497	2	makar
makars	12	46	1263	2	makars
makes	11	53	3685	2	makes
makos	11	65	1836	2	makos
malar	7	64	2444	2	malar
malars	8	50	2068	2	malars
males	7	50	4979	2	males
malls	7	62	3343	2	malls
malms	9	50	2155	2	malms
malts	7	63	3175	2	malts
mama	8	62	3159	2	mama_
mambas	12	57	1624	2	mambas
mammas	9	46	1640	2	mammas
mana	6	53	4196	2	mana_
manat	7	60	3999	2	manat
manats	8	46	2346	2	manats
manes	7	66	4896	2	manes
mangas	9	41	2293	2	mangas
manias	8	40	2903	2	manias
mannas	8	50	1980	2	mannas
manos	7	49	3362	2	manos
mans	6	63	5455	2	ma_ns
mantas	8	57	2536	2	mantas
mantras	9	38	1586	2	mantras
manus	7	59	2493	2	manus
maps	8	61	4105	2	ma_ps
mar	5	79	6595	2	mar__
maraca	10	3	1415	2	maraca
maracas	11	3	1377	2	maracas
marasca	11	3	682	2	marasca
maraud	9	3	894	2	maraud
marauds	10	3	755	2	marauds
marc	8	70	3463	2	mar_c
march	12	56	2289	2	march
mare	6	47	5933	2	mar_e
margay	12	3	1059	2	margay
margays	13	3	749	2	margays
marge	8	53	2833	2	marge
marges	9	45	2571	2	marges
maria	7	50	3288	2	maria
marinas	9	35	1939	2	marinas
marish	11	43	1905	2	marish
mark	10	51	3806	2	mar_k
marka	11	46	2079	2	marka
markkas	12	35	608	2	markkas
marl	6	63	4162	2	mar_l
marly	10	69	2561	2	marly
marram	10	3	1388	2	marram
marrams	11	3	1012	2	marrams
marry	10	48	2169	2	marry
marse	7	62	3115	2	marse
marses	8	48	2711	2	marses
marsh	10	53	2085	2	marsh
mart	6	68	6598	2	mar_t
marvy	13	50	1403	2	marvy
mas	5	81	7582	2	m__as
masa	6	50	3472	2	masa_
masks	11	53	2053	2	masks
mass	6	60	4494	2	ma_ss
massa	7	55	1892	2	massa
massas	8	51	1646	2	massas
masts	7	70	3576	2	masts
mates	7	52	5136	2	mates
maths	10	56	2402	2	maths
matrass	9	3	940	2	matrass
matres	8	45	2223	2	matres
mats	6	54	6029	2	ma_ts
matts	7	68	2918	2	matts
matzas	17	4	970	2	matzas
mauds	8	55	1927	2	mauds
mauls	7	65	2495	2	mauls
mauts	7	59	2719	2	mauts
mavis	10	56	2272	2	mavis
maws	9	64	3714	2	ma_ws
maxes	14	56	2953	2	maxes
maxis	14	57	2156	2	maxis
maya	9	58	2459	2	maya_
mayan	10	56	1690	2	mayan
mayos	10	55	2193	2	mayos
mays	9	69	4003	2	ma_ys
mazes	16	56	3217	2	mazes
mbiras	10	7	715	2	mbiras
mercs	9	60	2045	2	mercs
meres	7	51	4357	2	meres
merks	11	47	2240	2	merks
merls	7	74	2390	2	merls
mesas	7	68	2320	2	mesas
micas	9	68	2305	2	micas
minas	7	54	3411	2	minas
mires	7	56	4088	2	mires
mirks	11	51	2214	2	mirks
mirs	6	69	4057	2	mir_s
mirzas	17	3	818	2	mirzas
moas	6	55	4534	2	m_oas
molas	7	51	3209	2	molas
monas	7	47	3215	2	monas
mora	6	66	4127	2	mora_
morae	7	58	3119	2	morae
moral	7	55	3343	2	moral
morals	8	53	2464	2	morals
morass	8	46	1450	2	morass
moray	10	54	2379	2	moray
morays	11	46	1388	2	morays
mores	7	62	4964	2	mores
morns	7	55	2744	2	morns
mors	6	59	5006	2	mor_s
morts	7	55	3356	2	morts
moxas	14	50	1440	2	moxas
mudras	9	42	1226	2	mudras
mura	6	56	3330	2	mura_
mural	7	52	2511	2	mural
murals	8	40	1676	2	murals
mures	7	59	3722	2	mures
murks	11	48	2173	2	murks
murras	8	49	1601	2	murras
murrs	7	55	2130	2	murrs
mynas	10	58	1523	2	mynas
nadas	6	63	2081	2	nadas
nairas	6	3	1278	2	nairas
nalas	5	55	2836	2	nalas
nanas	5	59	2863	2	nanas
napas	7	59	2435	2	napas
narcs	7	61	2202	2	narcs
nards	6	59	2846	2	nards
nares	5	55	4415	2	nares
naris	5	57	3529	2	naris
narks	9	60	2603	2	narks
oars	4	68	4603	2	oar_s
okras	9	44	1097	2	okras
pacas	9	60	2940	2	pacas
papas	9	49	2749	2	papas
para	6	52	4217	2	para_
parae	7	63	3570	2	parae
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
paris	7	51	4594	2	paris
parkas	12	50	1802	2	parkas
parks	11	61	3446	2	parks
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	par_s
parts	7	77	4337	2	parts
ragas	6	53	2606	2	ragas
raias	5	46	3112	2	raias
rajas	12	73	1772	2	rajas
rares	5	52	4744	2	rares
ras	3	75	7539	2	__ras
rayas	8	59	2205	2	rayas
sabras	8	51	1636	2	sabras
sagas	6	60	2588	2	sagas
samaras	9	3	1291	2	samaras
saran	5	37	3030	2	saran
sarans	6	42	2443	2	sarans
sards	6	47	3618	2	sards
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
smarms	10	57	1253	2	smarms
smarts	8	62	1800	2	smarts
soras	5	50	4101	2	soras
suras	5	53	3633	2	suras
takas	9	55	2068	2	takas
talas	5	59	3589	2	talas
tapas	7	46	2771	2	tapas
tares	5	74	5656	2	tares
tarns	5	64	3395	2	tarns
taros	5	56	4082	2	taros
tarps	7	65	2712	2	tarps
tars	4	67	6395	2	tar_s
tarts	5	72	4202	2	tarts
tiaras	6	3	1455	2	tiaras
toras	5	55	4037	2	toras
umbras	10	3	864	2	umbras
vara	7	55	3088	2	vara_
varias	9	50	1990	2	varias
varnas	9	42	1282	2	varnas
vars	7	57	4207	2	var_s
varus	8	59	2118	2	varus
wards	9	77	3440	2	wards
wares	8	82	5058	2	wares
warks	12	79	3240	2	warks
warms	10	77	2685	2	warms
warns	8	72	3100	2	warns
warps	10	71	2642	2	warps
wars	7	86	5980	2	war_s
warts	8	148	4040	2	warts
yards	9	53	2461	2	yards
yarns	8	56	2179	2	yarns
zarfs	17	47	1362	2	zarfs

Search took 3 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	53800	0.516	346300.4
2	DLD Change Limit	53800	346	1.656	32487.9
3	Display Results	346	346	0.093	3720.4
	(SQL Overall)	178691	346	2.265	78892.3