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

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

79 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
jangler	15	38	1183	(None)
angler	7	40	1786	1	_angler
dangler	9	69	1281	1	dangler
jangle	14	44	1629	1	jangle_
jangled	16	41	1156	1	jangled
janglers	16	31	937	1	janglers
jangles	15	40	1568	1	jangles
janglier	16	5	611	1	janglier
jingler	15	43	1109	1	jingler
mangler	10	32	1564	1	mangler
tangler	8	35	1507	1	tangler
wangler	11	33	1265	1	wangler
anger	6	62	2587	2	_ang_er
angle	6	45	2887	2	_angle_
angled	8	42	1907	2	_angled
anglers	8	40	1482	2	_anglers
angles	7	44	2670	2	_angles
antler	6	46	1555	2	_antler
banger	9	44	2363	2	bang_er
bangle	9	40	1895	2	bangle_
bangles	10	36	1741	2	bangles
bungler	10	46	1148	2	bungler
candler	10	35	1659	2	candler
dandler	9	44	1427	2	dandler
danger	8	37	2282	2	dang_er
dangle	8	41	1930	2	dangle_
dangled	10	40	1315	2	dangled
danglers	10	36	1059	2	danglers
dangles	9	36	1842	2	dangles
danglier	10	5	675	2	danglier
ganger	8	37	2146	2	gang_er
ganglier	10	4	760	2	ganglier
gargler	9	37	1026	2	gargler
haggler	12	32	893	2	haggler
handler	11	35	1616	2	handler
hanger	10	40	2325	2	hang_er
jaeger	14	39	719	2	jaeg_er
jager	13	43	1813	2	ja_g_er
jagger	15	40	1600	2	ja_gger
jaggier	16	33	918	2	jaggier
jailer	13	43	1668	2	ja_iler
jangly	17	43	1060	2	jangl_y
jingle	14	38	1522	2	jingle_
jingled	16	41	1106	2	jingled
jinglers	16	40	876	2	jinglers
jingles	15	38	1638	2	jingles
jinglier	16	5	523	2	jinglier
joggler	16	39	883	2	joggler
jongleur	16	4	202	2	jongleur
juggler	16	41	887	2	juggler
jungle	14	40	1265	2	jungle_
jungled	16	34	964	2	jungled
jungles	15	41	1254	2	jungles
junglier	16	4	430	2	junglier
landler	8	41	1320	2	landler
langley	11	4	745	2	langley
manger	9	43	2500	2	mang_er
mangier	10	41	1406	2	mangier
mangle	9	39	2132	2	mangle_
mangled	11	36	1525	2	mangled
manglers	11	33	1190	2	manglers
mangles	10	40	2146	2	mangles
mingler	10	42	1384	2	mingler
ranger	7	39	2552	2	rang_er
rangier	8	37	1435	2	rangier
sanger	7	45	2456	2	sang_er
tangier	8	30	1390	2	tangier
tangle	7	40	1995	2	tangle_
tangled	9	42	1463	2	tangled
tanglers	9	29	1197	2	tanglers
tangles	8	39	2004	2	tangles
tanglier	9	4	807	2	tanglier
tingler	8	36	1333	2	tingler
twangler	12	4	411	2	twangler
wangle	10	38	1750	2	wangle_
wangled	12	33	1241	2	wangled
wanglers	12	33	1003	2	wanglers
wangles	11	34	1693	2	wangles
wrangler	12	4	547	2	wrangler

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	79	3.593	29966.9
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	3.766	47448.5