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

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

60 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
ridgy	10	41	1064	(None)
ridge	7	50	1867	1	ridge
aridly	10	55	1370	2	aridly
biddy	12	46	1269	2	biddy
biggy	12	44	1313	2	biggy
bilgy	11	47	1371	2	bilgy
bridge	10	37	1188	2	bridge
cadgy	12	52	1078	2	cadgy
didy	9	91	2151	2	did_y
dingy	10	57	2126	2	dingy
dodgy	11	66	1146	2	dodgy
edgy	9	47	1353	2	_edgy
fidge	10	45	1606	2	fidge
fridge	11	37	925	2	fridge
fringy	13	30	926	2	fringy
giddy	11	58	1020	2	giddy
hedgy	13	45	1075	2	hedgy
idly	8	56	1732	2	_idly
jiggy	17	54	914	2	jiggy
kiddy	14	49	1028	2	kiddy
ledgy	10	57	1202	2	ledgy
lingy	9	69	2514	2	lingy
middy	12	48	1259	2	middy
midge	9	50	1655	2	midge
mingy	11	55	2018	2	mingy
piggy	12	40	1143	2	piggy
podgy	12	56	1077	2	podgy
pudgy	12	49	1116	2	pudgy
raggy	10	61	1657	2	raggy
rangy	9	53	2039	2	rangy
redly	9	42	1720	2	redly
redry	9	43	1436	2	redry
ribby	12	41	968	2	ribby
rid	4	67	5463	2	rid__
ride	5	59	4513	2	rid_e
rider	6	52	3130	2	rider
rides	6	61	4081	2	rides
ridged	9	40	1422	2	ridged
ridgel	8	39	997	2	ridgel
ridges	8	58	1701	2	ridges
ridgil	8	31	682	2	ridgil
ridley	10	16	954	2	ridley
rids	5	65	3955	2	rid_s
rig	4	67	4812	2	ri_g_
rigs	5	51	3759	2	ri_gs
riley	8	44	2058	2	riley
rimy	9	66	2128	2	ri_my
rindy	9	57	1739	2	rindy
ring	5	65	4115	2	ring_
rings	6	50	2917	2	rings
risky	12	63	1152	2	risky
ritzy	17	56	1116	2	ritzy
ruddy	10	45	1175	2	ruddy
sedgy	10	45	1279	2	sedgy
tidy	8	68	2242	2	tid_y
wedgy	13	47	980	2	wedgy
widdy	13	61	1218	2	widdy
wiggy	13	45	1073	2	wiggy
wingy	12	65	2103	2	wingy
zingy	18	65	1613	2	zingy

Search took 2 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.310	576422.6
2	DLD Change Limit	53800	60	1.593	33772.8
3	Display Results	60	60	0.016	3750.0
	(SQL Overall)	178691	60	1.919	93116.7