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

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

82 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
emanant	9	4	1108	(None)
demandant	13	4	582	2	demandant
emanate	9	3	1247	2	emanate
eminent	9	3	1384	2	eminent
manana	8	48	1607	2	_manana
manat	7	60	3999	2	_mana_t
remanent	10	3	1170	2	remanent
remnant	9	3	1263	2	rem_nant
adamant	10	11	1044	3	adamant
alant	5	57	4229	3	__alant
amaranth	13	5	514	3	amaranth
anent	5	49	3184	3	__anent
avant	8	62	2466	3	__avant
banana	8	32	1341	3	_banana
blatant	9	3	1067	3	blatant
clamant	11	3	1243	3	clamant
demandants	14	4	325	3	demandants
dominant	11	4	951	3	dominant
elegant	8	3	1150	3	elegant
eluant	6	3	1509	3	e_luant
emanated	11	3	916	3	emanated
emanates	10	3	1133	3	emanates
emanating	12	3	900	3	emanating
emanator	10	4	729	3	emanator
embank	14	34	655	3	em_bank
emigrant	11	4	855	3	emigrant
empanada	13	4	188	3	empanada
emplane	11	4	1001	3	emplane
enact	7	35	2536	3	e__nact
enchant	12	3	1311	3	enchant
entrant	7	3	1887	3	entrant
errant	6	6	1873	3	e_rrant
etchant	12	4	981	3	etchant
evacuant	13	4	441	3	evacuant
examinant	18	4	460	3	examinant
exhalant	18	9	535	3	exhalant
explant	16	3	1013	3	explant
extant	13	27	1475	3	e_xtant
germinant	12	4	617	3	germinant
immanent	12	4	680	3	immanent
implant	11	3	1133	3	implant
mana	6	53	4196	3	_mana__
manage	9	38	1890	3	_manage
mananas	9	34	1473	3	_mananas
manas	7	62	4043	3	_mana_s
manats	8	46	2346	3	_manats
manhunt	12	4	707	3	_manhunt
manna	7	55	2254	3	_man_na
mannan	8	54	1362	3	_mannan
mannans	9	36	1152	3	_mannans
mannas	8	50	1980	3	_mannas
maranta	9	3	1169	3	_maranta
mayan	10	56	1690	3	_mayan_
meanest	9	3	1570	3	meanest
meaning	10	39	1870	3	meaning
meant	7	65	3721	3	_m_eant
mediant	10	35	1670	3	mediant
mutant	8	3	1769	3	_mutant
natant	6	3	1873	3	_natant
peasant	9	3	1492	3	peasant
pennant	9	3	1249	3	pennant
permanent	13	6	878	3	permanent
qanat	14	44	2684	3	_qana_t
rampant	11	3	1217	3	rampant
regnant	8	3	1284	3	regnant
relaxant	15	4	584	3	relaxant
remnants	10	3	684	3	rem_nants
remontant	11	4	809	3	remontant
resonant	8	4	1081	3	resonant
revenant	11	4	1027	3	revenant
ruminant	10	4	785	3	ruminant
savant	9	4	1604	3	_savant
sealant	7	31	1830	3	sealant
seawant	10	36	1341	3	seawant
setenant	8	4	992	3	setenant
sonant	6	6	2195	3	_sonant
stagnant	9	4	689	3	stagnant
statant	7	3	1312	3	statant
tenant	6	3	2247	3	_tenant
termagant	12	4	445	3	termagant
vacant	11	4	1513	3	_vacant
zanana	15	38	1036	3	_zanana

Search took 7 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.156	1145455.1
2	DLD Change Limit	134027	82	6.640	20184.8
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	6.826	26178.0