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

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

72 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
esterases	9	4	963	(None)
esterase	8	4	948	1	esterase_
estruses	8	3	848	2	est_ruses
asperates	11	3	1255	3	asperates
asperses	10	41	1167	3	asper_ses
asterisks	13	4	681	3	asterisks
asterisms	11	5	1106	3	asterisms
deuterates	11	4	908	3	deuterates
easterlies	10	4	671	3	easterlies
eateries	8	3	2431	3	eater_ies
ectases	9	29	1167	3	ect__ases
emeerates	11	4	937	3	emeerates
entases	7	28	1627	3	ent__ases
epimerases	14	4	358	3	epimerases
erases	6	44	2540	3	___erases
eserines	8	4	1374	3	es_erines
esperances	14	4	625	3	esperances
estates	7	45	2018	3	est__ates
esterifies	13	4	715	3	esterifies
esters	6	46	2773	3	ester___s
estheses	11	3	778	3	est_heses
esthesises	13	4	481	3	esthesises
estimates	11	9	1136	3	estimates
estivates	12	10	975	3	estivates
estranges	10	35	998	3	est_ranges
estrayed	12	3	639	3	est_rayed
estrays	10	52	940	3	est_ra_ys
estreated	10	3	955	3	estreated
estreats	8	3	942	3	estrea_ts
estrones	8	3	1332	3	est_rones
estuaries	9	4	621	3	estuaries
eternises	9	11	945	3	e_ternises
externes	15	3	983	3	exter_nes
fosterages	14	4	477	3	fosterages
heteroses	12	4	1078	3	heteroses
hystereses	16	4	380	3	hystereses
icteruses	11	4	497	3	icteruses
isomerases	12	4	410	3	isomerases
iterates	8	13	1782	3	_iterates
literates	9	14	1565	3	literates
mesmerises	14	4	582	3	mesmerises
meterages	12	4	818	3	meterages
notecases	11	4	517	3	notecases
oestruses	9	4	640	3	oest_ruses
osteoses	8	3	903	3	oste_oses
reiterates	10	4	1200	3	reiterates
restresses	10	4	931	3	restresses
serapes	9	52	1810	3	_s_erapes
sesterces	11	4	787	3	sester_ces
sewerages	13	4	536	3	sewerages
stases	6	42	2556	3	_st__ases
stearates	9	3	945	3	_stearates
steerages	10	4	649	3	_steerages
stenoses	8	3	1044	3	_stenoses
steres	6	39	2953	3	_ster__es
storages	9	3	1110	3	_storages
storaxes	15	3	688	3	_storaxes
strafes	10	45	1600	3	_st_rafes
strakes	11	42	1807	3	_st_rakes
strass	6	71	1722	3	_st_ras_s
strasses	8	13	1144	3	_st_rasses
stresses	8	11	1249	3	_stresses
styraxes	18	3	349	3	_styraxes
sucrases	10	3	1025	3	_sucrases
teases	6	54	2627	3	__te_ases
terrases	8	21	1148	3	__terrases
texases	14	3	757	3	__texases
uteruses	8	3	718	3	_uteruses
waterages	13	4	938	3	waterages
westerlies	13	4	561	3	westerlies
westernises	14	4	420	3	westernises
yestereves	16	4	247	3	yestereves

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	148641	0.406	440125.6
2	DLD Change Limit	148641	72	7.983	18619.7
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	8.422	21217.2