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

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

87 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
learier	7	34	1566	(None)
blearier	10	3	733	1	blearier
leadier	8	32	1272	1	leadier
leafier	10	32	983	1	leafier
leakier	11	40	1099	1	leakier
learner	7	31	938	1	learner
leavier	10	31	999	1	leavier
leerier	7	31	1150	1	leerier
tearier	7	38	1561	1	tearier
wearier	10	36	1328	1	wearier
aerier	6	48	2315	2	ae_rier
beadier	10	35	1391	2	beadier
beakier	13	40	1216	2	beakier
beamier	11	34	1194	2	beamier
bearer	8	53	2391	2	bear_er
beerier	9	36	1302	2	beerier
charier	12	43	1790	2	charier
clearer	9	37	1082	2	clear_er
dearer	7	48	2280	2	dear_er
dearie	7	33	1981	2	dearie_
dearies	8	35	2627	2	dearies
decrier	10	27	1355	2	decrier
drearier	9	29	792	2	drearier
earlier	7	26	1274	2	_earlier
earner	6	36	1722	2	_earner
easier	6	42	1846	2	_easier
eerier	6	43	2002	2	_eerier
fearer	9	48	2018	2	fear_er
glarier	8	41	1220	2	glarier
gleamier	11	4	491	2	gleamier
headier	11	32	1295	2	headier
hearer	9	43	2364	2	hear_er
heartier	11	3	909	2	heartier
heavier	13	42	942	2	heavier
hoarier	10	42	1174	2	hoarier
lacier	8	40	2009	2	l_acier
lakier	10	47	1627	2	l_akier
larder	7	37	2097	2	l_arder
lardier	8	35	1834	2	l_ardier
larger	7	44	1751	2	l_arger
larker	10	45	1924	2	l_arker
larkier	11	37	1152	2	l_arkier
lazier	15	42	1461	2	l_azier
leacher	12	40	1484	2	leacher
leachier	13	3	725	2	leachier
leader	7	48	2465	2	lea_der
leaguer	8	3	579	2	leaguer
leaker	10	46	2007	2	lea_ker
leaner	6	40	2219	2	lea_ner
leaper	8	81	1894	2	lea_per
leariest	8	31	1784	2	leariest
learned	8	32	930	2	learned
learners	8	39	815	2	learners
leaser	6	53	2267	2	lea_ser
leather	10	38	1578	2	leather
leaver	9	43	2151	2	lea_ver
ledgier	9	45	850	2	ledgier
leggier	9	36	823	2	leggier
levier	9	40	1387	2	le_vier
loamier	9	34	916	2	loamier
mealier	9	30	1590	2	mealier
meatier	9	32	1461	2	meatier
merrier	9	26	1230	2	merrier
nearer	6	46	1889	2	near_er
nearlier	8	3	679	2	nearlier
peakier	13	44	1144	2	peakier
pearler	9	3	1037	2	pearler
pearlier	10	3	732	2	pearlier
pearter	9	4	1274	2	pearter
peatier	9	40	1723	2	peatier
readier	8	31	1742	2	readier
rearer	6	49	2891	2	rear_er
scarier	9	40	1787	2	scarier
seamier	9	31	1463	2	seamier
searer	6	54	3202	2	sear_er
sleazier	17	3	512	2	sleazier
smearier	10	3	695	2	smearier
tearer	6	48	2290	2	tear_er
terrier	7	34	1496	2	terrier
varier	9	46	1935	2	_varier
vealier	10	27	1217	2	vealier
verier	9	46	2096	2	ve_rier
warier	9	37	2289	2	_warier
wearer	9	43	1940	2	wear_er
wearied	11	29	1180	2	wearied
wearies	10	30	2022	2	wearies
yearner	10	33	687	2	yearner

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.390	458182.1
2	DLD Change Limit	107671	87	3.313	32499.5
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.733	47867.9