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

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

41 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
effectuated	20	5	199	(None)
effectuate	18	5	258	1	effectuate_
effectuates	19	5	253	1	effectuates
effected	17	4	499	3	effec___ted
effectual	17	5	276	3	effectua__l
effectually	22	5	265	3	effectually
effectuating	21	5	178	3	effectuating
effectuation	20	5	228	3	effectuation
eventuated	14	10	371	3	e_ventuated
fluctuated	16	4	249	3	_fluctuated
accentuated	16	5	270	4	accentuated
actuated	11	3	874	4	___actuated
affected	17	4	479	4	affec___ted
affectioned	20	5	245	4	affectioned
defecated	16	3	749	4	defec__ated
delectated	14	4	672	4	delect_ated
effecter	16	6	477	4	effec___ter
effective	20	7	619	4	effect_ive_
effectives	21	13	456	4	effect_ives
effectualities	22	6	220	4	effectualities
effectuality	23	8	231	4	effectuality
effectualness	21	7	193	4	effectualness
effectuations	21	5	195	4	effectuations
effeminate	18	5	297	4	effeminate_
effeminates	19	5	260	4	effeminates
eructated	12	4	564	4	e_ruct_ated
evacuated	15	19	626	4	e_vac_uated
eventuate	12	10	477	4	e_ventuate_
eventuates	13	9	418	4	e_ventuates
execrated	19	3	835	4	e_xec_rated
executed	18	3	550	4	e_xec_u_ted
expectorated	24	5	231	4	expectorated
extenuated	18	4	375	4	exte_nuated
fenestrated	15	5	424	4	fenestrated
fluctuate	14	4	311	4	_fluctuate_
fluctuates	15	4	307	4	_fluctuates
infatuated	14	4	392	4	inf_atuated
officiated	19	4	325	4	offic_iated
perpetuated	16	5	375	4	perpe_tuated
punctuated	15	4	337	4	_punctuated
spectated	14	23	659	4	_spect_ated

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.280	638182.1
2	DLD Change Limit	148819	41	9.330	15950.6
3	Display Results	41	41	0.030	1366.7
	(SQL Overall)	178691	41	9.640	18536.4