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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
esker	9	44	1298	(None)
asker	9	64	1878	1	asker
eskar	9	45	745	1	eskar
eskers	10	53	1222	1	eskers
ester	5	47	2771	1	ester
asked	10	69	1931	2	asked
askers	10	59	1540	2	askers
askew	12	52	941	2	askew
asper	7	55	2043	2	asper
aster	5	54	3489	2	aster
baker	11	56	2954	2	baker
beaker	12	55	2069	2	beaker
biker	11	60	2256	2	biker
bosker	12	38	1365	2	bosker
busker	12	55	1783	2	busker
decker	13	52	1599	2	decker
diker	10	55	2455	2	diker
eager	6	55	2697	2	eager
easier	6	42	1846	2	easier
easter	6	50	2798	2	easter
eater	5	46	3984	2	eater
edger	7	52	1595	2	edger
eger	5	59	2357	2	e_ger
egger	7	44	1441	2	egger
eider	6	46	2474	2	eider
eke	7	56	3009	2	e_ke_
eked	9	67	1802	2	e_ked
ekes	8	67	2660	2	e_kes
elder	6	40	2002	2	elder
elver	8	52	1624	2	elver
ember	9	55	1680	2	ember
emeer	7	48	1536	2	emeer
emmer	9	43	1446	2	emmer
ender	6	43	2586	2	ender
enter	5	47	2638	2	enter
escar	7	40	1199	2	escar
eses	4	53	3610	2	es_es
eskars	10	35	759	2	eskars
esne	4	70	1879	2	esne_
esnes	5	48	1736	2	esnes
esses	5	64	2297	2	esses
esters	6	46	2773	2	esters
ether	8	45	1877	2	ether
ever	7	70	2769	2	e_ver
evoker	13	46	791	2	evoker
ewer	7	75	2398	2	e_wer
eyer	7	61	2728	2	e_yer
faker	12	48	2459	2	faker
fester	9	47	2351	2	fester
hiker	12	51	1939	2	hiker
husker	13	42	1270	2	husker
icker	11	40	1844	2	icker
inker	9	44	2109	2	inker
jerker	17	36	904	2	jerker
jester	13	43	1915	2	jester
joker	16	57	1589	2	joker
laker	9	54	3287	2	laker
leaker	10	46	2007	2	leaker
lesser	6	35	1485	2	lesser
liker	9	56	2706	2	liker
maker	11	41	2781	2	maker
masker	12	44	1610	2	masker
meeker	12	35	998	2	meeker
necker	12	40	1279	2	necker
nester	6	41	2418	2	nester
ocker	11	39	1575	2	ocker
osier	5	35	1801	2	osier
pecker	14	46	1536	2	pecker
peskier	13	31	911	2	peskier
pester	8	48	2759	2	pester
piker	11	56	2284	2	piker
poker	11	51	2288	2	poker
raker	9	45	2979	2	raker
reeker	10	37	1559	2	reeker
rester	6	38	3243	2	rester
risker	10	54	1449	2	risker
saker	9	51	3202	2	saker
seder	6	48	2676	2	seder
seeker	10	36	1536	2	seeker
seer	4	55	4704	2	_seer
ser	3	67	5240	2	_s_er
serer	5	59	3551	2	serer
sever	8	54	2605	2	sever
sewer	8	44	2622	2	sewer
siker	9	53	2603	2	siker
skee	8	54	3147	2	_skee
skeg	9	53	1616	2	_skeg
skep	10	52	1935	2	_skep
skew	11	62	1876	2	_skew
skier	9	51	1959	2	_skier
suer	4	53	3403	2	_suer
taker	9	52	2900	2	taker
tester	6	42	2715	2	tester
toker	9	59	2491	2	toker
tsked	10	59	1003	2	tsked
tusker	10	42	1219	2	tusker
user	4	50	2300	2	us_er
usher	8	45	1776	2	usher
vesper	11	3	808	2	vesper
waker	12	55	2659	2	waker
weaker	13	40	1544	2	weaker
wester	9	42	2289	2	wester
yester	9	34	1798	2	yester
zester	15	36	1779	2	zester

Search took 2 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	53800	0.326	548131.9
2	DLD Change Limit	53800	104	1.390	38705.0
3	Display Results	104	104	0.033	3151.5
	(SQL Overall)	178691	104	1.749	102167.5