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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

83 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
emeriti	9	4	943	(None)
emerita	9	3	871	1	emerita
demerit	10	3	1499	2	demerit_
demerits	11	3	1076	2	demerits
emeries	9	16	2002	2	emeries
emeritae	10	4	635	2	emeritae
emeritas	10	4	643	2	emeritas
emeritus	10	4	517	2	emeritus
merit	7	3	3918	2	_merit_
merits	8	3	2087	2	_merits
periti	8	3	1995	2	_periti
temerity	13	4	690	2	temerity
amenity	12	3	833	3	amenity
amorini	9	3	1035	3	amorini
amrita	8	4	1113	3	am_rita
aperitif	13	4	734	3	aperitif
celerity	13	4	764	3	celerity
cerite	8	47	2487	3	_cerite
demerited	13	3	907	3	demerited
demeriting	14	4	868	3	demeriting
eerie	5	52	2853	3	e_eri_e
eerier	6	43	2002	3	e_erier
eerily	9	29	1356	3	e_erily
elegit	7	12	1289	3	elegit_
elegits	8	14	934	3	elegits
embrute	11	4	570	3	embrute
emeerate	10	4	1010	3	emeerate
emerald	10	4	692	3	emerald
emerge	9	15	1046	3	emer_ge
emerged	11	15	821	3	emerged
emerges	10	13	1088	3	emerges
emerging	12	3	789	3	emerging
emerod	9	13	921	3	emer_od
emerods	10	13	765	3	emerods
emeroid	10	15	1118	3	emeroid
emeroids	11	14	772	3	emeroids
emersed	10	13	851	3	emersed
emersion	10	4	773	3	emersion
emery	10	48	1433	3	emer__y
emesis	8	47	1262	3	emesi_s
emetic	10	6	1445	3	emeti_c
emetics	11	6	1072	3	emetics
emetin	8	6	1346	3	emeti_n
emetine	9	7	1294	3	emetine
emetins	9	8	1265	3	emetins
emeute	8	3	853	3	eme_ute
emirate	9	10	1583	3	emirate
emit	6	54	3842	3	em__it_
emits	7	54	2147	3	em__its
emperies	12	3	1456	3	emperies
emprise	11	3	1072	3	emprise
emprize	20	3	884	3	emprize
enteritis	9	4	1130	3	enteritis
eremite	9	3	1283	3	eremite
eremitic	12	4	855	3	eremitic
eserine	7	4	1590	3	eserine
esprit	8	3	1284	3	esprit_
esprits	9	3	839	3	esprits
eternity	11	4	668	3	eternity
eucrite	9	3	990	3	eucrite
eucritic	12	4	713	3	eucritic
euripi	8	5	608	3	e_uripi
evert	8	49	2951	3	ever_t_
everts	9	45	1489	3	ever_ts
exert	12	46	2414	3	exer_t_
exerts	13	37	1229	3	exer_ts
ferity	12	28	1334	3	_ferity
feterita	11	6	646	3	feterita
legerity	12	4	571	3	legerity
medii	8	45	1349	3	_medi_i
merino	8	3	1509	3	_merino
merisis	9	32	1317	3	_merisis
meristic	12	3	1125	3	_meristic
merited	10	3	1385	3	_merited
meriting	11	3	1469	3	_meriting
metritis	10	4	918	3	metritis
neritic	9	13	1433	3	_neritic
seniti	6	43	1722	3	_seniti
severity	14	4	697	3	severity
temerities	12	6	848	3	temerities
verite	9	43	2344	3	_verite
verity	12	37	1485	3	_verity
yperite	12	4	989	3	yperite

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.406	440125.6
2	DLD Change Limit	134027	83	6.860	19537.5
3	Display Results	83	83	0.016	5187.5
	(SQL Overall)	178691	83	7.282	24538.7