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

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

79 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
substitutes	13	5	432	(None)
substitute	12	5	460	1	substitute_
substituted	14	5	342	1	substituted
constitutes	13	7	615	3	constitutes
destitutes	11	5	651	3	_destitutes
disubstituted	17	5	116	3	disubstituted
institutes	10	4	604	3	_institutes
prostitutes	13	4	516	3	prostitutes
restitutes	10	5	782	3	_restitutes
subseizures	22	5	156	3	subseizures
subsites	10	3	1276	3	subs_i__tes
substates	11	14	1031	3	subs__tates
substituent	13	5	327	3	substituent
substituents	14	6	220	3	substituents
substituting	15	5	323	3	substituting
substitution	14	5	331	3	substitution
substitutions	15	5	327	3	substitutions
substitutive	17	6	234	3	substitutive
substrates	12	16	854	3	subst_rates
subtitles	11	5	682	3	sub_tit_les
busticates	14	5	660	4	bu_sticates
constitute	12	7	668	4	constitute_
constituted	14	7	504	4	constituted
destitute	10	4	687	4	_destitute_
destituted	12	5	524	4	_destituted
fustigates	14	4	514	4	fu_stigates
institute	9	4	643	4	_institute_
instituted	11	4	493	4	_instituted
instituter	10	4	450	4	_instituter
instituters	11	5	321	4	_instituters
multitudes	13	4	586	4	mu_ltitudes
prostitute	12	5	518	4	prostitute_
prostituted	14	5	399	4	prostituted
quantitates	20	5	330	4	quantitates
reinstitutes	12	5	325	4	reinstitutes
restitute	9	4	774	4	_restitute_
restituted	11	5	652	4	_restituted
rusticates	12	4	805	4	ru_sticates
statutes	8	36	889	4	___statutes
subcultures	15	5	458	4	subcultures
subcutes	12	3	857	4	sub___cutes
sublimates	14	4	715	4	sub_limates
submitted	14	4	520	4	sub_mit_ted
submitter	13	4	526	4	sub_mit_ter
submitters	14	4	443	4	sub_mit_ters
subprimates	17	5	344	4	subprimates
subsciences	17	6	436	4	subsciences
subseizure	21	5	176	4	subseizure_
subsides	11	4	1082	4	subs_i__des
subsidies	12	4	840	4	subs_i_dies
subsidises	13	4	511	4	subs_idises
subsidizes	22	4	507	4	subs_idizes
subsisted	12	4	576	4	subs_i_sted
subsister	11	4	597	4	subs_i_ster
subsisters	12	4	501	4	subs_i_sters
subsists	10	3	799	4	subs_i_st_s
subsite	9	4	1286	4	subs_i__te_
substages	12	12	735	4	subs__tages
substances	14	4	631	4	subst_ances
substantiates	15	7	337	4	substantiates
substantives	17	5	372	4	substantives
substate	10	17	1108	4	subs__tate_
substations	13	4	822	4	substations
substitutable	17	8	128	4	substitutable
substitutively	22	12	159	4	substitutively
substrate	11	17	878	4	subst_rate_
substratums	15	5	199	4	substratu_ms
substructures	17	6	286	4	substructures
subsumes	12	4	692	4	subs___umes
subtilities	13	4	783	4	sub_tilities
subtilizes	21	6	686	4	sub_tilizes
subtilties	12	4	609	4	sub_tilties
subtitle	10	4	658	4	sub_tit_le_
subtitled	12	4	469	4	sub_tit_led
subviruses	15	4	347	4	sub_viruses
surtitles	9	4	563	4	su_rtit_les
trisubstituted	17	7	56	4	~~tri~~substituted
unstitches	15	4	356	4	_unstitches
vastitudes	14	4	432	4	_vastitudes

Search took 10 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	148819	0.173	1032896.0
2	DLD Change Limit	148819	79	9.046	16451.4
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	9.249	19320.0