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

Here are the results of your fuzzy-string dictionary search for “perpetrations” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

110 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
perpetrations	17	4	637	(None)
perpetration	16	4	713	1	perpetration_
perpetuations	17	5	498	1	perpetuations
penetrations	14	4	885	2	pe_netrations
perpetrating	17	4	520	2	perpetrati_ng
perpetrators	16	5	339	2	perpetrat_ors
perpetuation	16	5	534	2	perpetuation_
cerebrations	16	4	696	3	cer_ebrations
desperations	15	5	952	3	despe_rations
impetrations	16	4	544	3	_impetrations
penetration	13	4	989	3	pe_netration_
perennations	14	4	725	3	per_ennations
perforations	17	4	787	3	per_forations
permeations	15	4	988	3	perme__ations
permutations	16	4	650	3	permut_ations
perorations	13	3	1406	3	per__orations
perpetrates	15	6	620	3	perpetrat__es
perpetrator	15	5	364	3	perpetrat_o_r
perpetuating	17	5	380	3	perpetuati_ng
perpetuators	16	5	266	3	perpetuat_ors
perseverations	19	5	324	3	perseverations
perspirations	17	8	617	3	perspirations
preparations	16	4	831	3	prep_arations
prostrations	14	4	976	3	p_rostrations
reoperations	14	4	1006	3	reope_rations
arbitrations	14	4	576	4	_arbitrations
celebrations	16	4	574	4	ce_lebrations
cerebration	15	4	792	4	cer_ebration_
cooperations	16	5	919	4	coope_rations
corporations	16	12	948	4	corp_orations
crepitations	16	4	747	4	crepit_ations
deaerations	12	3	1167	4	de_ae_rations
deportations	15	4	846	4	de_portations
deprecations	17	4	856	4	depre_cations
depreciations	18	4	657	4	depreciations
depredations	16	4	673	4	depre_dations
deputations	14	4	834	4	de_put_ations
desecrations	15	5	921	4	de_secrations
desperation	14	5	1011	4	despe_ration_
deuterations	13	4	808	4	deute_rations
eructations	13	4	723	4	_eruct_ations
execrations	20	4	892	4	_e_xecrations
expatiations	21	4	613	4	_expatiations
expatriations	22	5	376	4	_expatriations
expectations	23	6	584	4	_expectations
expectorations	25	5	219	4	_expectorations
expirations	20	6	958	4	_exp_irations
explorations	21	8	561	4	_explorations
exportations	21	4	665	4	_exportations
federations	15	4	888	4	fe_de_rations
fenestrations	16	9	540	4	fenestrations
fermentations	18	5	627	4	fermentations
frustrations	15	4	453	4	_frustrations
generations	12	3	1142	4	ge_ne_rations
hebetations	16	5	646	4	he_bet_ations
impetration	15	4	590	4	_impetration_
mercurations	16	4	656	4	mer_curations
operations	12	3	1295	4	__ope_rations
palpitations	16	4	552	4	palpit_ations
pelletizations	25	10	503	4	pelletizations
peltations	12	3	1155	4	pe__lt_ations
penetrating	14	4	766	4	pe_netrati_ng
perceptions	17	9	819	4	perce__ptions
percolations	16	4	805	4	per_colations
peregrinations	17	11	468	4	per_egrinations
perennation	13	4	808	4	per_ennation_
perfections	18	4	814	4	perfe__ctions
perforation	16	4	900	4	per_foration_
permeation	14	4	1056	4	perme__ation_
permutation	15	4	747	4	permut_ation_
peroration	12	3	1600	4	per__oration_
perpetrate	14	7	665	4	perpetrat___e
perpetrated	16	7	507	4	perpetrat__ed
perpetuates	15	8	430	4	perpetuat__es
perpetuator	15	5	272	4	perpetuat_o_r
perpetuities	16	5	347	4	perpetuiti_es
persecutions	16	5	479	4	perse_cutions
perseveration	18	5	380	4	perseveration_
personations	14	4	839	4	per_sonations
perspiration	16	5	683	4	perspiration_
perturbations	17	12	326	4	perturbations
perversions	16	4	541	4	perve_r_sions
predations	13	8	1215	4	p_r_e_dations
preparation	15	4	927	4	prep_aration_
preportions	15	4	826	4	prep_or_tions
presentations	15	4	813	4	presentations
preservations	18	9	554	4	preservations
pretrains	11	4	1014	4	p_r_etra_i_ns
procurations	16	4	740	4	p_rocurations
propitiations	17	5	620	4	propitiations
prorations	12	3	1446	4	p_r__orations
prostration	13	4	1079	4	p_rostration_
protractions	16	4	664	4	p_r_otractions
recuperations	17	4	608	4	recupe_rations
registrations	14	4	689	4	registrations
reiterations	12	4	1087	4	reite_rations
reoperation	13	4	1090	4	reope_ration_
reparations	13	6	1166	4	re_p_arations
repatriations	15	13	651	4	re_patriations
repetitions	13	7	802	4	re_pet_itions
reputations	13	4	1073	4	re_put_ations
respirations	14	4	1030	4	resp_irations
retractions	13	9	1035	4	__r_etractions
separations	13	6	927	4	se_p_arations
sequestrations	23	18	299	4	sequestrations
serrations	10	3	1309	4	ser___rations
superfetations	19	7	506	4	superfet_ations
temptations	15	4	541	4	temp_t_ations
vegetations	15	4	732	4	ve_get_ations
venerations	14	4	1131	4	ve_ne_rations

Search took 6 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	95024	0.343	520965.0
2	DLD Change Limit	95024	110	4.920	19313.8
3	Display Results	110	110	0.080	1375.0
	(SQL Overall)	178691	110	5.343	33443.9