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

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

59 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
higgler	12	36	980	(None)
giggler	10	102	988	1	giggler
haggler	12	32	893	1	haggler
higgle	11	38	1174	1	higgle_
higgled	13	33	907	1	higgled
higglers	13	29	723	1	higglers
higgles	12	39	1180	1	higgles
niggler	9	36	1029	1	niggler
wiggler	12	31	1076	1	wiggler
bigger	10	43	1506	2	bigg_er
boggler	11	39	1008	2	boggler
chigger	14	3	600	2	chigg_er
digger	9	46	1608	2	digg_er
giggle	9	43	1351	2	giggle_
giggled	11	40	1007	2	giggled
gigglers	11	29	740	2	gigglers
giggles	10	33	1293	2	giggles
gigglier	11	5	432	2	gigglier
goggler	10	37	932	2	goggler
haggle	11	35	1198	2	haggle_
haggled	13	35	928	2	haggled
hagglers	13	32	662	2	hagglers
haggles	12	33	1248	2	haggles
higher	13	46	1089	2	hi_gher
hiller	9	44	2163	2	hi_ller
hinger	10	47	2333	2	hing_er
hogger	11	46	1508	2	hogg_er
hugger	11	47	1312	2	hugg_er
jigger	15	53	1305	2	jigg_er
jiggier	16	37	782	2	jiggier
jiggle	15	38	1199	2	jiggle_
jiggled	17	35	884	2	jiggled
jiggles	16	41	1143	2	jiggles
jigglier	17	5	409	2	jigglier
jingler	15	43	1109	2	jingler
joggler	16	39	883	2	joggler
juggler	16	41	887	2	juggler
miggle	10	40	1211	2	miggle_
miggles	11	35	1203	2	miggles
mingler	10	42	1384	2	mingler
nigger	8	97	1357	2	nigg_er
niggle	8	36	1282	2	niggle_
niggled	10	31	920	2	niggled
nigglers	10	30	725	2	nigglers
niggles	9	35	1220	2	niggles
nigglier	10	4	484	2	nigglier
piggier	11	35	1000	2	piggier
rigger	8	56	1671	2	rigg_er
shingler	12	26	863	2	shingler
sniggler	10	39	611	2	sniggler
tingler	8	36	1334	2	tingler
toggler	9	39	919	2	toggler
wiggier	12	41	886	2	wiggier
wiggle	11	37	1301	2	wiggle_
wiggled	13	29	960	2	wiggled
wigglers	13	25	721	2	wigglers
wiggles	12	33	1246	2	wiggles
wigglier	13	5	445	2	wigglier
wriggler	13	29	526	2	wriggler

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.143	1249587.4
2	DLD Change Limit	107671	59	3.670	29338.1
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	3.829	46667.8