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

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

83 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
hardhead	16	4	588	(None)
hardheads	17	4	577	1	hardheads
baldhead	15	4	427	2	baldhead
barehead	14	4	660	2	barehead
handheld	16	4	446	2	handheld
hardhat	14	4	1102	2	hardh_at
hardheaded	19	5	385	2	hardheaded
hashhead	14	4	326	2	hashhead
jarhead	18	3	517	2	jar_head
warhead	14	3	660	2	war_head
acidhead	15	4	279	3	acidhead
ahead	9	68	1705	3	_a__head
airhead	11	3	699	3	_airhead
archean	12	6	912	3	_archean
arched	12	57	1732	3	_arche_d
baldheads	16	4	413	3	baldheads
barded	10	54	2642	3	bard_e_d
carded	10	54	2490	3	card_e_d
cathead	13	3	875	3	ca_thead
deadhead	14	4	443	3	deadhead
earthed	11	3	992	3	earthe_d
farded	11	45	1895	3	fard_e_d
fathead	14	3	786	3	fa_thead
forehead	15	3	789	3	forehead
gearhead	13	4	444	3	gear_head
godhead	13	3	476	3	_godhead
haded	10	52	2762	3	ha_d_e_d
handed	11	49	1998	3	hand_e_d
handhelds	17	4	376	3	handhelds
handhold	16	4	563	3	handhold
handled	12	41	1453	3	handle_d
hardboard	16	4	558	3	hardboard
harden	10	57	1853	3	hard_e_n
hardened	13	3	861	3	hardened
hardens	11	38	1502	3	hard_ens
harder	10	50	2240	3	hard_e_r
hardest	11	31	1841	3	hard_est
hardhack	21	4	384	3	hardhack
hardhats	15	4	683	3	hardhats
hardier	11	47	2154	3	hardie_r
hardies	11	49	2323	3	hardie_s
hardiest	12	34	1634	3	hardiest
hardihood	17	5	280	3	hardihood
hardness	12	24	1108	3	hardness
hardpan	13	3	644	3	hard_pan
hardset	11	34	1583	3	hardse_t
hardstand	14	4	447	3	hardstand
hardwood	16	15	574	3	hardwood
hared	9	57	4218	3	har__e_d
harked	14	54	2255	3	har_ke_d
harmed	12	52	1883	3	har_me_d
harped	12	44	1840	3	har_pe_d
harried	11	38	1554	3	harrie_d
harshen	13	3	928	3	harshe_n
harshened	16	4	445	3	harshened
harshens	14	3	760	3	harshens
harsher	13	3	1036	3	harshe_r
harshest	14	3	1019	3	harshest
hashed	13	60	2194	3	ha_she_d
hashheads	15	4	339	3	hashheads
hatched	16	34	1446	3	hatche_d
herded	11	42	1564	3	herd_e_d
hoarded	12	36	834	3	hoard_e_d
hogshead	16	7	392	3	hogshead
hophead	16	33	792	3	h_ophead
horded	11	54	2048	3	hord_e_d
hothead	14	34	929	3	h_othead
hurdled	12	37	983	3	hurdle_d
jarheads	19	4	479	3	jar_heads
larded	8	43	1909	3	lard_e_d
marched	15	38	1340	3	marche_d
masthead	14	3	588	3	masthead
nailhead	12	4	398	3	nailhead
parched	15	40	1369	3	parche_d
railhead	12	4	419	3	railhead
redhead	12	5	705	3	_redhead
saphead	13	5	777	3	sa_phead
scarehead	15	4	380	3	scarehead
shorthead	16	4	447	3	shorthead
sorehead	12	4	697	3	sorehead
warded	11	50	2104	3	ward_e_d
warheads	15	4	585	3	war_heads
yarded	11	47	1402	3	yard_e_d

Search took 10 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.856	208751.2
2	DLD Change Limit	146162	83	8.160	17912.0
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	9.046	19753.6