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

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

98 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
hyped	14	53	1333	(None)
hoped	11	56	2818	1	hoped
hype	12	55	1981	1	hype_
hyper	13	52	1390	1	hyper
hypes	13	58	1867	1	hypes
hypoed	15	4	792	1	hypoed
typed	11	58	1545	1	typed
amped	10	48	2051	2	amped
aped	7	85	3815	2	_aped
biped	10	47	1883	2	biped
caped	10	49	3180	2	caped
coped	10	50	3684	2	coped
doped	9	53	2671	2	doped
duped	9	51	1832	2	duped
dyed	9	67	2076	2	dy_ed
dyked	14	53	1095	2	dyked
eyed	8	66	2323	2	ey_ed
gaped	9	61	2353	2	gaped
gybed	12	58	1102	2	gybed
gypped	15	37	711	2	gypped
gyred	10	51	1409	2	gyred
gyved	13	56	874	2	gyved
haded	10	52	2762	2	haded
haed	8	63	3858	2	h_aed
haled	9	53	3582	2	haled
happed	14	48	2010	2	happed
hared	9	57	4218	2	hared
harped	12	44	1840	2	harped
hasped	12	50	1444	2	hasped
hated	9	57	3402	2	hated
hawed	12	60	2542	2	hawed
hayed	12	58	2201	2	hayed
hazed	18	52	2220	2	hazed
heaped	12	45	1690	2	heaped
heed	8	64	3760	2	h_eed
helped	12	47	1415	2	helped
hewed	12	56	1943	2	hewed
hexed	16	56	1576	2	hexed
hided	10	52	2244	2	hided
hied	8	54	3404	2	h_ied
hiked	13	59	1920	2	hiked
hipped	14	43	1769	2	hipped
hired	9	52	2626	2	hired
hived	12	52	1791	2	hived
hoed	8	78	3798	2	h_oed
hoked	13	53	2699	2	hoked
holed	9	56	3413	2	holed
homed	11	54	2542	2	homed
honed	9	53	3226	2	honed
hooped	12	55	1818	2	hooped
hope	9	66	3967	2	hope_
hoper	10	58	2914	2	hoper
hopes	10	58	3564	2	hopes
hopped	14	43	1811	2	hopped
hosed	9	58	3098	2	hosed
hued	8	69	2585	2	h_ued
humped	14	40	1524	2	humped
hymen	13	3	1104	2	hymen
hymned	15	3	532	2	hymned
hyoid	12	6	1244	2	hyoid
hyp	11	78	2246	2	hyp__
hypers	14	48	1191	2	hypers
hypha	16	3	738	2	hypha
hyphen	17	3	639	2	hyphen
hypo	12	75	1635	2	hyp_o
hypos	13	120	1474	2	hypos
hyps	12	54	1841	2	hyp_s
hyte	10	90	1894	2	hyte_
imped	10	51	1798	2	imped
japed	15	62	1763	2	japed
loped	8	51	2833	2	loped
lysed	9	50	1156	2	lysed
moped	10	54	2473	2	moped
oped	7	62	3015	2	_oped
ped	6	67	5152	2	__ped
physed	15	38	679	2	physed
piped	10	51	2316	2	piped
raped	8	53	3462	2	raped
rhymed	15	41	671	2	rhymed
riped	8	52	2643	2	riped
roped	8	46	3080	2	roped
ryked	13	66	951	2	ryked
shaped	12	50	2010	2	shaped
siped	8	49	2768	2	siped
sped	7	60	3149	2	_sped
taped	8	53	2742	2	taped
toped	8	56	3131	2	toped
tyned	9	59	1501	2	tyned
type	9	62	2374	2	type_
types	10	57	2106	2	types
typey	13	55	1188	2	typey
tyred	9	58	1643	2	tyred
umped	10	47	1727	2	umped
upped	10	37	1516	2	upped
urped	8	46	1528	2	urped
wiped	11	47	2208	2	wiped
wyled	12	46	1184	2	wyled
wyted	12	52	947	2	wyted

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.326	548131.9
2	DLD Change Limit	53800	98	1.580	34050.6
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	1.936	92299.1