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

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

100 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
jigger	15	53	1305	(None)
bigger	10	43	1506	1	bigger
digger	9	46	1608	1	digger
jagger	15	40	1600	1	jagger
jigged	16	44	1277	1	jigged
jiggers	16	40	1018	1	jiggers
jiggier	16	37	782	1	jiggier
jogger	15	47	1316	1	jogger
nigger	8	97	1357	1	nigger
rigger	8	56	1671	1	rigger
agger	7	64	2089	2	_agger
bagger	10	46	1920	2	bagger
binger	9	49	2345	2	binger
bugger	10	44	1872	2	bugger
chigger	14	3	600	2	chigger
dagger	9	50	1730	2	dagger
digged	10	43	1465	2	digged
diggers	10	44	1339	2	diggers
dinger	8	53	2367	2	dinger
dogger	9	52	1678	2	dogger
egger	7	44	1441	2	_egger
figged	12	40	1389	2	figged
finger	10	49	2033	2	finger
fogger	11	44	1478	2	fogger
gagger	9	50	1651	2	gagger
gigged	10	41	1229	2	gigged
giggler	10	102	988	2	giggler
ginger	8	49	2003	2	ginger
higgler	12	36	980	2	higgler
higher	13	46	1089	2	higher
hinger	10	47	2333	2	hinger
hogger	11	46	1508	2	hogger
hugger	11	47	1312	2	hugger
igged	8	60	1276	2	_igged
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
jibber	17	41	1124	2	jibber
jiber	14	51	1570	2	ji_ber
jiggered	18	3	420	2	jiggered
jiggle	15	38	1199	2	jiggle
jiggled	17	35	884	2	jiggled
jiggles	16	41	1143	2	jiggles
jigglier	17	5	409	2	jigglier
jiggly	18	37	871	2	jiggly
jiggy	17	54	914	2	jigg_y
jilter	13	35	1251	2	jilter
jimper	17	38	986	2	jimper
jingler	15	43	1109	2	jingler
jinker	17	40	1354	2	jinker
jitter	13	33	1499	2	jitter
jiver	15	51	1905	2	ji_ver
jivier	16	43	861	2	jivier
jogged	16	60	1592	2	jogged
joggers	16	41	1069	2	joggers
joggler	16	39	883	2	joggler
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
liger	6	50	2447	2	li_ger
linger	7	52	2600	2	linger
logger	8	64	2000	2	logger
lugger	8	39	1655	2	lugger
mugger	10	39	1470	2	mugger
nagger	8	40	1612	2	nagger
niggers	9	31	1132	2	niggers
niggler	9	36	1029	2	niggler
nigher	10	36	1275	2	nigher
pigged	11	42	1415	2	pigged
piggery	14	26	619	2	piggery
piggier	11	35	1000	2	piggier
pinger	9	43	2409	2	pinger
rejigger	17	4	318	2	rejigger
rigged	9	45	1740	2	rigged
riggers	9	36	1384	2	riggers
ringer	7	45	2606	2	ringer
rugger	8	44	1451	2	rugger
sagger	8	43	2107	2	sagger
sigher	10	38	1370	2	sigher
signer	7	40	1563	2	signer
singer	7	42	2731	2	singer
snigger	9	32	837	2	snigger
swigger	12	33	845	2	swigger
tagger	8	40	1770	2	tagger
tiger	6	57	1863	2	ti_ger
trigger	9	32	916	2	trigger
tugger	8	40	1310	2	tugger
wagger	11	36	1601	2	wagger
wigged	12	44	1358	2	wigged
wiggery	15	29	587	2	wiggery
wiggier	12	41	886	2	wiggier
wiggler	12	31	1076	2	wiggler
winger	10	41	2544	2	winger
zigged	18	41	1019	2	zigged
zinger	16	38	1670	2	zinger

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.360	496363.9
2	DLD Change Limit	82551	100	2.376	34743.7
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	2.766	64602.7