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

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

218 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
perforation	16	4	900	(None)
perforations	17	4	787	1	perforations
peroration	12	3	1600	1	per_oration
percolation	15	4	922	2	percolation
perforating	17	4	702	2	perforating
perforator	15	4	544	2	perforat_or
perorations	13	3	1406	2	per_orations
personation	13	4	948	2	personation
preformation	19	4	647	2	preformation
proration	11	4	1598	2	p_r_oration
cerebration	15	4	792	3	cerebration
corporation	15	12	1065	3	corporation
decoration	13	3	1442	3	de_coration
defloration	15	4	726	3	defloration
deformation	17	4	766	3	de_formation
derogation	12	4	1039	3	der_ogation
melioration	13	6	818	3	melioration
mercuration	15	4	749	3	mercuration
penetration	13	4	989	3	penetration
percolations	16	4	805	3	percolations
perennation	13	4	808	3	perennation
perfection	17	4	836	3	perf_ection
perforate	14	5	946	3	perforat__e
perforated	16	5	689	3	perforat_ed
perforates	15	5	886	3	perforat_es
perforators	16	4	485	3	perforators
performative	22	10	387	3	performative
permeation	14	4	1056	3	per_meation
permutation	15	4	747	3	permutation
perorating	13	3	1313	3	per_orating
perorational	14	4	639	3	per_orational
perorator	11	4	974	3	per_orat_or
perpetration	16	4	713	3	perpetration
personations	14	4	839	3	personations
perspiration	16	5	683	3	perspiration
perturbation	16	12	354	3	perturbation
preformations	20	4	571	3	preformations
preparation	15	4	927	3	preparation
preportion	14	4	887	3	prepor_tion
probation	13	4	1218	3	p_r_obation
pronation	11	4	1570	3	p_r_onation
prorations	12	3	1446	3	p_r_orations
reformation	16	4	841	3	re_formation
restoration	11	4	1209	3	restoration
serration	9	4	1407	3	ser__ration
aberration	12	6	720	4	aber__ration
abrogation	13	10	733	4	abr_ogation
adoration	10	3	1131	4	__adoration
aeration	8	3	1993	4	ae___ration
amelioration	14	6	400	4	amelioration
approbation	17	5	502	4	appr_obation
arrogation	11	10	744	4	_arrogation
carbonation	15	4	585	4	carbonation
celebration	15	4	646	4	celebration
cerebrations	16	4	696	4	cerebrations
coloration	12	9	1318	4	_coloration
conformation	19	4	732	4	conformation
coronation	12	4	1207	4	cor_onation
corotation	12	4	1097	4	cor_otation
corporations	16	12	948	4	corporations
deaeration	11	3	1301	4	de_aeration
declaration	14	4	783	4	declaration
decorations	14	3	1288	4	de_corations
defamation	16	4	684	4	de_famation
defecation	16	7	980	4	de_fecation
deflation	13	3	1065	4	de_f_lation
deflorations	16	4	606	4	deflorations
defoliation	15	4	831	4	de_foliation
deformations	18	4	684	4	de_formations
dehydration	19	5	406	4	dehydration
deification	17	4	1166	4	deification
denigration	13	4	846	4	denigration
denotation	11	3	1108	4	de_notation
deportation	14	4	930	4	de_portation
derivation	14	7	1278	4	der_ivation
derogations	13	4	939	4	der_ogations
desecration	14	4	1007	4	desecration
desolation	11	3	1140	4	de_solation
desorption	13	4	622	4	de_sorption
desperation	14	5	1011	4	desperation
deterioration	14	14	528	4	deterioration
detonation	11	3	1094	4	de_tonation
deuteration	12	4	910	4	deuteration
elaboration	13	4	574	4	elaboration
emigration	13	22	821	4	_emigration
eructation	12	4	833	4	_eructation
etiolation	10	4	853	4	_etiolation
evaporation	16	4	555	4	evaporation
evocation	14	20	1029	4	_e_vocation
excoriation	20	4	843	4	_excoriation
execration	19	4	983	4	_execration
exfoliation	21	4	525	4	_exfoliation
exhortation	21	4	502	4	_exhortation
expectoration	24	5	256	4	expectoration
expiration	19	6	1071	4	_expiration
exploration	20	6	671	4	exploration
exportation	20	4	744	4	_exportation
extortion	16	4	672	4	_extor_tion
federation	14	4	957	4	fe_deration
formation	14	3	942	4	___formation
generation	11	3	1242	4	ge_neration
germination	14	14	897	4	germination
herniation	13	4	844	4	her_niation
impersonation	17	6	422	4	impersonation
information	16	14	771	4	_information
malformation	19	5	332	4	malformation
meliorations	14	6	675	4	meliorations
mensuration	13	4	649	4	mensuration
mercurations	16	4	656	4	mercurations
narration	9	3	1006	4	nar__ration
nervation	12	6	1024	4	ner__vation
operation	11	3	1400	4	ope___ration
oration	7	16	1771	4	____oration
parturition	13	5	417	4	parturition
pectination	15	4	1033	4	pectination
peculation	14	3	1199	4	pe_culation
pejorative	22	4	569	4	pe_jorative
peltation	11	3	1296	4	pe__ltation
penetrations	14	4	885	4	penetrations
perborate	13	5	1014	4	perborat__e
perborates	14	5	921	4	perborat_es
perception	16	8	861	4	per_ception
percolating	16	5	732	4	percolating
percolator	14	4	591	4	percolat_or
perdition	12	4	901	4	per__dition
peregrination	16	12	520	4	peregrination
perennations	14	4	725	4	perennations
perfections	18	4	814	4	perf_ections
performatives	23	9	268	4	performatives
performatory	22	5	258	4	performatory
performing	18	4	494	4	perfor_ming
perfusion	14	10	588	4	perf__usion
periodization	25	5	606	4	periodization
permeations	15	4	988	4	per_meations
permutations	16	4	650	4	permutations
perorate	10	4	1792	4	per_orat__e
perorated	12	4	1246	4	per_orat_ed
perorates	11	4	1702	4	per_orat_es
perorators	12	4	935	4	per_orators
perpetrations	17	4	637	4	perpetrations
perpetuation	16	5	534	4	perpetuation
persecution	15	6	478	4	persecution
perseveration	18	5	380	4	perseveration
personating	14	4	767	4	personating
personative	16	4	707	4	personative
personator	12	4	585	4	personat_or
perspirations	17	8	617	4	perspirations
persuasion	12	9	419	4	per_suasion
perturbations	17	12	326	4	perturbations
pervasion	14	4	607	4	per__vasion
perversion	15	4	585	4	perver_sion
petrification	20	4	881	4	petrification
phonation	14	3	939	4	p__honation
portion	9	6	1549	4	p___or_tion
potation	10	17	1678	4	p___otation
predation	12	3	1346	4	p_r_edation
predication	16	4	1243	4	predication
prefiguration	19	5	345	4	prefiguration
prelibation	15	12	866	4	prelibation
premigration	17	5	569	4	premigration
premonition	15	4	735	4	premonition
prenotion	11	4	917	4	preno__tion
preoption	13	4	808	4	p_reo_ption
preparations	16	4	831	4	preparations
preportions	15	4	826	4	prepor_tions
preposition	15	10	858	4	preposition
preservation	17	7	628	4	preservation
privation	14	3	1117	4	p_r_ivation
proaction	13	4	1010	4	p_r_oaction
probations	14	3	1108	4	p_r_obations
procreation	15	4	795	4	p_rocreation
procuration	15	4	829	4	procuration
profanation	16	18	610	4	profanation
promotion	13	5	950	4	p_r_omotion
pronations	12	3	1403	4	p_r_onations
proportion	14	4	899	4	propor_tion
prorating	12	3	1428	4	p_r_orating
prorogation	14	4	739	4	prorogation
prostration	13	4	1079	4	prostration
protonation	13	5	1043	4	protonation
protraction	15	4	721	4	p_rotraction
provocation	18	4	735	4	provocation
purgation	12	4	739	4	pur__gation
purification	19	4	817	4	purification
recordation	14	4	926	4	re_cordation
redecoration	15	4	601	4	redecoration
reflation	12	4	1233	4	re_f_lation
reformations	17	4	760	4	re_formations
refraction	15	13	790	4	re_f_raction
refutation	13	4	991	4	re_futation
rehydration	18	4	464	4	rehydration
reification	16	4	1290	4	reification
reiteration	11	4	1216	4	reiteration
relocation	12	3	1211	4	re_location
remigration	14	22	891	4	remigration
renovation	13	5	878	4	re_novation
reoperation	13	4	1090	4	reoperation
reparation	12	6	1272	4	re_paration
reprobation	15	4	850	4	reprobation
reradiation	12	4	1015	4	reradiation
resorption	12	4	725	4	re_sorption
respiration	13	5	1119	4	respiration
restorations	12	4	1095	4	restorations
retortion	9	4	967	4	re_tor_tion
revocation	15	4	1081	4	re_vocation
rogation	9	16	1205	4	__r_ogation
rotation	8	16	1545	4	__r_otation
separation	12	5	1043	4	se_paration
seriation	9	3	1806	4	ser__iation
serrations	10	3	1310	4	ser__rations
suffocation	19	5	337	4	suffocation
sulfonation	14	4	426	4	sulfonation
superfetation	18	5	522	4	superfetation
termination	13	13	1116	4	termination
terrorization	22	5	666	4	terrorization
veneration	13	4	1234	4	ve_neration
verification	20	18	1064	4	verification
vernation	12	3	1108	4	ver__nation

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.423	422437.4
2	DLD Change Limit	148819	218	8.686	17133.2
3	Display Results	218	218	0.126	1730.2
	(SQL Overall)	178691	218	9.235	19349.3