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

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

59 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
learning	9	7	855	(None)
earning	8	34	1821	1	_earning
leaning	8	37	2120	1	lea_ning
learnings	10	9	432	1	learnings
yearning	12	9	698	1	yearning
barning	10	43	2035	2	_barning
beaning	10	38	2068	2	bea_ning
bearding	12	40	1194	2	bearding
bearing	10	36	2477	2	bear_ing
blearing	11	31	1194	2	blear_ing
cleaning	11	31	1238	2	clea_ning
clearing	11	30	1488	2	clear_ing
clearwing	15	3	367	2	clearwing
darning	9	38	1733	2	_darning
deaning	9	40	2047	2	dea_ning
earing	7	52	3548	2	_ear_ing
earnings	9	41	933	2	_earnings
earring	8	35	1901	2	_earring
fearing	11	35	2003	2	fear_ing
gearing	9	28	1884	2	gear_ing
gleaning	10	26	932	2	glea_ning
hearing	11	33	2416	2	hear_ing
hearsing	12	3	938	2	hearsing
hearting	12	5	1312	2	hearting
kerning	12	40	1089	2	ke_rning
larding	9	29	1787	2	l_arding
larking	12	37	1825	2	l_arking
leaching	14	30	1283	2	leaching
leadening	11	7	673	2	leadening
leading	9	34	1955	2	lea_ding
leafing	11	33	1358	2	lea_fing
leaguing	10	3	534	2	leaguing
leaking	12	36	1697	2	lea_king
leanings	9	40	1018	2	lea_nings
leaping	10	32	1599	2	lea_ping
leashing	12	33	1031	2	leashing
leasing	8	39	2016	2	lea_sing
leavening	13	6	597	2	leavening
leaving	11	42	1685	2	lea_ving
leering	8	34	1764	2	leer_ing
loaning	8	36	1483	2	loa_ning
meaning	10	39	1870	2	mea_ning
nearing	8	30	2033	2	near_ing
pearling	11	9	1201	2	pearling
rearing	8	31	2878	2	rear_ing
rearming	11	14	1361	2	rearming
reearning	10	3	905	2	reearning
relearning	11	3	528	2	relearning
searing	8	33	3092	2	sear_ing
tearing	8	40	2149	2	tear_ing
unlearning	11	4	471	2	unlearning
warning	11	37	1709	2	_warning
weaning	11	41	1719	2	wea_ning
wearing	11	33	1886	2	wear_ing
wearying	15	4	670	2	wearying
yarning	11	35	1295	2	_yarning
yeaning	11	38	1463	2	yea_ning
yearling	12	9	788	2	yearling
yearnings	13	9	355	2	yearnings

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.390	458182.1
2	DLD Change Limit	121059	59	3.766	32145.2
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	4.186	42687.8