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

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

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.

40 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
earthing	12	3	1032	(None)
earthling	13	4	619	1	earthling
farthing	15	3	807	1	farthing
airthing	12	29	795	2	airthing
arching	13	62	1669	2	_arching
bathing	13	48	1624	2	ba_thing
berthing	14	20	959	2	berthing
birthing	14	33	843	2	birthing
carting	10	42	2828	2	cart_ing
darting	9	40	2066	2	dart_ing
dartling	10	3	956	2	dartling
earing	7	52	3548	2	ear__ing
earning	8	34	1821	2	ear_ning
earring	8	35	1901	2	ear_ring
earthen	10	3	925	2	earthen_
earthier	11	3	744	2	earthier
earthily	14	4	561	2	earthily
earthlings	14	4	361	2	earthlings
easting	8	49	2430	2	east_ing
eating	7	51	3440	2	ea_t_ing
faithing	15	3	715	2	faithing
farthings	16	3	523	2	farthings
farting	11	41	2075	2	fart_ing
girthing	13	25	608	2	girthing
hearting	12	5	1312	2	heart_ing
inearthing	14	4	354	2	inearthing
karting	12	37	1606	2	kart_ing
lathing	11	43	1569	2	la_thing
marching	16	43	1219	2	marching
marting	10	33	2501	2	mart_ing
naething	12	3	607	2	naething
northing	12	19	906	2	northing
parching	16	43	1305	2	parching
parting	10	35	2738	2	part_ing
partying	14	16	889	2	partying
searching	15	3	834	2	searching
tarting	8	42	2265	2	tart_ing
unearthing	14	5	437	2	unearthing
worthing	15	17	805	2	worthing
wrathing	15	24	892	2	wrathing

Search took 6 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	121059	0.423	422437.4
2	DLD Change Limit	121059	40	4.813	25152.5
3	Display Results	40	40	0.030	1333.3
	(SQL Overall)	178691	40	5.266	33933.0