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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

145 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
exfoliations	22	4	478	(None)
exfoliation	21	4	525	1	exfoliation_
defoliations	16	4	758	2	defoliations
excoriations	21	4	749	2	excoriations
exfoliating	22	4	338	2	exfoliati_ng
foliations	13	9	994	2	__foliations
affiliations	18	4	418	3	affiliations
defoliation	15	4	831	3	defoliation_
despoliations	16	4	638	3	despoliations
embolizations	26	4	672	3	embolizations
etiolations	11	4	738	3	etiol_ations
exaltations	18	4	729	3	ex_altations
excogitations	23	5	381	3	excogitations
excoriation	20	4	842	3	excoriation_
exculpations	23	4	417	3	exculpations
exfoliates	20	6	370	3	exfoliat__es
exfoliative	24	5	248	3	exfoliati_ve
exhalations	21	4	601	3	exhal_ations
exhortations	22	4	444	3	exhortations
expatiations	21	4	613	3	expatiations
expiations	19	5	966	3	ex__piations
explications	23	4	753	3	ex_plications
exploitations	22	5	421	3	exploitations
explorations	21	8	560	3	explorations
exportations	21	4	664	3	exportations
expositions	20	4	682	3	exposi_tions
exsolutions	18	4	401	3	exsol_utions
exultations	18	4	652	3	ex_ultations
exuviations	21	9	569	3	ex_uviations
filiations	13	11	909	3	__filiations
foliation	12	11	1079	3	__foliation_
spoliations	13	4	769	3	_spoliations
abolitions	12	4	665	4	_aboli_tions
affiliation	17	4	485	4	affiliation_
afflictions	19	4	340	4	_afflictions
aldolizations	23	4	633	4	aldolizations
ammoniations	16	4	541	4	ammoniations
associations	14	4	574	4	associations
bloviations	16	4	375	4	_bloviations
ciliations	12	11	1099	4	__ciliations
collations	12	3	1284	4	__collations
creolizations	24	5	788	4	creolizations
decollations	15	4	735	4	decollations
defalcations	18	4	519	4	defalcations
deflations	14	3	971	4	def_l_ations
deflorations	16	4	605	4	deflorations
defoliating	16	4	582	4	defoliati_ng
defoliators	15	4	372	4	defoliat_ors
deformations	18	4	682	4	deformations
demolitions	14	4	652	4	demoli_tions
desolations	12	3	1057	4	desol_ations
despoliation	15	4	670	4	despoliation_
ebullitions	13	5	236	4	ebulli_tions
echolocations	20	5	260	4	echolocations
elations	8	37	1912	4	e___l_ations
elongations	12	4	466	4	e_longations
elutriations	12	4	602	4	elutriations
eluviations	14	11	579	4	e_luviations
emaciations	15	4	815	4	e_maciations
embolization	25	4	741	4	embolization_
emulations	12	3	1094	4	e_mul_ations
enucleations	14	4	410	4	enucleations
enunciations	14	4	509	4	enunciations
epilations	12	3	1171	4	e_pil_ations
epoxidations	22	4	364	4	e_poxidations
equalizations	31	4	904	4	equalizations
erotizations	21	4	1099	4	e_rotizations
escalations	13	4	766	4	escal_ations
etiolation	10	4	853	4	etiol_ation_
evaluations	14	5	732	4	e_valuations
evocations	15	25	987	4	e_vo_cations
evolutions	13	10	704	4	e_vol_utions
exaltation	17	4	849	4	ex_altation_
examinations	21	6	746	4	examinations
excavations	23	4	508	4	ex_cavations
excitations	20	4	900	4	ex_citations
exclamations	23	10	410	4	exclamations
excogitation	22	5	418	4	excogitation_
excoriating	21	4	547	4	excoriati_ng
excruciations	24	11	298	4	excruciations
exculpation	22	4	487	4	exculpation_
execrations	20	4	890	4	ex_ecrations
exercitations	22	5	455	4	exercitations
exfoliant	19	5	310	4	exfolia___nt
exfoliants	20	5	200	4	exfolia__nts
exfoliate	19	5	413	4	exfoliat___e
exfoliated	21	6	339	4	exfoliat__ed
exhalation	20	4	665	4	exhal_ation_
exhibitions	23	5	365	4	exhibi_tions
exhilarations	23	5	241	4	exhilarations
exhortation	21	4	502	4	exhortation_
exhumations	23	4	408	4	ex_humations
exonerations	19	4	700	4	exonerations
expatiation	20	4	683	4	expatiation_
expatriations	22	5	376	4	expatriations
expectations	23	6	583	4	expectations
expeditions	21	4	463	4	expedi_tions
expiation	18	7	1042	4	ex__piation_
expirations	20	6	958	4	ex_pirations
explanations	21	4	462	4	explanations
explication	22	4	845	4	ex_plication_
exploitation	21	5	470	4	exploitation_
exploration	20	6	671	4	exploration_
exportation	20	4	744	4	exportation_
exposition	19	4	714	4	exposi_tion_
expropriations	25	5	332	4	expropriations
expurgations	22	7	412	4	expurgations
exsiccations	23	4	326	4	exsiccations
exsolution	17	4	376	4	exsol_ution_
extenuations	19	4	507	4	extenuations
extirpations	21	7	428	4	extirpations
extortions	17	4	646	4	exto__rtions
extrications	21	4	904	4	extrications
exudations	18	10	707	4	ex__udations
exultation	17	4	753	4	ex_ultation_
exuviation	20	11	634	4	ex_uviation_
fellations	13	3	806	4	__fellations
filiation	12	11	1024	4	__filiation_
floriations	14	7	689	4	_floriations
flotations	13	6	687	4	__flotations
foliating	13	3	925	4	__foliati_ng
formations	15	3	819	4	__formations
humiliations	17	8	455	4	humiliations
idolizations	22	4	744	4	_idolizations
immolations	15	4	546	4	immol_ations
inflations	13	3	1032	4	inf_l_ations
inflictions	16	4	544	4	inf_lictions
informations	17	12	703	4	informations
infuriations	15	4	744	4	infuriations
insolations	11	4	918	4	insol_ations
isolations	10	3	1068	4	_isol_ations
negotiations	13	4	515	4	negotiations
officiations	20	5	350	4	officiations
palliations	13	4	772	4	_palliations
percolations	16	4	802	4	percol_ations
perforations	17	4	784	4	perfo_rations
reflations	13	3	1123	4	ref_l_ations
reformations	17	4	759	4	reformations
retaliations	12	5	1140	4	retaliations
sexploitations	23	5	271	4	sexploitations
solations	9	8	1462	4	__sol_ations
solvations	13	3	683	4	__solvations
spoliation	12	4	842	4	_spoliation_
violations	13	3	796	4	_viol_ations
volitions	12	8	866	4	__voli_tions

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	124790	0.156	1145455.1
2	DLD Change Limit	124790	145	8.173	15268.6
3	Display Results	145	145	0.076	1907.9
	(SQL Overall)	178691	145	8.405	21260.1