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

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

57 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
learner	7	31	938	(None)
earner	6	36	1722	1	_earner
leaner	6	40	2219	1	lea_ner
learier	7	34	1566	1	learier
learned	8	32	930	1	learned
learners	8	39	815	1	learners
yearner	10	33	687	1	yearner
bearer	8	53	2391	2	bear_er
blearier	10	3	733	2	blearier
cleaner	9	37	1230	2	clea_ner
clearer	9	37	1082	2	clear_er
darner	7	40	1730	2	_darner
dearer	7	48	2280	2	dear_er
earned	7	48	1833	2	_earned
earners	7	40	1645	2	_earners
fearer	9	48	2018	2	fear_er
garner	7	39	1700	2	_garner
gleaner	8	37	977	2	glea_ner
hearer	9	43	2364	2	hear_er
lanner	6	49	2060	2	l_anner
larder	7	37	2097	2	l_arder
larger	7	44	1751	2	l_arger
larker	10	45	1924	2	l_arker
leacher	12	40	1484	2	leacher
leader	7	48	2465	2	lea_der
leadier	8	32	1272	2	leadier
leafier	10	32	983	2	leafier
leaguer	8	3	579	2	leaguer
leaker	10	46	2007	2	lea_ker
leakier	11	40	1099	2	leakier
leaned	7	34	2254	2	lea_ned
leaners	7	37	1817	2	lea_ners
leaper	8	81	1894	2	lea_per
learn	5	53	2266	2	learn__
learns	6	55	1374	2	learn_s
learnt	6	40	1925	2	learn_t
leaser	6	53	2267	2	lea_ser
leather	10	38	1578	2	leather
leaver	9	43	2151	2	lea_ver
leavier	10	31	999	2	leavier
leerier	7	31	1150	2	leerier
loaner	6	44	1650	2	loa_ner
meaner	8	46	1784	2	mea_ner
nearer	6	46	1889	2	near_er
pearler	9	3	1037	2	pearler
pearter	9	4	1274	2	pearter
rearer	6	49	2891	2	rear_er
searer	6	54	3202	2	sear_er
tearer	6	48	2290	2	tear_er
tearier	7	38	1561	2	tearier
warner	9	37	1722	2	_warner
weaner	9	38	1677	2	wea_ner
wearer	9	43	1940	2	wear_er
wearier	10	36	1328	2	wearier
yarner	9	33	1306	2	_yarner
yearned	11	32	737	2	yearned
yearners	11	34	637	2	yearners

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	57	3.533	30475.8
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	3.703	48255.7