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

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

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.

61 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
drophead	15	4	461	(None)
dropheads	16	4	387	1	dropheads
dopehead	15	4	407	2	d_opehead
dropped	13	32	929	2	droppe_d
drumhead	15	4	265	2	drumhead
hophead	16	33	792	2	_hophead
arrowhead	16	4	179	3	arrowhead
bowhead	16	3	643	3	_bowhead
cohead	12	38	1112	3	_co_head
crisphead	17	4	266	3	crisphead
cropped	14	38	1207	3	croppe_d
crosshead	15	4	381	3	crosshead
deadhead	14	4	443	3	deadhead
dickhead	19	4	414	3	dickhead
dispread	12	4	710	3	dispread
doped	9	53	2671	3	d_op_e_d
dopeheads	16	4	414	3	d_opeheads
dragonhead	16	5	79	3	dragonhead
draped	10	53	1436	3	drap_e_d
dread	7	44	1902	3	dr___ead
dripped	13	40	808	3	drippe_d
drolled	9	38	1022	3	drolle_d
droned	8	46	1686	3	dro_ne_d
drooled	9	36	920	3	droole_d
drooped	11	36	843	3	droope_d
droplet	10	3	1211	3	drople_t
droplets	11	3	606	3	droplets
dropper	12	32	987	3	droppe_r
droppers	13	31	860	3	droppers
dropsied	12	3	497	3	dropsied
drouked	13	3	554	3	drouke_d
droved	11	46	1164	3	dro_ve_d
drowned	12	41	990	3	drowne_d
drowsed	12	44	875	3	drowse_d
drumheads	16	4	229	3	drumheads
dumbhead	17	10	274	3	dumbhead
forehead	15	3	789	3	forehead
frothed	14	28	878	3	frothe_d
godhead	13	3	476	3	_godhead
graphed	14	9	847	3	graphe_d
groped	10	75	1506	3	grop_e_d
hopheads	17	27	661	3	_hopheads
hothead	14	34	929	3	_hothead
morphed	15	3	713	3	morphe_d
plowhead	17	4	280	3	plowhead
pothead	13	38	1039	3	_pothead
propend	12	33	1127	3	prop_end
prophecy	20	4	391	3	prophecy
prophesy	18	4	445	3	prophesy
prophet	14	3	1603	3	prophe_t
prophets	15	3	950	3	prophets
propped	11	33	1196	3	proppe_d
redhead	12	5	705	3	_redhead
replead	10	39	901	3	_replead
roped	8	46	3081	3	_rop_e_d
saphead	13	5	777	3	_saphead
sorehead	12	4	697	3	sorehead
toolhead	12	4	435	3	toolhead
towhead	14	3	522	3	_towhead
trophied	14	3	765	3	trophied
trothed	11	40	1097	3	trothe_d

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	61	8.063	18127.5
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	8.499	21024.9