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

Here are the results of your fuzzy-string dictionary search for “jerker” 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
jerker	17	36	904	(None)
jerked	18	47	959	1	jerked
jerkers	18	28	708	1	jerkers
jerkier	18	40	727	1	jerkier
aerier	6	48	2316	2	aerier
barker	12	48	2286	2	barker
beaker	12	55	2069	2	beaker
burker	12	52	2117	2	burker
corker	12	47	2085	2	corker
darker	11	47	1869	2	darker
decker	13	52	1599	2	decker
eerier	6	43	2002	2	eerier
esker	9	44	1298	2	_esker
forker	13	47	1790	2	forker
herder	10	45	1646	2	herder
jacker	19	44	1758	2	jacker
jeer	11	54	2646	2	je__er
jeerer	13	38	993	2	jeerer
jereed	14	40	1207	2	jereed
jerk	15	49	2013	2	jerk__
jerkies	18	34	1158	2	jerkies
jerkin	17	25	811	2	jerkin
jerks	16	65	1489	2	jerk_s
jerky	19	67	1242	2	jerk_y
jersey	16	3	633	2	jersey
jester	13	43	1915	2	jester
jinker	17	40	1354	2	jinker
joker	16	57	1589	2	j_oker
junker	17	42	1365	2	junker
larker	10	45	1924	2	larker
leaker	10	46	2007	2	leaker
lurker	10	36	1329	2	lurker
marker	12	44	2039	2	marker
meeker	12	35	998	2	meeker
mercer	10	52	1420	2	mercer
merer	7	51	2623	2	mer_er
merger	9	50	1648	2	merger
mirker	12	37	1269	2	mirker
murker	12	37	1524	2	murker
necker	12	40	1279	2	necker
parker	12	41	2137	2	parker
pecker	14	46	1536	2	pecker
perked	13	46	1769	2	perked
perkier	13	38	1312	2	perkier
perter	8	44	2228	2	perter
porker	12	49	1754	2	porker
reeker	10	37	1559	2	reeker
seeker	10	36	1536	2	seeker
serer	5	59	3551	2	ser_er
serger	7	38	1974	2	serger
server	9	49	1771	2	server
termer	8	57	1725	2	termer
terser	6	73	1782	2	terser
verger	10	43	1570	2	verger
verier	9	46	2096	2	verier
verser	9	45	1696	2	verser
weaker	13	40	1544	2	weaker
worker	13	47	1511	2	worker
yerked	14	50	937	2	yerked

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	59	2.373	34787.6
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	2.732	65406.7