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

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

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.

85 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
affirmations	20	5	323	(None)
affirmation	19	5	368	1	affirmation_
affiliations	18	4	418	2	affiliations
affirmatives	23	5	215	2	affirmatives
affixations	24	4	385	2	affi_xations
reaffirmations	22	5	197	2	reaffirmations
admirations	14	4	669	3	admir_ations
affectations	20	4	343	3	affectations
affiliation	17	4	485	3	affiliation_
affirmative	22	5	309	3	affirmati_ve
affixation	23	4	439	3	affi_xation_
animations	12	3	1219	3	a_ni_mations
aspirations	13	4	899	3	aspir_ations
confirmations	20	5	567	3	confirmations
deformations	18	4	684	3	deformations
flirtations	14	10	426	3	_flirtations
formations	15	3	820	3	__formations
informations	17	12	703	3	informations
malformations	20	5	307	3	malformations
officiations	20	5	350	3	officiations
reaffirmation	21	5	206	3	reaffirmation_
reformations	17	4	760	3	reformations
abdications	16	5	765	4	abdi_cations
aberrations	13	4	669	4	a_berrations
abjurations	20	4	514	4	abjur_ations
acclamations	18	16	404	4	acclamations
acclimations	18	14	629	4	acclimations
activations	16	6	926	4	acti_vations
adjurations	19	4	482	4	adjur_ations
admiration	13	4	773	4	admir_ation_
adorations	11	3	1023	4	a_dor_ations
aerations	9	3	1790	4	a__er_ations
affectation	19	4	384	4	affectation_
affections	18	4	589	4	aff__ections
affiliating	18	4	417	4	affiliati_ng
affirmances	21	5	260	4	affirma_nces
affirmant	17	5	381	4	affirma___nt
affirmants	18	5	276	4	affirma__nts
affirmatively	27	6	181	4	affirmatively
affirming	18	4	310	4	affirm__i_ng
afflictions	19	4	340	4	aff_lictions
afforestations	20	6	224	4	afforestations
affricating	20	4	396	4	affricati_ng
affricatives	23	5	197	4	affricatives
agitations	11	3	1006	4	a_gi_tations
alienations	11	4	788	4	a_lienations
alterations	11	5	1166	4	alter_ations
altercations	14	4	637	4	altercations
alternations	12	4	677	4	alternations
animation	11	3	1368	4	a_ni_mation_
antiquations	21	4	624	4	antiquations
arbitrations	14	4	576	4	arbitrations
aspiration	12	4	999	4	aspir_ation_
assignations	13	4	416	4	assignations
automations	13	4	823	4	a_utomations
aviations	12	3	1155	4	a_vi__ations
bifurcations	19	8	293	4	bifurcations
chrismations	19	5	304	4	chrismations
confirmation	19	4	618	4	confirmation_
conformations	20	4	672	4	conformations
decimations	16	4	1016	4	deci_mations
defamations	17	4	589	4	def_amations
deformation	17	4	766	4	deformation_
estimations	13	4	994	4	esti_mations
expirations	20	6	958	4	expir_ations
extirpations	21	7	428	4	extirpations
fabrications	19	4	592	4	fabrications
filiations	13	11	909	4	__filiations
fixations	19	3	635	4	__fi_xations
flirtation	13	5	482	4	_flirtation_
flirtatious	14	6	165	4	_flirtatious
floriations	14	7	691	4	_floriations
formation	14	3	942	4	__formation_
furcations	15	4	753	4	__furcations
himations	14	3	880	4	__hi_mations
infixations	21	4	669	4	infi_xations
information	16	14	771	4	information_
infuriations	15	4	744	4	infuriations
intimations	13	4	1188	4	inti_mations
lacrimations	16	4	570	4	lacri_mations
malformation	19	5	332	4	malformation_
officiation	19	4	383	4	officiation_
preformations	20	4	571	4	preformations
reformation	16	4	841	4	reformation_
suffixations	25	6	254	4	suffi_xations

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	124790	0.403	443402.0
2	DLD Change Limit	124790	85	6.923	18025.4
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	7.372	24239.1