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

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

115 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
diffracting	21	4	334	(None)
diffraction	20	5	349	2	diffraction
diffractions	21	5	327	2	diffractions
distracting	15	6	925	2	distracting
infracting	16	4	735	2	_infracting
bifurcating	19	5	261	3	bifurcating
detracting	14	3	871	3	d_etracting
diffract	17	4	472	3	diffract___
diffracted	20	4	297	3	diffract_ed
diffracts	18	4	322	3	diffract__s
directing	13	3	882	3	di__recting
disfrocking	22	5	296	3	disfrocking
disgracing	15	8	674	3	disgrac_ing
disrating	11	7	1455	3	di_sra_ting
districting	15	5	900	3	districting
refracting	16	3	873	3	_refracting
abstracting	16	4	518	4	abstracting
affecting	18	4	523	4	_aff_ecting
afflicting	19	4	348	4	_afflicting
affraying	19	4	310	4	_affra_ying
affricating	20	4	396	4	_affricating
affronting	17	4	260	4	_affronting
attracting	13	4	656	4	_attracting
contracting	16	6	1047	4	contracting
deaerating	12	3	1156	4	deaera_ting
decorating	14	3	1207	4	decora_ting
defacing	15	23	868	4	d_ef_ac_ing
defalcating	18	4	434	4	defalcating
defatting	14	3	610	4	d_ef_atting
defeating	14	23	1197	4	d_efea_ting
defecating	17	23	778	4	defeca_ting
defecting	16	25	1022	4	d_ef_ecting
deflating	14	26	1071	4	d_efla_ting
deflecting	17	3	650	4	d_eflecting
deforcing	16	3	606	4	defor_c_ing
deforesting	16	5	479	4	deforesting
defragging	17	4	282	4	d_efragging
defrauding	16	4	292	4	d_efrauding
defraying	17	3	585	4	d_efra_ying
defrocking	21	4	315	4	d_efrocking
defrosting	15	4	449	4	d_efrosting
demarcating	17	4	520	4	demarcating
depurating	14	3	864	4	depura_ting
derating	10	32	2228	4	d__era_ting
deratting	11	3	951	4	d__eratting
destructing	15	4	611	4	destructing
diagraming	15	4	438	4	diagra_ming
diagramming	18	5	267	4	diagramming
dictating	13	3	888	4	di_cta_ting
differencing	22	5	263	4	differencing
differing	17	4	647	4	diff__ering
diffusing	17	4	385	4	diff__using
dilating	10	27	1491	4	di__la_ting
disaffecting	22	5	293	4	disaffecting
disbranching	21	5	248	4	disbranching
discanting	14	4	945	4	di_scanting
disjecting	21	7	724	4	di_sjecting
dislocating	15	4	673	4	dislocating
dismasting	14	4	638	4	di_smasting
disparting	14	3	893	4	di_sparting
displacing	16	4	641	4	displac_ing
displanting	15	4	604	4	displanting
dispraising	15	4	604	4	dispraising
disrooting	12	4	774	4	di_srooting
disrupting	14	4	634	4	di_srupting
disseating	12	11	1178	4	dissea_ting
dissecting	14	13	947	4	di_ssecting
distasting	12	4	802	4	di_stasting
distractingly	20	5	325	4	distractingly
distraction	14	4	911	4	distraction
distractions	15	4	875	4	distractions
distractive	17	4	677	4	distractive
distraining	13	4	698	4	distraining
distrusting	13	8	649	4	distrusting
divagating	16	4	400	4	divaga_ting
divaricating	19	5	359	4	divaricating
diverting	14	24	1033	4	diver__ting
divorcing	16	4	432	4	divor_c_ing
drafting	13	33	941	4	d___rafting
dratting	10	38	966	4	d___ratting
effacing	17	4	446	4	_eff_ac_ing
effecting	18	4	558	4	_eff_ecting
extracting	20	4	722	4	_extracting
filtrating	14	4	597	4	filtra_ting
furcating	15	3	778	4	__furcating
impacting	16	3	594	4	_i_mpacting
infecting	15	10	967	4	_inf_ecting
inflating	13	3	1044	4	_infla_ting
inflecting	16	4	631	4	_inflecting
inflicting	16	4	572	4	_inflicting
infraction	15	5	745	4	_infraction
infractions	16	4	696	4	_infractions
ingrafting	15	4	489	4	_ingrafting
interacting	14	4	1171	4	interacting
iterating	10	3	1425	4	_itera_ting
liberating	13	4	925	4	libera_ting
librating	12	3	905	4	li_bra_ting
migrating	13	9	1053	4	mi_gra_ting
misacting	14	3	908	4	mi__sacting
misframing	18	4	623	4	misfra_ming
misgrafting	18	4	408	4	misgrafting
misrating	12	10	1485	4	mi_sra_ting
mistracing	15	6	960	4	mistrac_ing
nitrating	10	3	1267	4	ni_tra_ting
overacting	16	3	1091	4	_overacting
pirating	11	3	1451	4	pi__ra_ting
protracting	16	4	693	4	protracting
retracting	13	3	1193	4	_retracting
subtracting	16	4	527	4	subtracting
sufflating	17	4	484	4	suffla_ting
suffocating	20	5	288	4	suffocating
titrating	10	3	1011	4	ti_tra_ting
trifurcating	18	5	214	4	trifurcating
underacting	15	4	752	4	underacting
vibrating	15	3	748	4	vi_bra_ting

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.423	422437.4
2	DLD Change Limit	148819	115	8.203	18142.0
3	Display Results	115	115	0.063	1825.4
	(SQL Overall)	178691	115	8.689	20565.2