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

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

86 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
jingle	14	38	1522	(None)
dingle	8	43	1707	1	dingle
ingle	6	41	2043	1	_ingle
jangle	14	44	1629	1	jangle
jiggle	15	38	1199	1	jiggle
jingled	16	41	1106	1	jingled
jingler	15	43	1109	1	jingler
jingles	15	38	1638	1	jingles
jingly	17	41	1193	1	jingly
jungle	14	40	1265	1	jungle
mingle	9	35	1878	1	mingle
single	7	45	2060	1	single
tingle	7	43	1906	1	tingle
angle	6	45	2887	2	_angle
atingle	8	4	825	2	atingle
bangle	9	40	1895	2	bangle
bindle	9	45	1626	2	bindle
binge	8	51	2551	2	bing_e
bungle	9	71	1611	2	bungle
cringle	10	30	1035	2	cringle
dangle	8	41	1930	2	dangle
dindle	8	44	1722	2	dindle
dinge	7	56	2730	2	ding_e
dingles	9	38	1832	2	dingles
dongle	8	36	1249	2	dongle
finagle	11	23	831	2	finagle
finale	9	41	1676	2	finale
giggle	9	43	1351	2	giggle
higgle	11	38	1174	2	higgle
hinge	9	53	2345	2	hing_e
ingles	7	44	2087	2	_ingles
inkle	9	45	1583	2	_inkle
jangled	16	41	1156	2	jangled
jangler	15	38	1183	2	jangler
jangles	15	40	1568	2	jangles
jangly	17	43	1060	2	jangly
jiggled	17	35	884	2	jiggled
jiggles	16	41	1143	2	jiggles
jiggly	18	37	871	2	jiggly
jingal	14	9	859	2	jingal
jingall	15	6	617	2	jingall
jingals	15	8	807	2	jingals
jingko	18	50	537	2	jingko
jinglers	16	40	876	2	jinglers
jinglier	16	5	523	2	jinglier
jingo	13	46	1521	2	jing_o
jingoes	15	38	1144	2	jingoes
jinnee	13	4	1157	2	jinnee
joggle	15	40	1035	2	joggle
juggle	15	43	1028	2	juggle
jungled	16	34	964	2	jungled
jungles	15	41	1254	2	jungles
jungly	17	40	769	2	jungly
kindle	11	44	1423	2	kindle
kinglet	12	31	1404	2	kinglet
kingly	14	35	1130	2	kingly
mangle	9	39	2132	2	mangle
miggle	10	40	1211	2	miggle
mingled	11	36	1273	2	mingled
mingler	10	42	1384	2	mingler
mingles	10	37	1900	2	mingles
niggle	8	36	1282	2	niggle
pinole	8	32	1878	2	pinole
pintle	8	38	1826	2	pintle
pungle	9	44	1357	2	pungle
ringlet	8	28	1817	2	ringlet
shingle	11	77	1128	2	shingle
singe	6	57	3113	2	sing_e
singled	9	39	1468	2	singled
singles	8	35	2043	2	singles
singlet	8	41	2011	2	singlet
singly	10	40	1585	2	singly
swingle	11	35	1056	2	swingle
tangle	7	40	1995	2	tangle
tinge	6	46	2662	2	ting_e
tingled	9	37	1280	2	tingled
tingler	8	36	1334	2	tingler
tingles	8	38	1832	2	tingles
tingly	10	38	1597	2	tingly
tinkle	10	37	1445	2	tinkle
wangle	10	38	1750	2	wangle
wiggle	11	37	1301	2	wiggle
windle	10	46	1795	2	windle
winglet	11	31	1598	2	winglet
winkle	13	38	1283	2	winkle
wintle	9	40	1460	2	wintle

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.106	1685764.2
2	DLD Change Limit	82551	86	2.470	33421.5
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	2.606	68569.1