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

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

104 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
dyked	14	53	1095	(None)
deked	11	57	1853	1	deked
diked	11	50	2468	1	diked
duked	11	52	1846	1	duked
dyed	9	67	2076	1	dy_ed
dyke	12	64	1818	1	dyke_
dykes	13	52	1557	1	dykes
dykey	16	60	867	1	dykey
ryked	13	66	951	1	ryked
asked	10	69	1931	2	asked
baked	12	61	3077	2	baked
biked	12	53	2003	2	biked
caked	12	61	2862	2	caked
coked	12	47	3069	2	coked
dared	7	59	3501	2	dared
darked	12	39	1963	2	darked
dated	7	55	3099	2	dated
dawed	10	62	2281	2	dawed
daybed	13	43	867	2	daybed
dazed	16	59	1936	2	dazed
decked	14	52	1762	2	decked
deed	6	53	4090	2	d_eed
deke	9	52	2876	2	deke_
dekes	10	52	2445	2	dekes
deled	7	53	2654	2	deled
dewed	10	50	2030	2	dewed
diced	9	58	2468	2	diced
dicked	14	49	2086	2	dicked
died	6	61	3785	2	d_ied
dike	9	59	3576	2	dike_
diker	10	55	2455	2	diker
dikes	10	58	3133	2	dikes
dikey	13	51	1642	2	dikey
dined	7	64	3199	2	dined
dinked	12	48	1835	2	dinked
dirked	12	49	1227	2	dirked
disked	12	50	1576	2	disked
dived	10	63	2137	2	dived
docked	14	50	1833	2	docked
doled	7	54	3091	2	doled
domed	9	54	2326	2	domed
doped	9	53	2671	2	doped
dosed	7	66	2691	2	dosed
doted	7	52	2707	2	doted
dowed	10	46	3261	2	dowed
dozed	16	56	1935	2	dozed
dreed	7	52	2284	2	dreed
dried	7	53	2138	2	dried
ducked	14	47	1801	2	ducked
duded	8	44	1713	2	duded
duke	9	56	2810	2	duke_
dukes	10	50	2347	2	dukes
dunked	12	43	1528	2	dunked
duped	9	51	1832	2	duped
dured	7	50	2540	2	dured
dusked	12	41	1251	2	dusked
dyad	9	64	1545	2	dy_ad
dye	7	53	3484	2	dy_e_
dyer	8	55	2211	2	dy_er
dyes	8	53	3189	2	dy_es
dyne	8	53	2093	2	dyne_
dynel	9	56	985	2	dynel
dynes	9	59	1758	2	dynes
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
raked	10	58	3142	2	raked
ryke	11	56	1640	2	ryke_
rykes	12	55	1303	2	rykes
skyed	13	52	992	2	skyed
syke	11	54	2056	2	syke_
sykes	12	48	1686	2	sykes
toked	10	56	2649	2	toked
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.296	603685.8
2	DLD Change Limit	53800	104	1.500	35866.7
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	1.826	97859.3