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

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

99 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
jogger	15	47	1316	(None)
dogger	9	52	1678	1	dogger
fogger	11	44	1478	1	fogger
hogger	11	46	1508	1	hogger
jagger	15	40	1600	1	jagger
jigger	15	53	1305	1	jigger
jogged	16	60	1592	1	jogged
joggers	16	41	1069	1	joggers
joggler	16	39	883	1	joggler
logger	8	64	2000	1	logger
agger	7	64	2089	2	_agger
bagger	10	46	1920	2	bagger
bigger	10	43	1506	2	bigger
blogger	11	44	831	2	blogger
bogged	11	60	1928	2	bogged
boggier	11	37	1158	2	boggier
boggler	11	39	1008	2	boggler
booger	9	48	1655	2	booger
bugger	10	44	1872	2	bugger
clogger	11	43	880	2	clogger
codger	10	58	1487	2	codger
cogged	11	64	1661	2	cogged
conger	9	50	2427	2	conger
dagger	9	50	1730	2	dagger
digger	9	46	1608	2	digger
dodger	9	58	1705	2	dodger
dogged	10	60	1770	2	dogged
doggers	10	44	1343	2	doggers
doggery	13	44	826	2	doggery
doggier	10	38	1094	2	doggier
egger	7	44	1441	2	_egger
flogger	12	44	946	2	flogger
fogged	12	55	1837	2	fogged
foggers	12	41	1201	2	foggers
foggier	12	34	991	2	foggier
forger	10	48	2077	2	forger
gagger	9	50	1651	2	gagger
goggler	10	37	932	2	goggler
gorger	8	61	1698	2	gorger
gouger	8	60	1436	2	gouger
hogged	12	58	1777	2	hogged
hoggers	12	45	1248	2	hoggers
hogget	11	47	1576	2	hogget
hugger	11	47	1312	2	hugger
jaeger	14	39	719	2	jaeger
jager	13	43	1813	2	j_ager
jagged	16	41	1535	2	jagged
jaggers	16	40	1289	2	jaggers
jaggery	19	33	690	2	jaggery
jaggier	16	33	918	2	jaggier
jigged	16	44	1277	2	jigged
jiggers	16	40	1018	2	jiggers
jiggier	16	37	782	2	jiggier
jobber	17	38	1335	2	jobber
joggle	15	40	1035	2	joggle
joggled	17	39	843	2	joggled
jogglers	17	35	688	2	jogglers
joggles	16	44	1041	2	joggles
joiner	13	41	1413	2	joiner
joker	16	57	1589	2	jo_ker
jokier	17	61	875	2	jokier
jolter	13	35	1309	2	jolter
josher	16	43	1296	2	josher
jotter	13	43	1563	2	jotter
judger	15	44	1145	2	judger
jugged	16	38	1393	2	jugged
juggler	16	41	887	2	juggler
kegger	12	38	808	2	kegger
lagger	8	59	1983	2	lagger
lodger	8	65	1769	2	lodger
logged	9	66	2294	2	logged
loggers	9	46	1613	2	loggers
loggier	9	38	1114	2	loggier
logier	7	50	1573	2	logier
longer	7	58	2320	2	longer
lugger	8	39	1655	2	lugger
mogged	11	52	1539	2	mogged
monger	9	44	1833	2	monger
mugger	10	39	1470	2	mugger
nagger	8	40	1612	2	nagger
nigger	8	97	1357	2	nigger
nogged	9	57	1633	2	nogged
ogler	6	59	1744	2	_ogler
progger	11	31	937	2	progger
rigger	8	56	1671	2	rigger
roger	6	45	2141	2	ro_ger
rugger	8	44	1451	2	rugger
sagger	8	43	2107	2	sagger
slogger	9	43	1048	2	slogger
sogged	9	55	1852	2	sogged
soggier	9	34	1088	2	soggier
tagger	8	40	1771	2	tagger
togged	9	51	1751	2	togged
toggery	12	50	592	2	toggery
toggler	9	39	919	2	toggler
tonger	7	47	1969	2	tonger
tugger	8	40	1310	2	tugger
voguer	10	46	840	2	voguer
wagger	11	36	1601	2	wagger

Search took 5 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.360	496363.9
2	DLD Change Limit	82551	99	4.360	18933.7
3	Display Results	99	99	0.030	3300.0
	(SQL Overall)	178691	99	4.750	37619.2