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

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

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

300 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
madrigals	13	85	625	(None)
madrigal	12	162	726	1	madrigal_
madrigalist	15	8	313	2	madrigalist
warrigals	13	4	378	2	warrigals
admirals	11	4	435	3	_admirals
adrenals	9	4	631	3	_adrenals
aerials	7	40	1755	3	_aeri_als
argals	7	55	1771	3	_a_r_gals
arrivals	11	4	594	3	_arrivals
cardigans	13	4	516	3	cardigans
cardinals	12	4	801	3	cardinals
lacrimals	13	4	291	3	lacrimals
larrigans	10	4	401	3	larrigans
madeiras	11	4	477	3	madeira_s
madras	9	43	1643	3	madr__a_s
madrasahs	15	24	385	3	madrasahs
madrasas	11	31	776	3	madrasa_s
madrigalian	15	5	149	3	madrigalian
madrigalists	16	7	231	3	madrigal~~ist~~s
madronas	11	28	849	3	madrona_s
mandrills	12	4	545	3	mandri_lls
mandrils	11	3	849	3	mandri__ls
margays	13	3	749	3	ma_r_gays
marginals	12	4	602	3	marginals
marigold	12	4	409	3	ma_rigold
marigolds	13	4	308	3	ma_rigolds
marinas	9	35	1940	3	ma_rina_s
marital	9	23	1418	3	ma_rital_
marriages	12	4	738	3	marriages
marshals	13	3	778	3	ma_rshals
martingals	13	4	332	3	martingals
materials	11	5	1081	3	materi_als
maximals	19	32	522	3	ma_ximals
medials	10	39	1474	3	med_i_als
medicals	13	4	936	3	med_icals
medigaps	14	6	388	3	med_igaps
milligals	12	4	503	3	milligals
radials	8	36	1464	3	rad_i_als
radicals	11	26	1016	3	rad_icals
warragals	13	4	347	3	warragals
warrigal	12	4	431	3	warrigal_
abigails	11	4	333	4	_a_bigails
adagial	9	4	637	4	_adagial_
admiral	10	4	636	4	_admiral_
adrenal	8	3	826	4	_adrenal_
aerial	6	46	2571	4	_aeri_al_
aerogels	9	4	559	4	_aerogels
agrias	7	43	1539	4	_agri_a_s
amigas	9	59	1217	4	_a_miga_s
amritas	9	3	909	4	_amrita_s
animals	9	41	1170	4	_a_nimals
apicals	11	5	992	4	_a_picals
argal	6	50	2340	4	_a_r_gal_
argala	7	47	1267	4	_a_r_gala
argalas	8	40	1109	4	_a_r_galas
argali	7	50	1375	4	_a_r_gali
argalis	8	42	1419	4	_a_r_galis
argils	7	52	1362	4	_a_r_gils
argols	7	45	1461	4	_a_r_gols
arias	5	54	3803	4	_a_ri_a_s
ariels	6	51	1937	4	_a_ri_els
arils	5	87	3220	4	_a_ri__ls
arrayals	11	5	448	4	_arrayals
arrival	10	3	756	4	_arrival_
astragals	10	4	420	4	astragals
atrial	6	54	1894	4	_atri_al_
barbitals	13	4	526	4	barbitals
barillas	10	3	1020	4	ba_rillas
bedrivels	15	4	271	4	bedrivels
bridals	10	3	862	4	__bridals
burials	9	36	1208	4	_buri_als
cabrillas	13	4	560	4	cabrillas
cannibals	13	5	445	4	cannibals
capitals	12	20	945	4	ca_pitals
caracals	12	3	1076	4	ca_racals
cardiacs	13	7	692	4	cardi_acs
cardias	10	7	1512	4	cardi_a_s
cardigan	12	4	562	4	cardiga_n
cardinal	11	3	957	4	cardinal_
carinal	9	43	1824	4	ca_rinal_
carinas	9	36	2242	4	ca_rina_s
caritas	9	33	1696	4	ca_rita_s
carnivals	14	4	450	4	carnivals
carpals	11	34	1463	4	ca_r_pals
carriages	12	3	833	4	carriages
clericals	13	4	535	4	clericals
cordials	11	3	963	4	cordi_als
corrivals	14	4	462	4	corrivals
cuadrillas	13	5	321	4	cuadrillas
decrials	11	3	713	4	decri_als
deprivals	15	4	353	4	deprivals
dials	6	49	2534	4	__d_i_als
drills	7	44	1420	4	__dri_lls
drivels	11	39	792	4	__drivels
facials	12	33	1074	4	fa_ci_als
farfals	13	26	850	4	fa_r_fals
farinas	10	32	1525	4	fa_rina_s
galangals	11	4	290	4	galangals
garigues	10	3	496	4	ga_rigues
gavials	11	3	660	4	ga_vi_als
gharials	12	4	512	4	ghari_als
harijans	18	4	572	4	ha_rijans
harridans	13	15	456	4	harridans
hartals	10	3	1302	4	ha_r_tals
hydrillas	16	4	344	4	hydrillas
hydrogels	17	6	433	4	hydrogels
iatrical	10	4	927	4	iatrical_
imperials	13	4	734	4	imperi_als
jarinas	14	37	1220	4	ja_rina_s
labials	9	29	987	4	la_bi_als
lacrimal	12	4	444	4	lacrimal_
laminals	10	33	931	4	la_minals
lanitals	8	3	772	4	la_nitals
lariats	7	6	1505	4	la_ri_ats
larrigan	9	4	421	4	larriga_n
laryngals	13	4	251	4	laryngals
latrias	7	19	1321	4	latri_a_s
mackinaws	20	4	243	4	mackinaws
macrural	12	4	497	4	macrural_
macrurans	13	4	353	4	macrurans
madams	11	3	1094	4	mad___ams
madcaps	14	3	524	4	mad__caps
madeira	10	4	511	4	madeira__
maderizes	21	4	895	4	maderi_zes
madonnas	11	4	384	4	madonna_s
madrasa	10	38	788	4	madr__asa
madrasah	14	32	478	4	madrasa_h
madrases	11	26	1000	4	madr_ases
madrassa	11	27	463	4	madr__assa
madrassahs	16	29	240	4	madrassahs
madrassas	12	30	471	4	madrassas
madres	9	37	1818	4	madr___es
madrilene	12	4	366	4	madrilene
madrilenes	13	4	349	4	madrilenes
madrona	10	28	870	4	madrona__
madrones	11	29	1228	4	madr_ones
madronos	11	33	754	4	madr_onos
maffias	15	32	728	4	maffi_a_s
mafias	11	39	1357	4	ma_fi_a_s
magians	10	3	1075	4	ma_gi_ans
magical	12	3	978	4	ma_gical_
maills	8	42	1528	4	ma__i_lls
mails	7	60	3778	4	ma__i__ls
malangas	11	3	686	4	malanga_s
malarial	10	4	1061	4	malari_al_
malarias	10	3	1377	4	malari_a_s
malignly	14	4	468	4	ma_lignly
maligns	10	3	813	4	ma_lig_ns
mamaligas	14	4	338	4	mamaliga_s
mammals	10	38	927	4	ma__mmals
mandrels	11	3	731	4	mandr__els
mandril	10	4	935	4	mandri__l_
mandrill	11	4	661	4	mandri__ll
mangas	9	41	2293	4	ma__nga_s
mangels	10	36	1449	4	ma__ngels
maniacs	11	43	1306	4	ma_ni_acs
manias	8	40	2903	4	ma_ni_a_s
manilas	9	39	1587	4	ma_nila_s
manillas	10	26	1116	4	ma_nillas
mannitols	11	4	343	4	mannitols
manorial	10	3	1108	4	manori_al_
mantillas	11	4	704	4	mantillas
manuals	9	3	1122	4	ma__nuals
manurial	10	4	779	4	manuri_al_
maquilas	19	4	403	4	maquila_s
maracas	11	3	1377	4	ma_raca_s
maras	7	54	4330	4	ma_r__a_s
marcels	11	32	1237	4	ma_r_cels
margay	12	3	1060	4	ma_r_ga_y
marges	9	45	2571	4	ma_r_g_es
marginal	11	3	761	4	marginal_
margins	10	38	1519	4	ma_r_gins
maria	7	50	3289	4	ma_ri_a__
marimbas	14	4	436	4	ma_rimbas
marina	8	46	2341	4	ma_rina__
marinade	11	25	938	4	ma_rinade
marinades	12	26	898	4	ma_rinades
marinara	10	4	649	4	ma_rinara
marinaras	11	4	557	4	ma_rinaras
marinate	10	30	1778	4	ma_rinate
marinates	11	25	1639	4	ma_rinates
mariners	10	31	1387	4	ma_riners
marines	9	39	2803	4	ma_ri_nes
marishes	13	5	1255	4	ma_rishes
maritally	14	4	823	4	ma_ritally
markas	12	47	1701	4	ma_r_ka_s
markkas	12	35	608	4	ma_rkka_s
marls	7	55	3516	4	ma_r___ls
marrams	11	3	1012	4	ma_r_rams
marriage	11	4	725	4	marri_age
marrieds	11	28	807	4	marri_eds
marriers	10	33	1247	4	marri_ers
marries	9	38	2528	4	marri__es
marsala	9	3	958	4	ma_r_sala
marsalas	10	3	826	4	ma_r_salas
marshal	12	3	897	4	ma_rshal_
marshall	13	4	548	4	ma_rshall
marshalls	14	4	483	4	ma_rshalls
martial	9	24	1541	4	ma_rtial_
martians	10	31	1161	4	ma_rtians
martingal	12	4	406	4	martingal_
martingale	13	4	319	4	martingale
martingales	14	5	266	4	martingales
marvels	12	38	1009	4	ma_r_vels
marzipans	22	4	264	4	marzipans
material	10	3	1411	4	materi_al_
materiels	11	4	784	4	materi_els
matinal	9	3	1260	4	ma_tinal_
matrass	9	3	940	4	matr__ass
matrices	12	3	1208	4	matri_ces
matrixes	17	3	806	4	matri_xes
matronal	10	4	811	4	matronal_
maxillas	17	22	770	4	ma_xillas
maximal	18	34	709	4	ma_ximal_
medals	9	42	1806	4	med___als
medial	9	38	1986	4	med_i_al_
medians	10	32	1421	4	med_i_ans
medias	9	36	2078	4	med_i_a_s
medical	12	3	1251	4	med_ical_
medicinals	15	4	314	4	medicinals
medievals	15	5	335	4	medievals
medigap	13	7	462	4	med_iga_p
medinas	10	34	1146	4	med_ina_s
medivacs	16	4	400	4	med_ivacs
memorials	13	4	656	4	memori_als
menials	9	40	1569	4	m_eni_als
meticals	12	3	1076	4	m_eticals
metrical	12	3	1159	4	metrical_
midnights	16	4	268	4	midnights
midribs	12	3	551	4	midri__bs
midriffs	17	4	253	4	midri_ffs
milligal	11	4	570	4	milligal_
minimals	12	32	743	4	m_inimals
misdials	11	3	750	4	misdi_als
mistrials	11	4	814	4	mistri_als
modals	9	39	1446	4	mod___als
morals	8	53	2464	4	m_or__als
morgans	10	3	1012	4	m_or_gans
mortals	9	39	1401	4	m_or_tals
mudras	9	42	1226	4	mudr__a_s
mudsills	11	4	425	4	mudsi_lls
mulligans	12	4	478	4	mulligans
murals	8	40	1676	4	m_ur__als
musicals	12	4	710	4	m_usicals
mydriases	15	6	308	4	mydriases
mydriasis	15	5	262	4	mydriasis
myriads	13	3	435	4	m_yri_ads
myricas	14	3	675	4	m_yrica_s
nadiral	8	3	634	4	nad_iral_
narial	6	3	1796	4	na_ri_al_
narwals	10	3	698	4	na_r_wals
narwhals	14	4	361	4	na_rwhals
nonrivals	12	4	453	4	nonrivals
ordinals	9	4	676	4	ord_inals
origans	8	3	997	4	__origans
outrivals	12	4	389	4	outrivals
papricas	14	4	705	4	paprica_s
paprikas	16	4	385	4	paprika_s
pariahs	12	38	1234	4	pa_ri_ahs
parians	9	35	1974	4	pa_ri_ans
parietals	11	4	687	4	pa_rietals
parrals	9	44	1457	4	pa_r_rals
partials	10	19	1197	4	pa_rtials
prodigals	13	4	423	4	prodigals
quadriga	19	4	407	4	quadriga__
quadrigae	20	5	363	4	quadriga_e
radial	7	40	2039	4	rad_i_al_
radiale	8	38	1352	4	rad_i_ale
radians	8	30	1382	4	rad_i_ans
radical	10	33	1279	4	rad_ical_
radicels	11	29	718	4	rad_icels
redials	8	44	1688	4	red_i_als
redrills	9	5	608	4	redri_lls
reprisals	11	4	456	4	reprisals
retrials	8	5	1082	4	retri_als
rials	5	50	2667	4	___ri_als
rivals	9	42	1318	4	___rivals
riyals	9	41	1108	4	___riyals
sacrals	9	33	1179	4	sacr__als
sahiwals	14	4	364	4	sa_hiwals
saigas	7	41	1429	4	sa__iga_s
saurians	8	3	776	4	sauri_ans
serials	7	39	1975	4	_seri_als
springals	12	4	537	4	_springals
strigils	9	4	685	4	_strigils
taigas	7	37	1257	4	ta__iga_s
tarsals	7	25	1260	4	ta_r_sals
trials	6	43	1988	4	__tri_als
tribals	9	6	1075	4	__tribals
urials	6	44	1519	4	__uri_als
urinals	7	6	1026	4	__urinals
varias	9	50	1991	4	va_ri_a_s
varietals	12	4	444	4	va_rietals
variolas	11	6	854	4	va_riolas
wadmaals	14	4	241	4	wad_maals
wadmals	13	3	551	4	wad__mals
wanigans	12	4	474	4	wa_nigans
wannigans	13	4	239	4	wannigans
warragal	12	4	386	4	warragal_
zaribas	18	3	604	4	za_riba_s

Search took 26 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	165329	0.906	197230.7
2	DLD Change Limit	165329	300	24.640	6709.8
3	Display Results	300	300	0.126	2381.0
	(SQL Overall)	178691	300	25.672	6960.5