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

Here are the results of your fuzzy-string dictionary search for “ryked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
ryked	13	66	951	(None)
dyked	14	53	1095	1	dyked
raked	10	58	3142	1	raked
ryke	11	56	1640	1	ryke_
rykes	12	55	1303	1	rykes
arcked	13	62	1194	2	arcked
asked	10	69	1931	2	asked
baked	12	61	3077	2	baked
biked	12	53	2003	2	biked
braked	13	53	1869	2	braked
caked	12	61	2862	2	caked
coked	12	47	3069	2	coked
deked	11	57	1853	2	deked
diked	11	50	2468	2	diked
duked	11	52	1846	2	duked
dyed	9	67	2076	2	dy_ed
dyke	12	64	1818	2	dyke_
dykes	13	52	1557	2	dykes
dykey	16	60	867	2	dykey
eked	9	67	1802	2	_eked
eyed	8	66	2323	2	ey_ed
faked	13	52	2548	2	faked
fyke	14	59	1529	2	fyke_
fykes	15	63	1269	2	fykes
gybed	12	58	1102	2	gybed
gyred	10	51	1409	2	gyred
gyved	13	56	874	2	gyved
hiked	13	59	1920	2	hiked
hoked	13	53	2699	2	hoked
hyped	14	53	1333	2	hyped
inked	10	42	1852	2	inked
irked	10	45	1092	2	irked
joked	17	52	1791	2	joked
juked	17	57	1407	2	juked
laked	10	57	3112	2	laked
liked	10	45	2381	2	liked
lysed	9	50	1156	2	lysed
miked	12	50	2045	2	miked
naked	10	53	2085	2	naked
nuked	10	40	1418	2	nuked
piked	12	56	2331	2	piked
poked	12	54	2539	2	poked
puked	12	47	1622	2	puked
raced	8	76	3531	2	raced
racked	13	45	2608	2	racked
raged	7	48	2945	2	raged
rake	8	48	4157	2	rake_
rakee	9	60	3117	2	rakee
raker	9	45	2979	2	raker
rakes	9	44	4035	2	rakes
ranked	11	46	2074	2	ranked
raped	8	53	3462	2	raped
rared	6	57	3832	2	rared
rased	6	50	3393	2	rased
rated	6	54	4138	2	rated
raved	9	49	3143	2	raved
raxed	13	56	2266	2	raxed
rayed	9	51	2750	2	rayed
razed	15	50	2798	2	razed
recked	13	48	2180	2	recked
red	4	67	5580	2	r__ed
reded	7	48	2911	2	reded
reed	5	55	4962	2	r_eed
reeked	11	37	1764	2	reeked
refed	9	39	2192	2	refed
rekey	12	40	1473	2	rekey
rewed	9	54	2545	2	rewed
rhymed	15	41	671	2	rhymed
riced	8	58	2554	2	riced
ricked	13	65	2362	2	ricked
riled	6	58	3325	2	riled
rimed	8	48	2637	2	rimed
riped	8	52	2643	2	riped
risked	11	55	1463	2	risked
rived	9	48	2561	2	rived
robed	8	53	2373	2	robed
rocked	13	50	2232	2	rocked
rooked	11	49	1814	2	rooked
roped	8	46	3080	2	roped
rosed	6	59	3034	2	rosed
roved	9	53	2355	2	roved
rowed	9	40	3432	2	rowed
rucked	13	47	1876	2	rucked
rued	5	57	2979	2	r_ued
ruled	6	58	2252	2	ruled
rye	6	60	3254	2	ry_e_
ryes	7	55	2935	2	ry_es
rynd	8	64	1410	2	ry_nd
skyed	13	52	992	2	skyed
syke	11	54	2056	2	syke_
sykes	12	48	1686	2	sykes
toked	10	56	2649	2	toked
troked	11	41	1458	2	troked
tsked	10	59	1003	2	tsked
tyke	11	57	2050	2	tyke_
tykes	12	58	1706	2	tykes
tyned	9	59	1501	2	tyned
typed	11	58	1545	2	typed
tyred	9	58	1643	2	tyred
waked	13	56	2675	2	waked
wyled	12	46	1184	2	wyled
wyted	12	52	947	2	wyted
yoked	13	48	2162	2	yoked

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.093	1921408.6
2	DLD Change Limit	53800	103	1.393	38621.7
3	Display Results	103	103	0.030	3433.3
	(SQL Overall)	178691	103	1.516	117870.1