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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

94 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
diffraction	20	5	349	(None)
diffractions	21	5	327	1	diffractions
diffracting	21	4	334	2	diffracting
distraction	14	4	911	2	distraction
infraction	15	5	745	2	_infraction
bifurcation	18	6	337	3	bifurcation
detraction	13	13	858	3	d_etraction
diffract	17	4	472	3	diffract___
diffracted	20	4	297	3	diffract_ed
diffracts	18	4	322	3	diffract__s
direction	12	8	978	3	di__rection
disfunction	17	5	471	3	disfunction
distractions	15	4	875	3	distractions
fraction	13	5	948	3	___fraction
infarction	15	4	579	3	_infarction
infractions	16	4	696	3	_infractions
refraction	15	13	790	3	_refraction
abstraction	15	4	588	4	abstraction
affection	17	4	589	4	_aff_ection
affliction	18	4	354	4	_affliction
attraction	12	7	695	4	_attraction
bifurcations	19	8	293	4	bifurcations
contraction	15	4	1124	4	contraction
deaeration	11	3	1301	4	deaera_tion
decoration	13	3	1442	4	decora_tion
defalcation	17	4	622	4	defalcation
defamation	16	4	684	4	defama_tion
defecation	16	7	980	4	defeca_tion
defection	15	16	1064	4	d_ef_ection
deflation	13	3	1065	4	d_efla_tion
deflection	16	14	773	4	d_eflection
defloration	15	4	726	4	deflora_tion
deformation	17	4	766	4	deformation
deification	17	4	1166	4	deifica_tion
demarcation	16	4	702	4	demarcation
destruction	14	4	695	4	destruction
detractions	14	11	827	4	d_etractions
dictation	12	8	1056	4	di_cta_tion
diction	10	23	1305	4	di____ction
diffusion	16	4	397	4	diff__usion
dilatation	11	4	739	4	dilata_tion
dilation	9	22	1546	4	di__la_tion
directions	13	7	964	4	di__rections
disaffection	21	5	320	4	disaffection
discretion	13	4	752	4	discr_etion
disfunctions	18	5	452	4	disfunctions
disjunction	21	5	409	4	disjunction
dislocation	14	14	750	4	dislocation
disruption	13	13	573	4	di_sruption
dissection	13	15	861	4	di_ssection
distinction	14	4	732	4	distinction
distracting	15	6	925	4	distracting
distractive	17	4	677	4	distractive
divagation	15	10	437	4	divaga_tion
divarication	18	5	590	4	divarication
divination	14	13	923	4	divina_tion
duration	9	3	1269	4	d__ura_tion
dysfunction	20	5	225	4	dysfunction
edification	17	4	935	4	edifica_tion
extraction	19	6	798	4	_extraction
faction	12	26	1333	4	___f_action
figuration	14	4	591	4	figura_tion
filtration	13	4	643	4	filtra_tion
fractions	14	4	910	4	___fractions
friction	13	4	791	4	___friction
furcation	14	4	835	4	__furcation
impaction	15	4	573	4	_i_mpaction
inaction	10	3	962	4	_i__naction
infarctions	16	4	502	4	_infarctions
infection	14	4	1047	4	_inf_ection
inflation	12	3	1109	4	_infla_tion
inflection	15	4	763	4	_inflection
infliction	15	4	594	4	_infliction
infracting	16	4	735	4	_infracting
infractor	14	6	594	4	_infract_or
interaction	13	4	1181	4	interaction
iteration	9	5	1503	4	_itera_tion
liberation	12	6	999	4	libera_tion
libration	11	15	1016	4	li_bra_tion
literation	10	5	1141	4	litera_tion
migration	12	17	970	4	mi_gra_tion
misfunction	18	5	394	4	misfunction
nitration	9	3	1344	4	ni_tra_tion
olfaction	14	6	423	4	_olf_action
overaction	15	4	799	4	_overaction
protraction	15	4	721	4	protraction
refractions	16	12	772	4	_refractions
retraction	12	13	1053	4	_retraction
subtraction	15	4	562	4	subtraction
suffocation	19	5	337	4	suffocation
titration	9	3	1054	4	ti_tra_tion
traction	10	4	1268	4	___traction
trifurcation	17	5	327	4	trifurcation
vibration	14	13	820	4	vi_bra_tion

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.436	409841.7
2	DLD Change Limit	148819	94	8.953	16622.2
3	Display Results	94	94	0.046	2043.5
	(SQL Overall)	178691	94	9.435	18939.2