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

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

65 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
jiggled	17	35	884	(None)
giggled	11	40	1007	1	giggled
higgled	13	33	907	1	higgled
jigged	16	44	1277	1	jigg_ed
jiggle	15	38	1199	1	jiggle_
jiggles	16	41	1143	1	jiggles
jingled	16	41	1106	1	jingled
joggled	17	39	843	1	joggled
juggled	17	34	865	1	juggled
niggled	10	31	920	1	niggled
wiggled	13	29	960	1	wiggled
boggled	12	40	900	2	boggled
daggled	11	32	946	2	daggled
digged	10	43	1465	2	digg_ed
figged	12	40	1389	2	figg_ed
gaggled	11	35	991	2	gaggled
gigged	10	41	1229	2	gigg_ed
giggle	9	43	1351	2	giggle_
giggler	10	102	988	2	giggler
giggles	10	33	1293	2	giggles
goggled	11	34	895	2	goggled
guggled	11	33	856	2	guggled
haggled	13	35	928	2	haggled
higgle	11	38	1174	2	higgle_
higgler	12	36	980	2	higgler
higgles	12	39	1180	2	higgles
igged	8	60	1276	2	_igg_ed
jagged	16	41	1535	2	jagg_ed
jangled	16	41	1156	2	jangled
jigger	15	53	1305	2	jigg_er
jiggered	18	3	420	2	jiggered
jiggier	16	37	782	2	jiggier
jigglier	17	5	409	2	jigglier
jiggly	18	37	871	2	jiggl_y
jingle	14	38	1522	2	jingle_
jingler	15	43	1109	2	jingler
jingles	15	38	1638	2	jingles
jogged	16	60	1592	2	jogg_ed
joggle	15	40	1035	2	joggle_
joggler	16	39	883	2	joggler
joggles	16	44	1041	2	joggles
jugged	16	38	1393	2	jugg_ed
juggle	15	43	1028	2	juggle_
juggler	16	41	887	2	juggler
juggles	16	45	1084	2	juggles
jungled	16	34	964	2	jungled
miggle	10	40	1211	2	miggle_
miggles	11	35	1203	2	miggles
mingled	11	36	1273	2	mingled
niggle	8	36	1282	2	niggle_
niggler	9	36	1029	2	niggler
niggles	9	35	1220	2	niggles
pigged	11	42	1415	2	pigg_ed
rigged	9	45	1740	2	rigg_ed
singled	9	39	1468	2	singled
sniggled	11	27	574	2	sniggled
tingled	9	37	1280	2	tingled
toggled	10	42	865	2	toggled
waggled	13	38	936	2	waggled
wigged	12	44	1358	2	wigg_ed
wiggle	11	37	1301	2	wiggle_
wiggler	12	31	1076	2	wiggler
wiggles	12	33	1246	2	wiggles
wriggled	14	28	466	2	wriggled
zigged	18	41	1019	2	zigg_ed

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.373	479064.3
2	DLD Change Limit	107671	65	2.750	39153.1
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	3.156	56619.5