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

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

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.

71 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
farseeing	13	4	438	(None)
foreseeing	14	4	455	2	foreseeing
freeing	11	37	1391	2	f_r_eeing
agreeing	10	29	590	3	_agreeing
barbering	14	22	968	3	barbering
barreling	12	3	804	3	barreling
bartering	12	23	1364	3	bartering
basseting	12	3	615	3	basseting
careening	12	3	1001	3	careening
careering	12	3	1120	3	careering
caressing	12	3	880	3	caressing
carpeting	14	3	948	3	carpeting
coarsening	13	4	554	3	coarsening
corseting	12	3	1217	3	corseting
darkening	15	3	568	3	darkening
dreeing	9	43	1118	3	_dr_eeing
faceting	14	3	878	3	fa_ceting
faltering	13	22	1111	3	faltering
farcing	13	35	1400	3	far__cing
farding	12	37	1674	3	far__ding
faring	10	52	3128	3	far___ing
farming	13	35	1508	3	far__ming
farrowing	16	4	587	3	farrowing
farthing	15	3	807	3	far_thing
farting	11	41	2075	3	far__ting
fashing	14	49	1879	3	fa_s_hing
fastening	13	26	860	3	fastening
fasting	11	45	2283	3	fa_s_ting
fathering	16	10	1009	3	fathering
fattening	13	28	783	3	fattening
feeing	10	44	1650	3	f___eeing
ferreling	13	13	627	3	ferreling
ferreting	13	12	769	3	ferreting
firstling	13	3	442	3	firstling
fleeing	11	35	1129	3	f__leeing
foresting	13	3	1136	3	foresting
forewing	15	3	900	3	for_ewing
forsaking	17	4	517	3	forsaking
freezing	21	30	832	3	f_reezing
freshing	15	26	1102	3	f_reshing
gardening	12	3	651	3	gardening
garnering	11	29	808	3	garnering
gartering	11	21	1157	3	gartering
greeing	9	36	1378	3	_gr_eeing
hanseling	13	3	806	3	hanseling
hardening	14	3	802	3	hardening
harkening	17	4	692	3	harkening
harshening	17	4	417	3	harshening
hirseling	13	9	627	3	hirseling
hoarsening	14	4	440	3	hoarsening
marketing	16	3	651	3	marketing
marveling	15	3	710	3	marveling
morseling	12	3	807	3	morseling
outseeing	10	3	833	3	outseeing
overseeing	14	3	838	3	overseeing
parceling	14	3	844	3	parceling
pargeting	13	3	828	3	pargeting
parleying	15	3	611	3	parleying
parsing	10	38	1955	3	pars__ing
preeing	10	38	1767	3	_pr_eeing
pureeing	11	3	727	3	pur_eeing
razeeing	18	3	436	3	ra_zeeing
reseeing	9	24	1262	3	_reseeing
seeing	7	42	2214	3	___seeing
targeting	11	3	730	3	targeting
tasseling	10	3	585	3	tasseling
treeing	8	34	1430	3	_tr_eeing
unseeing	9	8	829	3	_unseeing
warsling	12	19	859	3	wars_ling
warstling	13	3	506	3	warstling
worsening	13	4	555	3	worsening

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	148641	0.420	425454.8
2	DLD Change Limit	148641	71	7.846	18944.8
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	8.296	21539.4