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

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

50 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
earnings	9	41	933	(None)
darnings	10	37	855	1	darnings
earings	8	45	1771	1	ear_ings
earning	8	34	1821	1	earning_
earrings	9	29	963	1	earrings
learnings	10	9	432	1	learnings
warnings	12	35	845	1	warnings
yearnings	13	9	355	1	yearnings
armings	10	38	1150	2	_armings
awnings	11	40	671	2	_awnings
barning	10	43	2035	2	barning_
bearings	11	39	1225	2	bear_ings
burnings	11	38	762	2	burnings
cannings	11	37	1033	2	cannings
cardings	12	38	1263	2	cardings
carlings	11	40	1585	2	carlings
carpings	13	38	1238	2	carpings
carvings	14	38	1020	2	carvings
darings	9	37	1365	2	dar_ings
darlings	10	37	1038	2	darlings
darning	9	38	1733	2	darning_
eanlings	9	12	847	2	eanlings
earing	7	52	3548	2	ear_ing_
earring	8	35	1901	2	earring_
earwigs	11	10	441	2	earwi_gs
eastings	9	34	1295	2	eastings
eatings	8	46	1644	2	ea_tings
evenings	12	3	438	2	evenings
farmings	14	29	822	2	farmings
gearings	10	35	950	2	gear_ings
harpings	14	37	977	2	harpings
hearings	12	36	1185	2	hear_ings
hornings	12	23	836	2	hornings
kartings	13	41	852	2	kartings
leanings	9	40	1018	2	lea_nings
learning	9	7	855	2	learning_
markings	15	34	1024	2	markings
marlings	11	37	1349	2	marlings
meanings	11	32	916	2	mea_nings
mornings	11	29	792	2	mornings
pargings	12	34	1016	2	pargings
parings	10	42	1921	2	par_ings
parkings	15	36	1068	2	parkings
partings	11	35	1373	2	partings
tannings	9	26	863	2	tannings
turnings	9	28	723	2	turnings
warning	11	37	1709	2	warning_
yarning	11	35	1295	2	yarning_
yearlings	13	8	420	2	yearlings
yearning	12	9	698	2	yearning_

Search took 5 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.373	479064.3
2	DLD Change Limit	121059	50	3.796	31891.2
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	4.185	42698.0