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

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

53 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
filtrations	14	4	562	(None)
filtration	13	4	643	1	filtration_
figurations	15	4	508	2	figurations
filiations	13	11	909	2	fil_iations
filtrating	14	4	597	2	filtrati_ng
flirtations	14	10	426	2	flirtations
infiltrations	16	5	390	2	infiltrations
nitrations	10	3	1203	2	ni_trations
siltations	10	3	855	2	silt_ations
titrations	10	3	917	2	ti_trations
alterations	11	5	1166	3	_alterations
bilocations	15	4	529	3	bilocations
castrations	13	4	1005	3	castrations
ciliations	12	11	1100	3	cil_iations
citations	11	3	1250	3	ci_t_ations
colorations	13	9	1189	3	colorations
dictations	13	8	970	3	dict_ations
dilatations	12	4	641	3	dilatations
dilations	10	26	1445	3	dil__ations
distractions	15	4	875	3	distractions
federations	15	4	888	3	federations
fellations	13	3	806	3	fel_lations
fetations	12	5	1138	3	f_et_ations
figuration	14	4	591	3	figuration_
filiation	12	11	1024	3	fil_iation_
filtrates	12	4	773	3	filtrat__es
fimbriations	19	4	334	3	fimbriations
fixations	19	3	635	3	fi__xations
flirtation	13	5	482	3	flirtation_
flirtatious	14	6	165	3	flirtatious
floriations	14	7	691	3	f_loriations
flotations	13	6	687	3	f_lotations
foliations	13	9	994	3	fol_iations
frustrations	15	4	453	3	frustrations
fulgurations	16	9	279	3	fulgurations
illations	9	3	1139	3	_il_lations
infiltration	15	5	452	3	infiltration_
iterations	10	4	1382	3	_iterations
liberations	13	5	894	3	liberations
librations	12	14	906	3	li_brations
literations	11	6	1058	3	literations
lustrations	11	4	762	3	lustrations
migrations	13	16	868	3	mi_grations
nictations	12	7	831	3	nict_ations
nitration	9	3	1344	3	ni_tration_
peltations	12	3	1155	3	pelt_ations
saltations	10	3	1062	3	salt_ations
siltation	9	3	921	3	silt_ation_
situations	10	3	843	3	si_tuations
titration	9	3	1054	3	ti_tration_
tolerations	11	5	813	3	tolerations
vibrations	15	15	737	3	vi_brations
vitiations	13	3	874	3	vi_tiations

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	121633	0.140	1276364.3
2	DLD Change Limit	121633	53	8.500	14309.8
3	Display Results	53	53	0.046	1152.2
	(SQL Overall)	178691	53	8.686	20572.3