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

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

73 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
gearhead	13	4	444	(None)
gearheads	14	4	408	1	gearheads
deadhead	14	4	443	2	deadhead
geared	8	53	1774	2	gear_e_d
jarhead	18	3	517	2	_jarhead
meathead	14	3	679	2	meathead
spearhead	15	4	298	2	spearhead
warhead	14	3	660	2	_warhead
ahead	9	68	1705	3	__a_head
airhead	11	3	699	3	_airhead
barehead	14	4	660	3	_barehead
beached	15	45	1655	3	beache_d
beachhead	20	4	258	3	beachhead
bearded	11	42	1213	3	bearde_d
behead	12	3	992	3	be__head
cathead	13	3	875	3	_cathead
deadheads	15	4	402	3	deadheads
deashed	12	34	1130	3	deashe_d
eared	6	51	3950	3	_ear_e_d
earned	7	48	1833	3	_earne_d
earthed	11	3	992	3	_earthe_d
egghead	13	4	343	3	_egghead
fathead	14	3	786	3	_fathead
feared	10	63	2043	3	fear_e_d
flathead	15	3	581	3	flathead
garbed	10	48	1566	3	g_arbe_d
garred	8	52	1741	3	g_arre_d
gashed	11	63	2197	3	g_ashe_d
gearless	9	3	737	3	gearless
gearwheel	16	5	145	3	gearwheel
gilthead	13	4	333	3	gilthead
glared	8	47	1520	3	glar_e_d
gnarled	9	28	772	3	gnarle_d
gnarred	9	32	701	3	gnarre_d
gnashed	12	31	752	3	gnashe_d
goatherd	13	3	526	3	goatherd
godhead	13	3	476	3	g_odhead
graphed	14	9	847	3	graphe_d
greenhead	14	4	316	3	greenhead
guarded	10	3	615	3	guarde_d
hardhead	16	4	588	3	_hardhead
hearsed	11	38	1142	3	hearse_d
hearted	11	33	1403	3	hearte_d
jarheads	19	4	479	3	_jarheads
leached	13	37	1504	3	leache_d
learned	8	32	930	3	learne_d
leashed	11	32	1116	3	leashe_d
meatheads	15	4	596	3	meatheads
metalhead	15	4	321	3	metalhead
neared	7	51	1981	3	near_e_d
neatherd	12	10	719	3	neatherd
overhead	15	21	1036	3	overhead
peached	15	43	1588	3	peache_d
pearled	10	4	1155	3	pearle_d
reached	13	46	1908	3	reache_d
reared	7	59	3001	3	rear_e_d
rearmed	10	39	1282	3	rearme_d
redhead	12	5	705	3	re_dhead
reread	7	17	1543	3	re_r_ead
rethread	12	4	535	3	rethread
retread	8	4	900	3	retr_ead
saphead	13	5	777	3	_saphead
scarehead	15	4	380	3	scarehead
searched	14	20	925	3	searche_d
seared	7	52	3284	3	sear_e_d
spearheads	16	4	245	3	spearheads
stairhead	13	4	332	3	stairhead
teared	7	57	2215	3	tear_e_d
warheads	15	4	585	3	_warheads
wearied	11	29	1182	3	wearie_d
wellhead	15	4	350	3	wellhead
yearend	11	28	570	3	year_end
yearned	11	32	737	3	yearne_d

Search took 8 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.453	394461.4
2	DLD Change Limit	146162	73	6.750	21653.6
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.233	24705.0