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

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

69 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
afforesting	18	5	285	(None)
deforesting	16	5	479	2	deforesting
foresting	13	3	1136	2	__foresting
reafforesting	20	5	139	2	reafforesting
reforesting	15	4	619	2	reforesting
affecting	18	4	523	3	aff__ecting
affording	17	4	402	3	affor__ding
afforest	14	4	634	3	afforest___
afforested	17	5	265	3	afforest_ed
afforests	15	4	373	3	afforest__s
affronting	17	4	260	3	aff_ronting
arresting	10	3	863	3	a__rresting
efflorescing	21	6	121	3	efflorescing
aborting	11	7	1025	4	a_bor__ting
accosting	14	4	673	4	acco__sting
accreting	14	4	633	4	a_ccre_ting
addressing	13	4	313	4	a_ddressing
affiliating	18	4	416	4	affiliating
affirming	18	4	310	4	affir__ming
afflicting	19	4	348	4	aff_licting
afforestation	19	6	236	4	afforestation
afforestations	20	6	224	4	afforestations
affraying	19	4	310	4	aff_r_aying
affricating	20	4	396	4	affricating
affrighting	22	5	201	4	affrighting
aforesaid	13	4	326	4	a_foresai_d
aforetime	14	4	404	4	a_fore_time
aggressing	13	4	418	4	a_ggressing
aphorising	16	4	574	4	aphoris_ing
assorting	10	3	730	4	assor__ting
attesting	10	3	638	4	a__ttesting
befretting	16	4	479	4	bef_retting
corseting	12	3	1217	4	__corseting
cresting	11	40	1704	4	___cresting
defrosting	15	4	449	4	def_rosting
effecting	18	4	558	4	eff__ecting
effervescing	24	9	117	4	effervescing
ferreting	13	12	769	4	_ferre_ting
fluorescing	17	5	290	4	fluorescing
foisting	12	29	1050	4	__fo_isting
fomenting	15	3	723	4	__fomenting
forecasting	17	4	447	4	__forecasting
foredating	15	7	712	4	__foredating
foredoing	14	5	648	4	__foredoing
foregoing	14	5	579	4	__foregoing
foreseeing	14	4	455	4	__foreseeing
foreskin	15	4	702	4	__foreskin_
foreskins	16	4	704	4	__foreskins
forestial	12	4	723	4	__forestial
foretasting	15	5	442	4	__foretasting
forewing	15	3	900	4	__fore_wing
forfeiting	17	4	413	4	__forfeiting
forgetting	15	4	466	4	__forgetting
freshing	15	26	1102	4	__f_reshing
fretting	12	27	1152	4	__f_retting
frosting	12	3	1118	4	__f_rosting
frowsting	16	3	468	4	_fro_wsting
infesting	13	10	951	4	inf__esting
interesting	12	4	1112	4	interesting
molesting	12	3	774	4	__molesting
offprinting	20	5	211	4	offprinting
offsetting	17	4	233	4	off_setting
protesting	13	19	1025	4	_protesting
rearresting	12	4	596	4	rearresting
refreshing	17	4	606	4	ref_reshing
resting	8	50	3118	4	____resting
unresting	10	3	1113	4	__unresting
worsting	12	6	768	4	__wor_sting
wresting	12	38	1183	4	___wresting

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.160	1116818.8
2	DLD Change Limit	148819	69	9.140	16282.2
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	9.330	19152.3