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

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

71 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
jiggles	16	41	1143	(None)
giggles	10	33	1293	1	giggles
higgles	12	39	1180	1	higgles
jiggle	15	38	1199	1	jiggle_
jiggled	17	35	884	1	jiggled
jingles	15	38	1638	1	jingles
joggles	16	44	1041	1	joggles
juggles	16	45	1084	1	juggles
miggles	11	35	1203	1	miggles
niggles	9	35	1220	1	niggles
wiggles	12	33	1246	1	wiggles
biggies	11	38	1352	2	biggies
boggles	11	34	1182	2	boggles
daggles	10	36	1191	2	daggles
dingles	9	38	1832	2	dingles
gaggles	10	35	1259	2	gaggles
giggle	9	43	1351	2	giggle_
giggled	11	40	1007	2	giggled
giggler	10	102	988	2	giggler
gigglers	11	29	740	2	gigglers
goggles	10	35	1079	2	goggles
guggles	10	34	1054	2	guggles
haggles	12	33	1248	2	haggles
higgle	11	38	1174	2	higgle_
higgled	13	33	907	2	higgled
higgler	12	36	980	2	higgler
higglers	13	29	723	2	higglers
ingles	7	44	2087	2	_ingles
jaggies	16	33	1108	2	jaggies
jangles	15	40	1568	2	jangles
jigged	16	44	1277	2	jigg_ed
jigger	15	53	1305	2	jigg_er
jiggers	16	40	1018	2	jiggers
jiggier	16	37	782	2	jiggier
jiggiest	17	27	769	2	jiggiest
jigglier	17	5	409	2	jigglier
jiggliest	18	5	418	2	jiggliest
jiggly	18	37	871	2	jiggl_y
jingle	14	38	1522	2	jingle_
jingled	16	41	1106	2	jingled
jingler	15	43	1109	2	jingler
jinglers	16	40	876	2	jinglers
jingoes	15	38	1144	2	jingoes
joggle	15	40	1035	2	joggle_
joggled	17	39	843	2	joggled
joggler	16	39	883	2	joggler
jogglers	17	35	688	2	jogglers
juggle	15	43	1028	2	juggle_
juggled	17	34	865	2	juggled
juggler	16	41	887	2	juggler
jugglers	17	36	652	2	jugglers
jungles	15	41	1254	2	jungles
ligules	8	22	1092	2	ligules
miggle	10	40	1211	2	miggle_
mingles	10	37	1900	2	mingles
niggle	8	36	1282	2	niggle_
niggled	10	31	920	2	niggled
niggler	9	36	1029	2	niggler
nigglers	10	30	725	2	nigglers
piggies	11	38	1348	2	piggies
raggles	9	38	1328	2	raggles
singles	8	35	2043	2	singles
sniggles	10	30	731	2	sniggles
tingles	8	38	1832	2	tingles
toggles	9	37	1097	2	toggles
waggles	12	38	1200	2	waggles
wiggle	11	37	1301	2	wiggle_
wiggled	13	29	960	2	wiggled
wiggler	12	31	1076	2	wiggler
wigglers	13	25	721	2	wigglers
wriggles	13	28	626	2	wriggles

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	71	3.080	34958.1
3	Display Results	71	71	0.013	5461.5
	(SQL Overall)	178691	71	3.466	51555.4