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

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

67 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
wiggy	13	45	1073	(None)
biggy	12	44	1313	1	biggy
jiggy	17	54	914	1	jiggy
piggy	12	40	1143	1	piggy
twiggy	14	3	293	1	twiggy
wiggly	14	55	968	1	wiggly
wingy	12	65	2103	1	wingy
baggy	12	56	1568	2	baggy
bigly	11	48	1475	2	bigly
bilgy	11	47	1371	2	bilgy
boggy	12	61	1607	2	boggy
buggy	12	46	1348	2	buggy
dingy	10	57	2126	2	dingy
doggy	11	52	1487	2	doggy
eggy	9	66	1185	2	_eggy
faggy	13	65	1437	2	faggy
foggy	13	67	1454	2	foggy
fuggy	13	54	1167	2	fuggy
giggly	12	51	870	2	giggly
igg	5	71	1679	2	_igg_
iggs	6	66	1267	2	_iggs
jaggy	17	59	1314	2	jaggy
jiggly	18	37	871	2	jiggly
leggy	10	52	1024	2	leggy
lingy	9	69	2514	2	lingy
loggy	10	57	1419	2	loggy
migg	8	57	1680	2	migg_
miggs	9	63	1137	2	miggs
mingy	11	55	2018	2	mingy
moggy	12	52	1216	2	moggy
muggy	12	56	1237	2	muggy
naggy	10	66	1282	2	naggy
niggly	11	41	891	2	niggly
pigmy	13	29	943	2	pigmy
puggy	12	46	1232	2	puggy
raggy	10	61	1657	2	raggy
ridgy	10	41	1064	2	ridgy
saggy	10	59	1746	2	saggy
soggy	10	54	1390	2	soggy
swingy	13	48	987	2	swingy
vuggy	13	58	948	2	vuggy
waggly	14	34	729	2	waggly
wedgy	13	47	980	2	wedgy
widdy	13	61	1218	2	widdy
wifey	14	49	1367	2	wifey
wifty	14	42	1209	2	wifty
wig	7	67	4038	2	wi_g_
wigan	9	51	1439	2	wigan
wigged	12	44	1358	2	wigged
wiggery	15	29	587	2	wiggery
wiggle	11	37	1301	2	wiggle
wight	12	37	2557	2	wight
wigs	8	49	3125	2	wi_gs
willy	11	53	2191	2	willy
wily	10	64	2881	2	wi_ly
wimpy	15	59	1192	2	wimpy
windy	12	61	1810	2	windy
winey	11	53	2543	2	winey
wing	8	63	3922	2	wing_
wings	9	57	2724	2	wings
winy	10	70	3432	2	wi_ny
wiry	10	64	2283	2	wi_ry
wispy	13	72	1097	2	wispy
withy	14	48	1376	2	withy
witty	11	47	1701	2	witty
wriggly	15	32	489	2	wriggly
zingy	18	65	1613	2	zingy

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	53800	0.606	294869.6
2	DLD Change Limit	53800	67	3.110	17299.0
3	Display Results	67	67	0.050	1340.0
	(SQL Overall)	178691	67	3.766	47448.5