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

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

84 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
risky	12	63	1152	(None)
frisky	16	40	667	1	frisky
risk	8	57	2411	1	risk_
risks	9	49	1706	1	risks
bisk	10	65	2336	2	bisk_
bisks	11	54	1680	2	bisks
bosky	14	56	1239	2	bosky
bricky	17	48	909	2	bricky
brisk	11	56	1598	2	brisk_
briskly	16	16	540	2	briskly
brisks	12	46	1140	2	brisks
casky	14	45	1268	2	casky
cissy	10	48	1107	2	cissy
crispy	13	47	856	2	crispy
dicky	15	48	1624	2	dicky
dinky	13	58	1937	2	dinky
dishy	12	57	1235	2	dishy
disk	9	66	2584	2	disk_
disks	10	54	1747	2	disks
drosky	14	48	616	2	drosky
dusky	13	52	1304	2	dusky
ensky	12	3	509	2	ensky
fishy	14	60	1166	2	fishy
frisk	12	53	1237	2	frisk_
frisks	13	47	926	2	frisks
grisly	10	43	1058	2	grisly
hinky	15	56	1875	2	hinky
hissy	11	61	1212	2	hissy
husky	15	61	1256	2	husky
icky	13	63	1575	2	_icky
inky	11	53	2158	2	_inky
kicky	13	50	1234	2	kicky
kinky	11	58	1639	2	kinky
kissy	12	55	1032	2	kissy
linky	12	76	2238	2	linky
milky	14	40	1444	2	milky
mirky	14	63	1552	2	mirky
missy	10	56	1756	2	missy
misty	10	61	2045	2	misty
musky	14	47	1529	2	musky
pesky	14	59	1156	2	pesky
picky	16	54	1694	2	picky
pinky	14	58	2340	2	pinky
plisky	15	3	371	2	plisky
pricky	17	42	1034	2	pricky
prissy	11	34	785	2	prissy
raspy	10	65	1170	2	raspy
reeky	12	54	1626	2	reeky
resay	8	53	2054	2	resay
ribby	12	41	968	2	ribby
rick	10	73	3466	2	rick_
rickey	15	46	1397	2	rickey
ricks	11	51	2613	2	ricks
ridgy	10	41	1065	2	ridgy
riley	8	44	2058	2	riley
rimy	9	66	2129	2	ri_my
rindy	9	57	1740	2	rindy
rink	8	77	3700	2	rink_
rinks	9	48	2710	2	rinks
rise	4	59	4524	2	ris_e
risen	5	46	2188	2	risen
riser	5	54	3105	2	riser
rises	5	52	4404	2	rises
rishi	8	3	1125	2	rishi
risked	11	55	1463	2	risked
risker	10	54	1449	2	risker
riskily	14	3	641	2	riskily
risus	5	42	1639	2	risus
ritzy	17	56	1116	2	ritzy
rocky	14	45	1385	2	rocky
rooky	12	61	1762	2	rooky
rosy	7	60	2487	2	ros_y
rushy	11	54	1481	2	rushy
rusk	8	58	2331	2	rusk_
rusks	9	58	1619	2	rusks
rusty	8	52	2105	2	rusty
silky	12	53	1582	2	silky
sissy	8	58	1207	2	sissy
sky	10	64	2099	2	__sky
tricky	15	42	1147	2	tricky
whisky	19	45	590	2	whisky
wispy	13	72	1097	2	wispy
wristy	12	50	970	2	wristy
zinky	21	53	1481	2	zinky

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	84	1.440	37361.1
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	1.780	100388.2