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

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

56 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
perpetrators	16	5	338	(None)
perpetrator	15	5	363	1	perpetrator_
perpetuators	16	5	266	1	perpetuators
perpetrates	15	6	619	2	perpetrat_es
perpetrations	17	4	635	2	perpetrations
perpetuator	15	5	272	2	perpetuator_
perforators	16	4	485	3	per_forators
permeators	14	4	740	3	perme__ators
perorators	12	4	934	3	per__orators
perpetrate	14	7	663	3	perpetrat__e
perpetrated	16	7	506	3	perpetrat_ed
perpetrating	17	4	520	3	perpetrating
perpetration	16	4	712	3	perpetration
perpetuates	15	8	429	3	perpetuat_es
perpetuations	17	5	497	3	perpetuations
preparators	15	5	472	3	prep_arators
arbitrators	13	5	421	4	_arbitrators
celebrators	15	4	439	4	ce_lebrators
cooperators	15	4	699	4	coope_rators
corporators	15	4	665	4	corp_orators
deaerators	11	10	771	4	de_ae_rators
depreciators	17	5	390	4	depreciators
depredators	15	4	373	4	depre_dators
depurators	13	4	647	4	de_p_urators
desecrators	14	4	523	4	de_secrators
execrators	19	4	602	4	_e_xecrators
federators	14	4	619	4	fe_de_rators
generators	11	4	753	4	ge_ne_rators
imperators	14	4	771	4	_impe_rators
operators	11	4	1075	4	__ope_rators
penetrates	12	4	871	4	pe_netrat_es
penetrations	14	4	884	4	pe_netrations
percolators	15	4	536	4	per_colators
perforator	15	4	544	4	per_forator_
permeator	13	4	740	4	perme__ator_
perorator	11	4	974	4	per__orator_
perpetuals	14	5	345	4	perpetua__ls
perpetuate	14	5	477	4	perpetuat__e
perpetuated	16	5	374	4	perpetuat_ed
perpetuating	17	5	380	4	perpetuating
perpetuation	16	5	534	4	perpetuation
perpetuities	16	5	347	4	perpetuities
persecutors	15	5	315	4	perse_cutors
personators	13	4	554	4	per_sonators
perspiratory	19	5	296	4	perspiratory
perverters	15	4	494	4	perve_r_ters
predators	12	3	1007	4	p_r_e_dators
preparator	14	4	524	4	prep_arator_
preparatory	18	5	377	4	prep_aratory
procurators	15	4	516	4	p_rocurators
propitiators	16	5	396	4	propitiators
protractors	15	4	659	4	p_r_otractors
respirators	13	7	544	4	resp_irators
retractors	12	15	857	4	__r_etractors
separators	12	4	650	4	se_p_arators
venerators	13	4	705	4	ve_ne_rators

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	56	7.640	16333.8
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	7.813	22871.0