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

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

415 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
maraca	10	3	1415	(None)
maracas	11	3	1377	1	maracas
marasca	11	3	682	1	marasca
abaca	9	51	1804	2	_abaca
areca	7	56	1863	2	_areca
barca	9	13	1943	2	bar_ca
caracal	11	3	1251	2	caracal
carack	14	21	1317	2	carack
macaco	12	4	785	2	macaco
madrasa	10	38	788	2	madrasa
malacca	13	4	495	2	malacca
manana	8	48	1607	2	manana
mara	6	74	4456	2	mar__a
maranta	9	3	1169	2	maranta
maras	7	54	4328	2	mara_s
marascas	12	4	738	2	marascas
maraud	9	3	894	2	maraud
marc	8	70	3462	2	mar_c_
march	12	56	2289	2	mar_ch
marcs	9	57	2662	2	mar_cs
maria	7	50	3288	2	mar_ia
marina	8	46	2341	2	marina
marka	11	46	2079	2	mar_ka
markka	11	41	659	2	markka
marsala	9	3	958	2	marsala
masala	8	3	1181	2	masala
myrica	13	3	682	2	myrica
pataca	10	3	1119	2	pataca
tarama	8	4	1272	2	tarama
abacas	10	44	1472	3	_abacas
abaci	9	47	1884	3	_abaci
aback	13	48	1617	3	_aback
abaka	11	43	1382	3	_abaka
abaya	10	44	1317	3	_abaya
acacia	10	3	1135	3	_acacia
agama	8	58	1557	3	_agama
alack	11	48	2006	3	_alack
alpaca	10	4	738	3	alpaca
amarna	8	3	979	3	amar_na
amrita	8	4	1112	3	amrita
amtrac	10	10	912	3	amtrac_
amtrack	15	10	739	3	amtrack
amtracs	11	9	888	3	amtracs
apace	9	47	1838	3	_apace
arabica	11	4	728	3	_arabica
arak	8	69	2957	3	_ara_k
araks	9	48	2088	3	_araks
arame	7	50	2662	3	_arame
arc	5	102	5090	3	_ar_c_
arcana	8	9	1258	3	_arcana
arch	9	86	2844	3	_ar_ch
arco	6	83	3154	3	_ar_co
arcs	6	78	3478	3	_ar_cs
area	4	58	4339	3	_ar_ea
arecas	8	48	1744	3	_arecas
arena	5	53	2381	3	_arena
arepa	7	56	1556	3	_arepa
argala	7	47	1266	3	_argala
aria	4	62	4542	3	_ar_ia
armada	9	3	878	3	_armada
arnica	8	3	1044	3	_arnica
aroma	7	12	2014	3	_aroma
arrack	12	11	1025	3	arrack
asana	5	3	1548	3	_asana
asrama	8	3	919	3	asrama
bacca	11	10	1218	3	ba_cca
balata	8	6	1467	3	balata
banana	8	32	1341	3	banana
barcas	10	10	1660	3	barcas
baric	9	61	2569	3	baric_
barrack	15	3	825	3	barrack
barranca	12	4	558	3	barranca
baryta	11	43	1029	3	baryta
brace	9	56	2927	3	_brace
brach	12	61	2330	3	_brach
bract	9	63	3272	3	_bract
brava	10	64	1479	3	_brava
braza	16	52	1425	3	_braza
cabala	10	35	1691	3	cabala
cabana	10	39	1356	3	cabana
caca	8	55	2808	3	__caca
caeca	9	39	1513	3	ca_eca
carabao	11	3	967	3	carabao
caracals	12	3	1074	3	caracals
caracara	12	4	724	3	caracara
caracks	15	22	1156	3	caracks
caracol	11	3	1042	3	caracol
caracul	11	3	882	3	caracul
carafe	11	54	1616	3	carafe
caramba	13	3	689	3	caramba
carapax	18	3	579	3	carapax
carat	7	50	4879	3	cara_t
carate	8	47	3400	3	carate
carats	8	59	2902	3	carats
caravan	12	3	922	3	caravan
caraway	15	3	813	3	caraway
cardia	9	9	1637	3	cardia
carina	8	43	2532	3	carina
carioca	11	3	968	3	carioca
carjack	22	4	615	3	carjack
caroach	14	8	886	3	caroach
caroch	13	9	1176	3	caroch
carrack	15	4	875	3	carrack
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
circa	9	3	1140	3	cir_ca
cloaca	10	3	726	3	cloaca
crack	13	41	2053	3	_crack
curacao	11	4	629	3	curacao
curacoa	11	4	622	3	curacoa
curacy	13	3	959	3	curacy
curara	8	37	1220	3	curara
daric	8	56	2311	3	daric_
darics	9	43	1411	3	darics
drama	8	51	1741	3	_drama
earache	12	3	932	3	earache
embrace	13	8	889	3	embrace
erica	7	3	1654	3	_erica
errata	6	3	901	3	errata
farad	9	57	2067	3	fara_d
faraday	14	4	563	3	faraday
farads	10	47	1327	3	farads
faraway	16	4	541	3	faraway
farce	10	49	2532	3	far_ce
farci	10	59	1931	3	far_ci
farcy	13	52	1709	3	far_cy
farina	9	46	1823	3	farina
fracas	11	3	1199	3	_fracas
garage	8	3	1451	3	garage
garda	7	3	1676	3	gar_da
grace	8	51	2454	3	_grace
grama	8	56	2028	3	_grama
grana	6	57	2209	3	_grana
guarana	8	8	630	3	guarana
halacha	15	38	800	3	halacha
halala	9	47	1509	3	halala
hamada	12	3	991	3	hamada
harass	9	3	1394	3	harass
hariana	10	3	1024	3	hariana
hatrack	16	3	821	3	hatrack
hawala	12	36	891	3	hawala
hayrack	19	4	554	3	hayrack
jacana	15	3	793	3	jacana
jarina	13	40	1406	3	jarina
kabaka	11	34	850	3	kabaka
kabala	12	40	1155	3	kabala
kabaya	15	38	712	3	kabaya
kamala	12	33	996	3	kamala
kanaka	9	35	752	3	kanaka
karat	9	68	3759	3	kara_t
karate	10	53	2092	3	karate
karats	10	64	2049	3	karats
karma	11	34	1500	3	kar_ma
labara	8	37	1289	3	labara
larch	10	59	1979	3	lar_ch
larva	8	3	1248	3	lar_va
lorica	8	3	1044	3	lorica
maar	6	60	2505	3	ma_a_r
maars	7	46	2163	3	ma_ars
mac	7	80	5392	3	m__ac_
macacos	13	3	808	3	macacos
macadam	14	4	685	3	macadam
macaw	12	3	1176	3	maca_w
macaws	13	3	702	3	macaws
mace	8	73	4578	3	m__ace
mach	11	61	3447	3	m__ach
mack	12	57	3364	3	m__ack
macrame	13	3	871	3	macrame
macs	8	67	4250	3	m__acs
macula	10	30	1367	3	macula
madam	10	3	1622	3	mada_m
madame	11	3	985	3	madame
madams	11	3	1094	3	madams
madcap	13	3	633	3	madcap
madras	9	43	1642	3	madra_s
madrasah	14	32	478	3	madrasah
madrasas	11	31	776	3	madrasas
madrassa	11	27	462	3	madrassa
madrona	10	28	870	3	madrona
maffia	14	32	720	3	maffia
mafia	10	44	1803	3	ma_fia
mafic	12	56	1546	3	mafic_
magic	10	58	1865	3	magic_
magical	12	3	978	3	magical
magics	11	53	1161	3	magics
magma	10	45	1357	3	ma_gma
magmata	12	3	746	3	magmata
maharaja	20	5	279	3	maharaja
mahatma	14	4	378	3	mahatma
majagua	17	4	286	3	majagua
makar	11	56	1497	3	maka_r
makars	12	46	1263	3	makars
makuta	12	3	639	3	makuta
malaccas	14	4	516	3	malaccas
malady	12	3	786	3	malady
malanga	10	3	666	3	malanga
malar	7	64	2444	3	mala_r
malaria	9	3	1369	3	malaria
malars	8	50	2068	3	malars
malate	8	46	2455	3	malate
malic	9	45	2565	3	malic_
malice	10	48	1848	3	malice
maltha	11	3	750	3	maltha
mama	8	62	3158	3	m__ama
mamas	9	59	3077	3	mama_s
mamba	11	63	1751	3	ma_mba
mamma	8	63	1791	3	ma_mma
mana	6	53	4194	3	m__ana
manacle	11	3	1028	3	manacle
manage	9	38	1890	3	manage
mananas	9	34	1473	3	mananas
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	ma_nga
mania	7	56	3414	3	ma_nia
maniac	10	39	1797	3	maniac_
maniacal	12	4	672	3	maniacal
maniacs	11	43	1306	3	maniacs
manic	9	46	2943	3	manic_
manics	10	39	1993	3	manics
manila	8	45	1830	3	manila
manioca	11	35	894	3	manioca
manna	7	55	2253	3	ma_nna
manpack	17	4	606	3	manpack
manta	7	56	2990	3	ma_nta
mantra	8	41	1609	3	mantra
mantua	8	44	1202	3	mantua
mar	5	79	6594	3	mar___
marabou	11	4	749	3	marabou
marantas	10	3	1002	3	marantas
marauds	10	3	755	3	marauds
marble	10	42	1910	3	marble
marbly	13	41	1193	3	marbly
marcato	11	3	974	3	marcato
marcel	10	37	1485	3	marcel
mare	6	47	5932	3	mar__e
maremma	10	4	446	3	maremma
mares	7	64	5763	3	mar_es
margay	12	3	1059	3	margay
margays	13	3	749	3	margays
marge	8	53	2833	3	mar_ge
marges	9	45	2571	3	marges
margin	9	40	1684	3	margin
mariachi	15	4	449	3	mariachi
marimba	13	5	498	3	marimba
marinara	10	4	649	3	marinara
marinas	9	35	1937	3	marinas
marine	8	42	3040	3	marine
marish	11	43	1905	3	marish
marital	9	23	1418	3	marital
mark	10	51	3805	3	mar__k
markas	12	47	1700	3	markas
marked	13	39	2162	3	marked
marker	12	44	2039	3	marker
market	12	32	2604	3	market
markkaa	12	37	392	3	markkaa
markkas	12	35	608	3	markkas
marks	11	59	3348	3	mar_ks
markup	14	3	690	3	markup
marl	6	63	4161	3	mar__l
marled	9	55	2316	3	marled
marlin	8	42	2090	3	marlin
marls	7	55	3516	3	mar_ls
marly	10	69	2561	3	mar_ly
marmot	10	3	1874	3	marmot
marocain	12	4	706	3	marocain
maroon	8	31	1820	3	maroon
marque	17	24	1050	3	marque
marram	10	3	1388	3	marram
marrams	11	3	1012	3	marrams
marrano	9	3	942	3	marrano
marred	9	54	2104	3	marred
marrer	8	37	1667	3	marrer
marron	8	37	1754	3	marron
marrow	11	28	1260	3	marrow
marry	10	48	2169	3	mar_ry
mars	6	62	6186	3	mar__s
marsalas	10	3	825	3	marsalas
marse	7	62	3115	3	mar_se
marses	8	48	2711	3	marses
marsh	10	53	2085	3	mar_sh
marshal	12	3	897	3	marshal
marshy	14	55	833	3	marshy
mart	6	68	6597	3	mar__t
marted	9	44	2521	3	marted
marten	8	45	1826	3	marten
martial	9	24	1541	3	martial
martian	9	35	1468	3	martian
martin	8	41	2252	3	martin
marts	7	74	4223	3	mar_ts
martyr	11	3	569	3	martyr
marvel	11	37	1200	3	marvel
marvy	13	50	1403	3	mar_vy
masa	6	50	3471	3	m__asa
masalas	9	3	1205	3	masalas
masas	7	56	3041	3	masa_s
mascara	11	3	802	3	mascara
massa	7	55	1892	3	ma_ssa
mastaba	11	4	622	3	mastaba
match	12	56	2110	3	ma_tch
matrass	9	3	939	3	matrass
matza	16	3	1181	3	ma_tza
maxima	17	56	863	3	maxima
maya	9	58	2458	3	m__aya
mayan	10	56	1690	3	maya_n
mayas	10	59	2438	3	maya_s
mazard	18	3	876	3	mazard
mazuma	19	3	560	3	mazuma
mecca	11	3	993	3	m_ecca
medaka	13	3	634	3	medaka
megara	9	3	1009	3	megara
menace	10	32	1694	3	menace
merc	8	72	2562	3	mer_c_
merch	12	54	1796	3	mer_ch
mercs	9	60	2045	3	mer_cs
mercy	12	59	1618	3	mer_cy
mica	8	64	2824	3	m__ica
miracle	11	3	884	3	miracle
mirage	9	23	1365	3	mirage
mirza	16	4	1044	3	mir_za
misact	10	3	1668	3	misact
modica	11	3	1006	3	modica
mora	6	66	4127	3	mor__a
morae	7	58	3119	3	mora_e
moral	7	55	3343	3	mora_l
morale	8	52	2055	3	morale
morals	8	53	2463	3	morals
moras	7	64	3876	3	mora_s
morass	8	46	1449	3	morass
moray	10	54	2379	3	mora_y
morays	11	46	1388	3	morays
morula	8	7	1047	3	morula
mura	6	56	3329	3	mur__a
mural	7	52	2510	3	mura_l
murals	8	40	1675	3	murals
muras	7	53	2956	3	mura_s
murra	7	45	1908	3	mur_ra
murrha	11	36	645	3	murrha
musca	9	3	1176	3	m_usca
myricas	14	3	674	3	myricas
nagana	7	4	894	3	nagana
narc	6	71	2795	3	nar_c_
narco	7	67	1824	3	nar_co
narcs	7	61	2202	3	nar_cs
naric	7	68	2417	3	naric_
orach	10	52	1923	3	_orach
orca	6	55	2277	3	_or_ca
ostraca	9	3	782	3	ostraca
paca	8	51	3224	3	__paca
pajama	17	31	765	3	pajama
palace	10	45	1691	3	palace
palapa	10	3	1067	3	palapa
panacea	11	3	778	3	panacea
panada	9	41	1305	3	panada
panama	10	42	1334	3	panama
papacy	15	4	749	3	papacy
papaya	13	3	750	3	papaya
paprica	13	3	700	3	paprica
para	6	52	4217	3	par__a
parade	9	47	2064	3	parade
parae	7	63	3570	3	para_e
paramo	10	26	1464	3	paramo
parang	9	37	1551	3	parang
paraph	13	3	1126	3	paraph
paras	7	61	4304	3	para_s
parch	12	51	2300	3	par_ch
parka	11	51	2088	3	par_ka
parura	8	3	1058	3	parura
patacas	11	3	1100	3	patacas
piracy	13	3	947	3	piracy
pirana	8	7	1326	3	pirana
piraya	11	6	771	3	piraya
purana	8	7	1293	3	purana
qabala	17	39	919	3	qabala
race	6	67	4626	3	__race
rack	10	62	3488	3	__rack
racy	9	58	2568	3	__racy
raga	5	59	3081	3	__raga
raia	4	66	3838	3	__raia
raja	11	79	1868	3	__raja
ramada	9	3	1018	3	ramada
raya	7	52	2482	3	__raya
rerack	12	25	1316	3	rerack
samara	8	3	1385	3	samara
saran	5	37	3030	3	sara_n
sarans	6	42	2443	3	sarans
sarape	8	48	1757	3	sarape
sardana	8	3	864	3	sardana
satara	6	3	1553	3	satara
serac	7	59	2520	3	serac_
seracs	8	44	1857	3	seracs
smaragd	11	3	439	3	smaragd
strata	6	36	1628	3	strata
tamarack	16	4	436	3	tamarack
taramas	9	6	1269	3	taramas
tarmac	10	3	1033	3	tarmac_
tarmacs	11	3	832	3	tarmacs
taroc	7	57	2164	3	taroc_
tarocs	8	46	1566	3	tarocs
tarsia	6	55	1427	3	tarsia
tartana	7	30	1019	3	tartana
trace	7	58	2961	3	_trace
track	11	48	2301	3	_track
tract	7	56	3571	3	_tract
turaco	8	3	945	3	turaco
vara	7	55	3088	3	var__a
varas	8	60	2819	3	vara_s
varia	8	58	2420	3	var_ia
varna	8	45	1617	3	var_na
wrack	14	54	1388	3	_wrack
zanana	15	38	1036	3	zanana
zareba	17	3	642	3	zareba
zariba	17	3	697	3	zariba

Search took 8 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.143	1249587.4
2	DLD Change Limit	112716	415	7.263	15519.2
3	Display Results	415	415	0.126	3293.7
	(SQL Overall)	178691	415	7.532	23724.2