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

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

286 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
mandates	11	3	1409	(None)
mandate	10	3	1557	1	mandate_
mandated	12	3	1028	1	mandated
andantes	9	3	1085	2	_andantes
annates	7	24	1542	2	_annates
bandages	12	3	1063	2	bandages
bandmates	14	4	792	2	bandmates
caudates	11	3	1025	2	caudates
emanates	10	3	1133	2	eman_ates
emendates	12	4	606	2	emendates
handaxes	19	3	840	2	handaxes
madames	12	3	1006	2	ma_dames
magnates	11	5	1160	2	magnates
malates	9	35	2260	2	ma_lates
maleates	10	33	1634	2	maleates
manages	10	34	1896	2	man_ages
manatee	9	3	1766	2	man_atee
manatees	10	3	1042	2	man_atees
manats	8	46	2346	2	man_at_s
mandalas	11	3	943	2	mandalas
mandamus	13	4	552	2	mandamus
mandator	11	4	817	2	mandator
mandators	12	4	786	2	mandators
mandrakes	16	4	635	2	mandrakes
manducates	15	4	559	2	manducates
mannites	10	3	1261	2	mannites
mantes	8	44	3078	2	man__tes
misdates	11	11	1362	2	misdates
tannates	8	19	1195	2	tannates
vanadates	13	4	513	2	vanadates
abates	8	58	2503	3	_a_bates
ablates	9	24	1690	3	_ablates
adages	8	4	1295	3	_a_dages
addaxes	16	3	457	3	_addaxes
adnate	7	29	1348	3	_adnate_
aerates	7	46	2748	3	_aerates
agates	7	61	2133	3	_a_gates
agnates	8	28	1318	3	_agnates
airdates	9	3	971	3	airdates
alates	6	48	3396	3	_a_lates
almandites	13	4	395	3	almandites
amidases	11	3	664	3	amidases
amirates	10	11	1479	3	amirates
amniotes	10	3	660	3	amniotes
andante	8	3	1127	3	_andante_
animates	10	13	1642	3	_animates
anlaces	9	23	1373	3	_anlaces
anlages	8	24	1410	3	_anlages
anlases	7	25	1490	3	_anlases
ansate	6	45	1786	3	_ansate_
ansated	8	42	1400	3	_ansated
antedates	10	4	860	3	_antedates
antes	5	63	3432	3	_an__tes
aviates	10	3	1306	3	_aviates
backdates	18	4	815	3	backdates
baldpates	14	4	523	3	baldpates
bandage	11	3	1102	3	bandage_
bandaged	13	3	731	3	bandaged
bandager	12	3	770	3	bandager
bandagers	13	3	588	3	bandagers
bandanas	11	17	857	3	bandanas
bandas	9	51	2054	3	banda__s
bandies	10	41	2486	3	band_ies
banditos	11	34	763	3	banditos
bandits	10	38	1479	3	bandit_s
bandmate	13	4	797	3	bandmate_
bandores	11	3	1160	3	bandores
banjaxes	24	4	339	3	banjaxes
bondages	12	3	789	3	bondages
canapes	11	12	1308	3	can_apes
candidates	14	4	630	3	candidates
candies	10	41	2561	3	cand_ies
candles	10	44	2234	3	cand_les
cantatas	10	34	1008	3	cantatas
canulates	11	3	1286	3	canulates
canvases	13	34	951	3	canvases
carates	9	56	3060	3	ca_rates
caseates	10	3	1370	3	caseates
caudate	10	3	1135	3	caudate_
caudated	12	3	806	3	caudated
craniates	11	3	1065	3	craniates
cyanates	13	23	842	3	cyan_ates
dandies	9	41	2144	3	dand_ies
dandles	9	42	1853	3	dand_les
dates	6	56	3915	3	___dates
denudates	11	4	558	3	denudates
donates	8	32	1722	3	don_ates
emaciates	13	4	788	3	emaciates
emanate	9	3	1247	3	eman_ate_
emanated	11	3	916	3	eman_ated
emendate	11	4	676	3	emendate_
emendated	13	4	464	3	emendated
enates	6	40	2642	3	_en_ates
endites	8	37	1706	3	_endites
exudates	16	3	662	3	exudates
fanfares	14	3	677	3	fanfares
gallates	9	28	1552	3	gallates
gradates	10	5	1078	3	gradates
grandames	13	4	671	3	grandames
hamates	12	29	1767	3	ha_mates
handles	11	40	2065	3	hand_les
handsets	12	25	834	3	handsets
imamates	12	3	765	3	ima_mates
indites	8	36	1898	3	_indites
ingates	8	27	1689	3	_ingates
inmates	9	27	1576	3	_inmates
inundates	10	4	577	3	inundates
iodates	8	3	1289	3	_iodates
karates	11	56	1747	3	ka_rates
khanates	15	3	573	3	khan_ates
labiates	10	10	1151	3	labiates
lactates	10	3	1122	3	lactates
lanate	6	4	2126	3	lan_ate_
lanated	8	3	1320	3	lan_ated
landaus	8	3	1034	3	landa_us
lapidates	12	4	714	3	lapidates
lindanes	9	3	916	3	lindanes
macerates	13	21	1356	3	macerates
machetes	15	3	963	3	machetes
macrames	14	3	895	3	macrames
maculates	13	20	1372	3	maculates
madame	11	3	985	3	ma_dame_
madams	11	3	1094	3	ma_da_ms
madrases	11	26	1000	3	madrases
madres	9	37	1818	3	ma_d_res
maenades	11	3	747	3	maenades
magdalen	12	4	352	3	magdalen
magdalens	13	4	282	3	magdalens
magnate	10	5	1270	3	magnate_
makebates	17	4	496	3	makebates
maladies	11	3	1193	3	maladies
malate	8	46	2455	3	ma_late_
maleate	9	41	1754	3	maleate_
maltases	10	3	969	3	maltases
mammate	10	44	1127	3	mammate_
mammatus	11	4	423	3	mammatus
manacles	12	3	952	3	manacles
manage	9	38	1890	3	man_age_
managed	11	32	1260	3	man_aged
manager	10	34	1358	3	man_ager
managers	11	29	1100	3	man_agers
mananas	9	34	1473	3	man_anas
manas	7	62	4042	3	man_a__s
manat	7	60	3998	3	man_at__
manches	14	38	1862	3	man_ches
manchets	15	26	957	3	manchets
mandala	10	3	1020	3	manda_la
mandalic	13	4	779	3	mandalic
mandamuses	15	4	339	3	mandamuses
mandarin	11	4	1101	3	mandarin
mandarins	12	4	1038	3	mandarins
mandataries	14	5	381	3	mandat~~ari~~es
mandatary	15	4	324	3	mandatary
mandating	13	3	977	3	mandating
mandatories	14	5	494	3	mandat~~ori~~es
mandatory	15	4	524	3	mandatory
mandibles	14	4	554	3	mandibles
mandolas	11	3	913	3	mandolas
mandrake	15	4	600	3	mandrake_
mandrel	10	3	868	3	mand_rel
mandrels	11	3	731	3	mandrels
mandrils	11	3	848	3	mandrils
manducate	14	4	577	3	manducate_
manducated	16	4	456	3	manducated
maneges	10	36	1214	3	man_eges
manes	7	66	4895	3	man___es
mangabey	16	4	345	3	mangabey
mangabeys	17	4	203	3	mangabeys
mangabies	14	4	637	3	mangabies
manganates	13	4	594	3	manganates
manganese	12	4	480	3	manganese
manganites	13	4	703	3	manganites
mangas	9	41	2292	3	manga__s
manges	9	46	2894	3	man__ges
mangles	10	40	2146	3	man_gles
mangoes	10	43	1613	3	man_goes
manholes	13	3	1118	3	manholes
maniacs	11	43	1306	3	mania_cs
manias	8	40	2903	3	mania__s
manilles	10	23	1259	3	manilles
maniples	12	26	942	3	maniples
manitos	9	3	1405	3	man_itos
manitus	9	3	1092	3	man_itus
manmade	12	3	796	3	manmade_
mannans	9	36	1152	3	manna_ns
mannas	8	50	1980	3	manna__s
mannite	9	3	1290	3	mannite_
mannoses	10	3	908	3	mannoses
manropes	12	3	791	3	manropes
mansards	11	4	801	3	mansards
manses	8	42	2551	3	man__ses
mantas	8	57	2536	3	man__tas
mantel	8	43	1797	3	man__tel
mantels	9	45	1504	3	man__tels
mantis	8	39	2603	3	man__tis
mantises	10	3	1792	3	mantises
mantles	9	48	2070	3	man_tles
mantlets	10	46	1120	3	mantlets
manuals	9	3	1121	3	manua_ls
manures	9	3	1335	3	man_ures
manwards	14	4	761	3	manwards
marcatos	12	4	916	3	marcatos
marinates	11	25	1638	3	marinates
marlites	10	34	1526	3	marlites
marmites	12	22	1279	3	marmites
massages	11	5	988	3	massages
mates	7	52	5136	3	m___ates
mattes	8	56	2453	3	ma__ttes
maturates	11	3	1175	3	maturates
maundies	11	3	785	3	maund_ies
maydays	16	3	448	3	mayda_ys
mediates	11	28	1406	3	mediates
menaces	11	27	1552	3	men_aces
menages	10	36	1539	3	men_ages
mesdames	13	4	604	3	mesdames
metates	9	27	2000	3	m_etates
migrates	11	11	1284	3	migrates
mindsets	11	3	568	3	mindsets
mintages	11	11	1051	3	mintages
minutes	9	35	1343	3	min_utes
misdate	10	14	1396	3	misdate_
misdated	12	12	1111	3	misdated
mismates	12	11	1455	3	mismates
misrates	10	13	1823	3	misrates
monades	10	37	1382	3	mon_ades
mondes	9	43	2235	3	mond__es
montages	11	14	1218	3	montages
montanes	10	11	1452	3	montanes
montes	8	42	2693	3	mon__tes
mundane	10	3	807	3	mundane_
muriates	10	3	1208	3	muriates
mutates	9	22	1579	3	m_utates
narrates	8	3	1275	3	narrates
nates	5	52	3833	3	__n_ates
nidates	8	3	1188	3	_nidates
outdates	9	31	1474	3	outdates
oxidates	16	3	633	3	oxidates
palates	9	36	2493	3	pa_lates
palpates	12	26	1306	3	palpates
pancakes	16	3	707	3	pancakes
pandanus	11	3	643	3	pandanus
pandas	9	55	2196	3	panda__s
pandies	10	42	2450	3	pand_ies
pandits	10	39	1421	3	pandit_s
pandores	11	3	1245	3	pandores
penates	9	33	2159	3	pen_ates
playdates	15	5	490	3	playdates
predates	11	6	1580	3	predates
qanats	15	41	1281	3	qan_at_s
radiates	9	24	1529	3	radiates
randans	8	3	1321	3	randa_ns
randies	8	42	2566	3	rand_ies
redates	8	34	2386	3	_redates
sandaled	10	3	923	3	sandaled
sandals	8	27	1520	3	sanda_ls
sanitates	9	6	1173	3	sanitates
satiates	8	3	1463	3	satiates
savates	10	3	1295	3	sa_vates
sedates	8	34	1803	3	_sedates
senates	7	33	2258	3	sen_ates
sensates	8	5	1113	3	sensates
sinuates	8	3	1095	3	sinuates
sundaes	8	3	1309	3	sunda_es
tankages	13	21	711	3	tankages
tannages	9	22	896	3	tannages
tannate	7	18	1352	3	tannate_
umangites	12	4	448	3	umangites
undated	9	31	1846	3	_undated
updates	10	32	979	3	_updates
vacates	12	3	1283	3	va_cates
validates	13	3	824	3	validates
valuates	11	28	1119	3	valuates
vanadate	12	4	551	3	vanadate_
vanadiates	14	4	374	3	vanadiates
vandals	11	32	1166	3	vanda_ls
vandas	10	39	1599	3	vanda__s
vandykes	19	4	216	3	vandykes
vantages	12	11	902	3	vantages
variates	11	12	1497	3	variates
vendaces	14	5	718	3	vendaces
wannabes	13	4	447	3	wannabes
wantages	12	10	902	3	wantages
windages	13	3	826	3	windages
xanthates	19	4	565	3	xanthates
yardages	13	3	620	3	yardages
zincates	19	3	773	3	zincates

Search took 9 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	146162	0.170	1051123.5
2	DLD Change Limit	146162	286	8.656	16885.6
3	Display Results	286	286	0.126	2269.8
	(SQL Overall)	178691	286	8.952	19961.0