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

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

94 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
jerked	18	47	959	(None)
jereed	14	40	1207	1	jereed
jerker	17	36	904	1	jerker
perked	13	46	1769	1	perked
yerked	14	50	937	1	yerked
aeried	7	42	2186	2	aeried
barked	13	50	2731	2	barked
beaked	13	59	1949	2	beaked
becked	15	54	1776	2	becked
beraked	14	43	1243	2	beraked
bermed	11	52	1772	2	bermed
borked	13	51	1729	2	borked
burked	13	52	2088	2	burked
carked	13	40	2482	2	carked
cered	8	52	2744	2	cer_ed
clerked	14	32	665	2	clerked
corked	13	50	2078	2	corked
darked	12	39	1963	2	darked
decked	14	52	1762	2	decked
deked	11	57	1853	2	de_ked
dirked	12	49	1227	2	dirked
eked	9	67	1802	2	_e_ked
erred	6	59	1567	2	_erred
forked	14	52	1714	2	forked
gecked	14	69	1193	2	gecked
geeked	12	45	1016	2	geeked
harked	14	54	2255	2	harked
herbed	12	35	1345	2	herbed
herded	11	42	1564	2	herded
irked	10	45	1092	2	_irked
jacked	20	48	1752	2	jacked
jarred	14	46	1325	2	jarred
jauked	18	48	901	2	jauked
jeaned	14	38	1346	2	jeaned
jeed	12	54	2850	2	je__ed
jeeped	16	46	984	2	jeeped
jeered	14	39	1279	2	jeered
jelled	14	49	1606	2	jelled
jereeds	15	32	639	2	jereeds
jerid	13	23	1642	2	jer_id
jerk	15	49	2013	2	jerk__
jerkers	18	28	708	2	jerkers
jerkier	18	40	727	2	jerkier
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
jerreed	15	3	521	2	jerreed
jerrid	14	25	914	2	jerrid
jersey	16	3	633	2	jersey
jessed	14	41	1230	2	jessed
jested	14	44	1650	2	jested
jetted	14	39	1508	2	jetted
jewed	16	51	1483	2	je_wed
jinked	18	40	1314	2	jinked
joked	17	52	1791	2	j_oked
jouked	18	56	815	2	jouked
juked	17	57	1407	2	j_uked
junked	18	43	1169	2	junked
juried	14	42	1244	2	juried
kecked	12	51	1317	2	kecked
keeked	10	48	1012	2	keeked
kerbed	13	33	970	2	kerbed
kerfed	14	35	823	2	kerfed
kerned	11	41	1293	2	kerned
larked	11	45	1947	2	larked
leaked	11	42	1770	2	leaked
lekked	10	39	563	2	lekked
lurked	11	45	1197	2	lurked
marked	13	39	2162	2	marked
merged	10	42	1495	2	merged
narked	11	41	1674	2	narked
necked	13	47	1506	2	necked
nerved	10	41	1168	2	nerved
parked	13	44	2514	2	parked
peaked	13	61	1740	2	peaked
pecked	15	50	1910	2	pecked
peeked	13	43	1458	2	peeked
permed	11	52	1735	2	permed
peruked	14	36	789	2	peruked
porked	13	47	1762	2	porked
recked	13	48	2180	2	recked
reeked	11	37	1764	2	reeked
sered	6	57	3729	2	ser_ed
serged	8	41	1877	2	serged
served	10	46	1681	2	served
smerked	14	32	728	2	smerked
termed	9	48	1670	2	termed
verged	11	48	1516	2	verged
versed	10	45	1551	2	versed
warked	14	44	2121	2	warked
worked	14	53	1470	2	worked
yeuked	14	45	623	2	yeuked
zeroed	16	40	941	2	zeroed

Search took 6 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.673	265514.1
2	DLD Change Limit	82551	94	5.076	16263.0
3	Display Results	94	94	0.063	1492.1
	(SQL Overall)	178691	94	5.812	30745.2