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

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

307 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
mediate	10	34	1521	(None)
mediae	9	42	1741	1	media_e
mediated	12	30	1187	1	mediated
mediates	11	28	1406	1	mediates
medicate	13	5	1324	1	medicate
meditate	11	3	1062	1	meditate
bedmate	12	3	943	2	bedmate
dedicate	12	3	1280	2	dedicate
deviate	11	3	1271	2	deviate
immediate	14	4	430	2	immediate
media	8	47	2171	2	media__
mediacy	15	3	614	2	mediacy
mediad	10	43	1371	2	media_d
medial	9	38	1986	2	media_l
medials	10	39	1473	2	medials
median	9	41	1754	2	media_n
medians	10	32	1421	2	medians
mediant	10	35	1670	2	mediant
mediants	11	29	949	2	mediants
medias	9	36	2078	2	media_s
mediately	15	4	461	2	mediately
mediative	15	4	812	2	mediative
mediatize	21	4	690	2	mediatize
mediator	11	3	904	2	mediator
medicare	13	4	748	2	medicare
medicated	15	4	1007	2	medicated
medicates	14	3	1211	2	medicates
meditated	13	4	808	2	meditated
meditates	12	3	981	2	meditates
metate	8	27	2053	2	me_tate
modiste	10	3	928	2	modiste
muriate	9	3	1336	2	muriate
pedate	9	31	1776	2	ped_ate
radiate	8	34	1631	2	radiate
redate	7	41	2468	2	red_ate
rediae	7	42	2199	2	redia_e
remediate	12	4	754	2	remediate
sedate	7	30	1981	2	sed_ate
seriate	7	37	2247	2	seriate
abdicate	13	4	890	3	abdicate
adnate	7	29	1348	3	_adnate
aedile	7	37	1665	3	aedi_le
aedine	7	32	1839	3	aedi_ne
aerate	6	48	3055	3	ae_rate
ameerate	10	3	963	3	ameerate
aviate	9	3	1520	3	_aviate
bediaper	13	4	493	3	bediaper
bedirty	13	4	418	3	bedirty
bedmates	13	4	918	3	bedmates
bedplate	13	4	622	3	bedplate
bedrape	12	7	769	3	bedrape
berate	8	47	2902	3	be_rate
celibate	12	5	931	3	celibate
cerate	8	48	2946	3	ce_rate
cerite	8	47	2487	3	ceri_te
chedite	13	3	886	3	chedi_te
ciliate	9	5	1460	3	ciliate
date	5	64	4332	3	__d_ate
dealate	8	36	1784	3	dealate
debate	9	44	1919	3	de_bate
deciare	10	7	1066	3	deciare
decimate	13	4	1112	3	decimate
dedicated	14	3	1025	3	dedicated
dedicatee	13	4	1034	3	dedicatee
dedicates	13	3	1169	3	dedicates
deflate	11	36	1394	3	deflate
delate	7	38	2775	3	de_late
delicate	11	3	1549	3	delicate
dentate	8	3	1515	3	dentate
depilate	11	3	1170	3	depilate
derate	7	45	3123	3	de_rate
derivate	12	3	1120	3	derivate
deviated	13	3	1104	3	deviated
deviates	12	3	1273	3	deviates
dilate	7	32	2069	3	__dilate
dimidiate	13	4	534	3	dimidiate
dite	5	55	4755	3	__di_te
edible	9	6	935	3	_edible
edict	8	47	2228	3	_edict_
edicts	9	49	1170	3	_edicts
edile	6	48	1949	3	_edi_le
edit	5	49	3486	3	_edi_t_
edited	8	39	1367	3	_edi_ted
edits	6	58	1903	3	_edi_ts
educate	10	3	1021	3	_educate
elate	5	53	3588	3	_e_late
elite	5	62	3018	3	_eli_te
eluate	6	23	1543	3	_eluate
emaciate	12	4	875	3	emaciate
emanate	9	3	1247	3	emanate
emeerate	10	4	1010	3	emeerate
emendate	11	4	678	3	emendate
emeritae	10	4	635	3	emeritae
emirate	9	10	1583	3	emirate
emulate	9	3	1412	3	emulate
enate	5	44	2815	3	_e_nate
endite	7	38	1759	3	endi_te
epilate	9	3	1428	3	_epilate
equate	15	20	1246	3	_equate
eradiate	9	19	1175	3	eradiate
ergate	7	3	1514	3	_ergate
estate	6	47	1976	3	_estate
evite	8	53	1768	3	_evi_te
expiate	16	9	1059	3	expiate
federate	12	3	1088	3	federate
fellate	10	3	1343	3	fellate
feriae	9	56	1860	3	feria_e
fermate	12	28	1300	3	fermate
ferrate	10	30	1404	3	ferrate
filiate	10	4	1423	3	filiate
foliate	10	5	1353	3	foliate
gelate	7	34	2126	3	ge_late
geminate	11	4	1181	3	geminate
gemmate	12	41	838	3	gemmate
gestate	8	36	1407	3	gestate
gladiate	10	5	705	3	gladiate
headgate	13	4	648	3	headgate
herniate	11	4	811	3	herniate
hesitate	11	6	997	3	hesitate
hydrate	14	23	981	3	hydrate
ideate	7	3	1368	3	_ideate
indicate	11	3	1335	3	indicate
indite	7	35	2032	3	indi_te
iodate	7	3	1350	3	iod_ate
iodinate	9	4	934	3	iodinate
labiate	9	13	1357	3	labiate
legate	7	29	1745	3	le_gate
lenite	6	7	1998	3	leni_te
levigate	12	4	662	3	levigate
levirate	11	4	762	3	levirate
levitate	11	3	793	3	levitate
madame	11	3	985	3	mad_ame
magnate	10	5	1270	3	magnate
malate	8	46	2456	3	m_alate
maleate	9	41	1754	3	maleate
mammate	10	44	1127	3	mammate
mandate	10	3	1557	3	mandate
marinate	10	30	1778	3	marinate
mate	6	51	5422	3	m___ate
meat	6	63	5960	3	me__at_
meated	9	42	2240	3	me__ated
meats	7	50	3405	3	me__ats
meaty	10	70	2131	3	me__aty
medaka	13	3	634	3	med_aka
medal	8	62	2133	3	med_a_l
medaled	11	34	1161	3	med_aled
medals	9	42	1805	3	med_als
meddle	10	33	1276	3	med_dle
mediacies	14	4	718	3	mediacies
medially	14	12	932	3	medially
medianly	14	12	594	3	medianly
mediating	13	3	1120	3	mediating
mediation	12	3	1229	3	mediation
mediatized	23	4	475	3	mediatized
mediatizes	22	4	560	3	mediatizes
mediators	12	4	892	3	mediators
mediatory	15	4	643	3	mediatory
mediatrix	19	6	312	3	mediatrix
medic	10	46	1965	3	medi__c
medicable	16	4	750	3	medicable
medicaid	14	4	578	3	medicaid
medical	12	3	1251	3	medical
medicals	13	4	936	3	medicals
medicant	13	9	1083	3	medicant
medicants	14	6	678	3	medicants
medicares	14	4	687	3	medicares
medicide	14	4	771	3	medicide
medicine	13	4	954	3	medicine
medick	15	40	1013	3	medi_ck
medicks	16	36	841	3	medicks
medico	11	37	1116	3	medi_co
medicos	12	33	983	3	medicos
medics	11	41	1535	3	medi_cs
medigap	13	7	462	3	medigap
medigaps	14	6	388	3	medigaps
medii	8	45	1349	3	medi__i
medina	9	41	1409	3	medi_na
medinas	10	34	1146	3	medinas
mediocre	13	4	347	3	mediocre
meditative	16	4	628	3	meditative
meditator	12	4	659	3	meditator
medium	11	37	1162	3	medi_um
mediums	12	30	872	3	mediums
medius	9	36	1328	3	medi_us
medivac	15	5	469	3	medivac
medivaced	18	4	313	3	medivaced
medivacs	16	4	400	3	medivacs
medlar	9	30	1046	3	medla_r
medlars	10	25	944	3	medlars
medusae	10	4	476	3	medusae
meikle	12	3	665	3	me_ikle
meinie	8	26	1452	3	me_inie
meister	9	31	1416	3	me_ister
melilite	10	4	1057	3	melilite
melinite	10	4	1175	3	melinite
meliorate	11	7	948	3	meliorate
meltage	10	3	795	3	meltage
menace	10	32	1694	3	me_nace
menage	9	32	1654	3	me_nage
menial	8	42	2303	3	menia_l
menials	9	40	1568	3	menials
meniscate	13	4	622	3	meniscate
mensae	8	41	1405	3	mensa_e
meristem	12	4	574	3	meristem
merit	7	3	3918	3	meri_t_
merited	10	3	1385	3	meri_ted
merits	8	3	2087	3	meri_ts
mesial	8	48	1808	3	mesia_l
mesian	8	43	1550	3	mesia_n
message	10	3	783	3	message
messmate	12	4	639	3	messmate
metage	9	31	1445	3	me_tage
metates	9	27	2001	3	me_tates
mete	6	44	3813	3	me___te
methane	12	32	1179	3	methane
metisse	9	3	650	3	metisse
metricate	13	4	992	3	metricate
migrate	10	13	1417	3	migrate
militate	10	3	1167	3	militate
misate	8	12	2269	3	m_isate
misdate	10	14	1396	3	misdate
mismate	11	14	1535	3	mismate
misrate	9	13	1914	3	misrate
mite	6	62	4941	3	m__i_te
mitigate	11	4	869	3	mitigate
moderate	11	7	1099	3	moderate
modistes	11	3	864	3	modistes
modulate	11	3	859	3	modulate
motivate	13	4	769	3	motivate
mudcat	11	3	1120	3	mudcat_
mudcats	12	3	622	3	mudcats
muriated	11	3	979	3	muriated
muriates	10	3	1208	3	muriates
muricate	12	3	1111	3	muricate
mutate	8	30	1748	3	m_utate
mutilate	10	3	1227	3	mutilate
negate	7	29	1557	3	ne_gate
neonate	7	3	1133	3	neonate
nervate	10	3	953	3	nervate
nidate	7	3	1378	3	nid_ate
obviate	12	3	578	3	obviate
opiate	8	5	1346	3	_opiate
ordinate	9	3	1025	3	ordinate
oxidate	15	3	702	3	oxidate
pectate	11	22	1469	3	pectate
pedicle	12	3	897	3	pedicle
pelite	8	43	2300	3	peli_te
peltate	9	20	1377	3	peltate
pennate	9	33	1403	3	pennate
petite	8	43	2065	3	peti_te
podite	9	33	1535	3	podi_te
predate	10	6	1689	3	pred_ate
predicate	14	4	1178	3	predicate
radiale	8	38	1352	3	radiale
radiated	10	25	1259	3	radiated
radiates	9	24	1529	3	radiates
radicate	11	4	1287	3	radicate
rebate	8	44	2411	3	re_bate
recite	8	36	2511	3	reci_te
recrate	9	26	2166	3	recrate
redated	9	31	2092	3	red_ated
redates	8	34	2387	3	red_ates
redia	6	55	2448	3	redia__
redial	7	49	2311	3	redia_l
redialed	10	3	1079	3	redialed
redials	8	44	1688	3	redials
redias	7	45	2360	3	redia_s
redictate	12	4	906	3	redictate
redipt	9	41	1674	3	redipt_
redware	11	3	936	3	redware
reflate	10	35	1626	3	reflate
regrate	8	26	1866	3	regrate
relate	6	40	3363	3	re_late
remate	8	44	2868	3	re_mate
remediated	14	4	655	3	remediated
remediates	13	4	693	3	remediates
replate	9	34	2005	3	replate
repudiate	12	4	618	3	repudiate
reradiate	10	17	903	3	reradiate
resinate	8	3	1677	3	resinate
resite	6	41	2845	3	resi_te
reslate	7	35	2059	3	reslate
restate	7	38	2488	3	restate
satiate	7	3	1540	3	satiate
sedated	9	37	1435	3	sed_ated
sedater	8	37	1363	3	sed_ater
sedates	8	34	1804	3	sed_ates
sedile	7	35	1723	3	sedi_le
senate	6	37	2517	3	se_nate
sensate	7	3	1189	3	sensate
septate	9	5	1187	3	septate
seriated	9	27	1702	3	seriated
seriates	8	26	2067	3	seriates
serrate	7	30	1754	3	serrate
speciate	12	20	958	3	speciate
striate	7	42	1895	3	striate
teniae	6	45	1735	3	tenia_e
ternate	7	4	1548	3	ternate
testate	7	39	1623	3	testate
unmediated	14	4	516	3	unmediated
update	9	38	1029	3	upd_ate
variate	10	13	1643	3	variate
vedette	11	6	600	3	vedette
velate	9	37	2014	3	ve_late
verite	9	43	2344	3	veri_te
vesicate	13	12	1005	3	vesicate
vitiate	10	34	1295	3	vitiate

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	134027	0.766	233278.1
2	DLD Change Limit	134027	307	6.906	19407.3
3	Display Results	307	307	0.110	2790.9
	(SQL Overall)	178691	307	7.782	22962.1