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

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

67 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
sustentation	12	5	500	(None)
sustentations	13	5	476	1	sustentations
ostentation	11	4	695	2	_ostentation
sustentative	15	13	310	2	sustentative
assentation	11	4	618	3	_assentation
augmentation	15	5	439	3	augmentation
ostentations	12	4	611	3	_ostentations
segmentation	15	5	600	3	segmentation
substantiation	16	7	313	3	substantiation
abstention	12	5	439	4	absten__tion
alimentation	14	10	533	4	alimentation
assentations	12	4	583	4	_assentations
attenuation	11	4	418	4	_attenuation
attestation	11	4	518	4	_attestation
augmentations	16	5	412	4	augmentations
auscultation	14	5	347	4	auscultation
catenation	12	4	952	4	_caten_ation
cementation	15	5	970	4	_cementation
contestation	14	4	866	4	contestation
dentation	10	3	1524	4	___dentation
destination	12	4	1384	4	destin_ation
detestation	12	4	836	4	_detestation
dispensation	15	5	560	4	dispensation
dissertation	13	6	609	4	dissertation
distention	11	15	887	4	disten__tion
extenuation	18	4	518	4	_extenuation
fermentation	17	5	682	4	fermentation
fomentation	16	4	771	4	_fomentation
fustigation	15	4	521	4	fust_igation
gustation	10	4	796	4	gus___tation
guttation	10	4	617	4	gu_t__tation
indentation	12	4	837	4	_indentation
instantiation	13	13	405	4	instantiation
lamentation	13	10	657	4	_lamentation
lustration	10	4	835	4	lust__ration
mentation	11	3	1398	4	___mentation
multination	13	4	897	4	multin_ation
orientation	11	4	757	4	_orientation
ostentatious	12	5	286	4	_ostentatious
outstation	10	4	616	4	ou_t_station
pigmentation	17	5	448	4	pigmentation
placentation	16	9	415	4	placentation
potentiation	14	5	596	4	_potentiation
presentation	14	4	899	4	presentation
protestation	14	5	635	4	protestation
pustulation	13	11	662	4	pust_ulation
rustication	13	4	922	4	rust_ication
sedimentation	16	5	483	4	sedimentation
segmentations	16	5	559	4	segmentations
sensation	9	5	1058	4	__s_ensation
septentrion	13	9	230	4	septent_rion
sternutation	12	5	396	4	__sternutation
subgeneration	16	5	260	4	subgeneration
subornation	13	4	649	4	suborn_ation
substantiations	17	7	277	4	substantiations
substation	12	4	898	4	su__bstation
substitution	14	5	332	4	subst_itution
subvention	15	7	467	4	subven__tion
sulfonation	14	4	426	4	sulfon_ation
supernation	13	4	1166	4	su_pernation
superstation	14	16	862	4	superstation
supination	12	4	988	4	su_pin_ation
supplantation	17	6	266	4	supplantation
suspension	12	5	380	4	suspen__sion
suspiration	13	4	654	4	sus_piration
susurration	11	4	479	4	sus_urration
systemization	27	7	444	4	systemization

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.140	1276364.3
2	DLD Change Limit	124790	67	7.593	16434.9
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	7.766	23009.4