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

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

155 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
protraction	15	4	719	(None)
protractions	16	4	661	1	protractions
proaction	13	4	1010	2	pro__action
proration	11	4	1598	2	pro_ra_tion
prostration	13	4	1078	2	prostra_tion
protection	14	5	1145	2	prot_ection
protractile	15	5	410	2	protractile
protracting	16	4	692	2	protracting
protractive	18	5	563	2	protractive
protractor	14	4	625	2	protract_or
retraction	12	13	1053	2	_retraction
abstraction	15	4	588	3	abstraction
attraction	12	7	695	3	_attraction
contraction	15	4	1123	3	contraction
detraction	13	13	858	3	_detraction
distraction	14	4	910	3	distraction
extraction	19	6	798	3	_extraction
peroration	12	3	1599	3	pero_ra_tion
photoreaction	20	13	414	3	photoreaction
potation	10	17	1678	3	p_ot_a_tion
proactions	14	4	933	3	pro__actions
probation	13	4	1218	3	pro_ba_tion
procreation	15	4	794	3	procreation
procuration	15	4	829	3	procura_tion
production	15	4	789	3	pro_duction
projection	21	5	875	3	pro_jection
prolactin	13	4	776	3	pro_lacti_n
pronation	11	4	1570	3	pro_na_tion
prorations	12	3	1444	3	pro_ra_tions
prostrations	14	4	974	3	prostra_tions
protections	15	5	1067	3	prot_ections
protonation	13	5	1042	3	protonation
protract	12	5	1060	3	protract___
protracted	15	4	576	3	protract_ed
protractors	15	4	659	3	protractors
protracts	13	4	701	3	protract__s
protrusion	12	5	434	3	protr_usion
provocation	18	4	734	3	provocation
refraction	15	13	790	3	_refraction
retractions	13	9	1034	3	_retractions
retroaction	13	4	736	3	_retroaction
rotation	8	16	1545	3	_rot_a_tion
subtraction	15	4	562	3	subtraction
traction	10	4	1268	3	___traction
abstractions	16	4	577	4	abstractions
adoration	10	3	1131	4	ado_ra_tion
arbitration	13	4	647	4	arbitra_tion
attractions	13	7	639	4	_attractions
castration	12	4	1080	4	castra_tion
coaction	12	3	1076	4	_co__action
compaction	18	4	675	4	_compaction
contractions	16	4	1038	4	contractions
contraption	15	4	810	4	contraption
corotation	12	4	1096	4	corot_a_tion
correction	14	4	880	4	_correction
destruction	14	4	695	4	destruction
detractions	14	11	826	4	_detractions
diffraction	20	5	349	4	diffraction
distractions	15	4	872	4	distractions
dotation	9	14	1273	4	_dot_a_tion
erotization	20	4	1205	4	erotization
extractions	20	7	773	4	_extractions
filtration	13	4	643	4	filtra_tion
flotation	12	6	781	4	flot_a_tion
fraction	13	5	948	4	___fraction
frustration	14	4	481	4	frustra_tion
infraction	15	5	745	4	_infraction
instruction	13	13	794	4	instruction
interaction	13	4	1181	4	interaction
lustration	10	4	835	4	lustra_tion
nitration	9	3	1344	4	_nitra_tion
nonaction	11	4	944	4	_no_naction
notation	8	14	1460	4	_not_a_tion
obstruction	15	13	554	4	obstruction
olfaction	14	6	423	4	__olfaction
oration	7	16	1771	4	__o_ra_tion
overaction	15	4	798	4	_overaction
paction	11	27	1396	4	p____action
peltation	11	3	1296	4	pelt_a_tion
penetration	13	4	989	4	penetra_tion
perforation	16	4	899	4	perfora_tion
perorations	13	3	1404	4	pero_ra_tions
perpetration	16	4	712	4	perpetra_tion
petrifaction	19	5	372	4	p_etrifaction
phonation	14	3	939	4	pho_na_tion
photoreactions	21	11	352	4	photoreactions
portion	9	6	1549	4	p_o_r__tion
portraitist	13	5	501	4	portraitist
potations	11	16	1506	4	p_ot_a_tions
precaution	14	4	723	4	pr_ecaution
predation	12	3	1346	4	pr_eda_tion
predication	16	4	1243	4	predication
prediction	15	4	1030	4	pr_ediction
preelection	15	13	648	4	preelection
prelection	14	15	1128	4	pr_election
preparation	15	4	927	4	preparation
pretrain	10	3	1092	4	pretra__i_n
privation	14	3	1117	4	pr_iva_tion
proabortion	15	5	316	4	proabortion
proactive	16	4	836	4	pro__active
probations	14	3	1106	4	pro_ba_tions
proclamation	18	5	341	4	proclamation
procreations	16	4	725	4	procreations
procurations	16	4	738	4	procura_tions
productions	16	4	752	4	pro_ductions
profanation	16	18	610	4	profanation
progression	14	5	586	4	progression
prohibition	18	5	426	4	prohibition
projections	22	5	845	4	pro_jections
prolactins	14	4	713	4	pro_lactins
promotion	13	5	950	4	pro__motion
pronations	12	3	1403	4	pro_na_tions
propagation	16	4	644	4	propagation
propitiation	16	5	691	4	propitia_tion
proportion	14	4	898	4	pro_portion
proposition	15	8	873	4	proposition
propraetor	14	5	412	4	propraet_or
prorating	12	3	1428	4	pro_ra_ting
prorogation	14	4	739	4	prorogation
proscription	18	12	450	4	proscription
prosecution	15	4	606	4	prosecution
prostitution	14	5	460	4	prostitution
prostrating	14	4	939	4	prostra_ting
protamin	12	12	1054	4	prot_a_mi_n
protatic	12	3	1474	4	prot_a_ti_c
protecting	15	19	1020	4	prot_ecting
protective	17	4	842	4	prot_ective
protector	13	16	953	4	prot_ect_or
protestation	14	5	635	4	protestation
prothalamion	19	6	173	4	prothalamion
protonations	14	4	904	4	protonations
protreptic	16	4	471	4	protrepti_c
protreptics	17	5	345	4	protreptics
protrusions	13	5	413	4	protr_usions
provocations	19	5	684	4	provocations
putrefaction	19	5	245	4	p_utrefaction
quotation	18	14	697	4	quot_a_tion
reaction	10	6	1260	4	_r__eaction
redaction	12	5	966	4	_r_edaction
refractions	16	12	772	4	_refractions
restriction	13	4	936	4	restriction
retractile	12	4	625	4	_retractile
retracting	13	3	1193	4	_retracting
retractor	11	21	851	4	_retract_or
retroactions	14	4	706	4	_retroactions
rogation	9	16	1205	4	_ro_ga_tion
rotations	9	16	1384	4	_rot_a_tions
striction	11	4	898	4	__striction
subtractions	16	4	536	4	subtractions
taction	9	32	1302	4	___t_action
titration	9	3	1054	4	_titra_tion
tractions	11	5	1161	4	___tractions
transaction	13	4	629	4	transaction
trituration	11	4	665	4	tritura_tion
urtication	12	4	911	4	ur_tication

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	148819	0.156	1145455.1
2	DLD Change Limit	148819	155	8.546	17413.9
3	Display Results	155	155	0.110	1409.1
	(SQL Overall)	178691	155	8.812	20278.1