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

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

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

109 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
peroration	12	3	1600	(None)
perforation	16	4	900	1	perforation
perorations	13	3	1406	1	perorations
proration	11	4	1598	1	p_roration
decoration	13	3	1442	2	decoration
derogation	12	4	1039	2	derogation
percolation	15	4	922	2	percolation
perforations	17	4	787	2	perforations
permeation	14	4	1056	2	permeation
perorating	13	3	1313	2	perorating
perorational	14	4	639	2	perorational
perorator	11	4	974	2	perorat_or
personation	13	4	948	2	personation
probation	13	4	1218	2	p_robation
pronation	11	4	1570	2	p_ronation
prorations	12	3	1446	2	p_rorations
serration	9	4	1407	2	ser_ration
aberration	12	6	720	3	aber_ration
abrogation	13	10	733	3	abrogation
adoration	10	3	1131	3	_adoration
aeration	8	3	1993	3	ae__ration
approbation	17	5	502	3	approbation
arrogation	11	10	744	3	arrogation
cerebration	15	4	792	3	cerebration
coloration	12	9	1318	3	coloration
coronation	12	4	1207	3	coronation
corotation	12	4	1097	3	corotation
corporation	15	12	1065	3	corporation
deaeration	11	3	1301	3	deaeration
decorations	14	3	1288	3	decorations
defloration	15	4	726	3	defloration
deformation	17	4	766	3	deformation
denotation	11	3	1108	3	denotation
deportation	14	4	930	3	deportation
derivation	14	7	1278	3	derivation
derogations	13	4	939	3	derogations
desolation	11	3	1140	3	desolation
desorption	13	4	622	3	desorption
detonation	11	3	1094	3	detonation
evocation	14	20	1029	3	_evocation
federation	14	4	957	3	federation
generation	11	3	1242	3	generation
herniation	13	4	844	3	herniation
melioration	13	6	818	3	melioration
mercuration	15	4	749	3	mercuration
narration	9	3	1006	3	nar_ration
nervation	12	6	1024	3	ner_vation
operation	11	3	1400	3	ope__ration
oration	7	16	1771	3	___oration
peculation	14	3	1199	3	peculation
pejorative	22	4	569	3	pejorative
peltation	11	3	1296	3	pe_ltation
penetration	13	4	989	3	penetration
perception	16	8	861	3	perception
percolations	16	4	805	3	percolations
perdition	12	4	901	3	per_dition
perennation	13	4	808	3	perennation
perfection	17	4	836	3	perfection
perforating	17	4	702	3	perforating
perforator	15	4	544	3	perforat_or
permeations	15	4	988	3	permeations
permutation	15	4	747	3	permutation
perorate	10	4	1792	3	perorat__e
perorated	12	4	1247	3	perorat_ed
perorates	11	4	1702	3	perorat_es
perorators	12	4	935	3	perorators
perpetration	16	4	713	3	perpetration
personations	14	4	839	3	personations
perspiration	16	5	683	3	perspiration
persuasion	12	9	419	3	persuasion
perturbation	16	12	354	3	perturbation
pervasion	14	4	607	3	per_vasion
phonation	14	3	939	3	p_honation
portion	9	6	1549	3	p__or_tion
potation	10	17	1678	3	p__otation
predation	12	3	1346	3	p_redation
preformation	19	4	647	3	preformation
preoption	13	4	808	3	preo_ption
preparation	15	4	927	3	preparation
preportion	14	4	887	3	prepor_tion
privation	14	3	1117	3	p_rivation
proaction	13	4	1010	3	p_roaction
probations	14	3	1108	3	p_robations
procreation	15	4	795	3	p_rocreation
procuration	15	4	829	3	p_rocuration
promotion	13	5	950	3	p_romotion
pronations	12	3	1403	3	p_ronations
prorating	12	3	1428	3	p_rorating
prorogation	14	4	739	3	prorogation
prostration	13	4	1079	3	p_rostration
protraction	15	4	721	3	p_rotraction
purgation	12	4	739	3	pur_gation
recordation	14	4	926	3	recordation
reformation	16	4	841	3	reformation
relocation	12	3	1211	3	relocation
renovation	13	5	878	3	renovation
reparation	12	6	1272	3	reparation
reprobation	15	4	850	3	reprobation
resorption	12	4	725	3	resorption
restoration	11	4	1209	3	restoration
retortion	9	4	967	3	retor_tion
revocation	15	4	1081	3	revocation
rogation	9	16	1205	3	__rogation
rotation	8	16	1545	3	__rotation
separation	12	5	1043	3	separation
seriation	9	3	1806	3	ser_iation
serrations	10	3	1310	3	ser_rations
veneration	13	4	1234	3	veneration
vernation	12	3	1108	3	ver_nation

Search took 9 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	140603	0.436	409841.7
2	DLD Change Limit	140603	109	7.516	18707.2
3	Display Results	109	109	0.046	2369.6
	(SQL Overall)	178691	109	7.998	22342.0