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

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

131 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
prorogation	14	4	739	(None)
prorogations	15	5	672	1	prorogations
arrogation	11	10	744	2	ar_rogation
prolongation	15	6	371	2	prolongation
propagation	16	4	644	2	propagation
proration	11	4	1598	2	pror__ation
prorogating	15	5	606	2	prorogating
protonation	13	5	1043	2	protonation
provocation	18	4	735	2	provocation
abrogation	13	10	733	3	_abrogation
arrogations	12	12	648	3	ar_rogations
coronation	12	4	1207	3	_coronation
corotation	12	4	1097	3	_corotation
corrugation	14	4	599	3	corrugation
derogation	12	4	1039	3	_derogation
irrigation	11	4	780	3	ir_rigation
peroration	12	3	1600	3	p_eroration
prerogative	17	5	535	3	prerogative
probation	13	4	1218	3	p__robation
procreation	15	4	795	3	procreation
procuration	15	4	829	3	procuration
profanation	16	18	610	3	profanation
prolongations	16	7	335	3	prolongations
promotion	13	5	950	3	promo__tion
promulgation	17	12	324	3	promulgation
pronation	11	4	1570	3	p__ronation
propagations	17	4	555	3	propagations
proportion	14	4	899	3	propo_rtion
proposition	15	8	874	3	proposition
prorations	12	3	1446	3	pror__ations
prorogate	12	4	769	3	prorogat__e
prorogated	14	4	572	3	prorogat_ed
prorogates	13	4	731	3	prorogat_es
prostration	13	4	1079	3	prostration
protonations	14	4	907	3	protonations
provocations	19	5	687	3	provocations
purgation	12	4	739	3	p_ur_gation
rogation	9	16	1205	3	___rogation
subrogation	14	4	600	3	subrogation
abrogations	14	11	646	4	_abrogations
adoration	10	3	1131	4	ador__ation
aggregation	14	5	425	4	aggregation
approbation	17	5	502	4	approbation
arborization	23	4	788	4	arborization
arrogating	12	177	839	4	ar_rogating
arrogator	10	4	525	4	ar_rogat_or
autorotation	12	5	501	4	autorotation
bromination	15	4	781	4	bromination
coloration	12	9	1318	4	_coloration
coronations	13	4	1070	4	_coronations
corotations	13	4	977	4	_corotations
corporation	15	12	1065	4	corporation
correlation	13	5	855	4	correlation
corrugations	15	6	548	4	corrugations
derogations	13	4	939	4	_derogations
elongation	11	4	535	4	elo_ngation
embrocation	17	4	458	4	embrocation
erotization	20	4	1206	4	erotization
floriation	13	6	779	4	flor_iation
formation	14	3	942	4	_for_mation
homologation	18	12	265	4	homologation
irrigations	12	4	694	4	ir_rigations
irritation	10	4	897	4	ir_ritation
morulation	12	14	890	4	_morulation
oration	7	16	1771	4	__or__ation
ozonation	18	4	567	4	__ozonation
percolation	15	4	922	4	percolation
perforation	16	4	900	4	perforation
permeation	14	4	1056	4	p_ermeation
perorations	13	3	1406	4	p_erorations
personation	13	4	948	4	personation
phonation	14	3	939	4	p__honation
population	14	8	1002	4	p_opulation
portion	9	6	1549	4	p_or___tion
potation	10	17	1678	4	p___otation
precognition	17	5	388	4	precognition
predation	12	3	1346	4	p__redation
predication	16	4	1243	4	predication
preformation	19	4	647	4	preformation
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	pr_eo_ption
preordination	16	5	615	4	preordination
preparation	15	4	927	4	preparation
preportion	14	4	887	4	prepo_rtion
preposition	15	10	858	4	preposition
prerogatived	19	5	263	4	prerogatived
prerogatives	18	5	343	4	prerogatives
privation	14	3	1117	4	p__rivation
proabortion	15	5	316	4	proabortion
proaction	13	4	1010	4	p__roaction
probations	14	3	1108	4	p__robations
proclamation	18	5	341	4	proclamation
procreations	16	4	727	4	procreations
procurations	16	4	740	4	procurations
production	15	4	789	4	pro_duction
profanations	17	17	525	4	profanations
prohibition	18	5	426	4	prohibition
projection	21	5	876	4	pro_jection
promotions	14	4	878	4	promo__tions
promulgations	18	9	283	4	promulgations
pronations	12	3	1403	4	p__ronations
propagating	17	5	488	4	propagating
propagative	19	5	450	4	propagative
propagator	15	5	430	4	propagat_or
propitiation	16	5	691	4	propitiation
proportions	15	4	846	4	propo_rtions
propositions	16	10	831	4	propositions
prorating	12	3	1428	4	pror__ating
proroguing	14	4	312	4	prorog_uing
prosecution	15	4	607	4	prosecution
prostrations	14	4	977	4	prostrations
protection	14	5	1147	4	pro_tection
protestation	14	5	636	4	protestation
protonating	14	4	859	4	protonating
protraction	15	4	721	4	protraction
provocative	21	5	464	4	provocative
purgations	13	4	674	4	p_ur_gations
relegation	11	6	1002	4	_relegation
relocation	12	3	1211	4	_relocation
renovation	13	5	878	4	_renovation
reprobation	15	4	850	4	reprobation
revocation	15	4	1081	4	_revocation
rogations	10	15	1082	4	___rogations
rotation	8	16	1545	4	___rotation
segregation	13	4	638	4	segregation
sporulation	13	4	640	4	sporulation
subrogations	15	4	545	4	subrogations
supererogation	17	6	306	4	supererogation

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.453	394461.4
2	DLD Change Limit	148819	131	8.670	17164.8
3	Display Results	131	131	0.063	2079.4
	(SQL Overall)	178691	131	9.186	19452.5