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

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

67 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
hatmaker	17	8	535	(None)
hatmakers	18	10	517	1	hatmakers
haymaker	20	10	477	1	haymaker
capmaker	18	5	520	2	capmaker
carmaker	16	3	730	2	carmaker
haymakers	21	10	455	2	haymakers
lawmaker	17	4	392	2	lawmaker
mapmaker	18	6	437	2	mapmaker
warmaker	17	3	597	2	warmaker
attacker	14	14	498	3	_attacker
automaker	15	4	466	3	automaker
bedmaker	17	4	493	3	bedmaker
capmakers	19	4	472	3	capmakers
carmakers	17	3	691	3	carmakers
catnaper	12	9	493	3	catnaper
comaker	15	34	1060	3	_comaker
damager	11	5	797	3	da_mager
diemaker	15	4	559	3	diemaker
hacker	15	48	2269	3	ha__cker
hamate	11	33	1983	3	ha_mate_
hamates	12	29	1768	3	ha_mates
hammer	13	81	2003	3	ha_m_mer
hammerer	15	27	814	3	hammerer
hammier	14	35	1065	3	ha_mmier
hamper	13	45	1865	3	ha_m_per
hamster	12	8	1042	3	ha_mster
hanaper	12	3	713	3	ha_naper
hanker	13	46	2209	3	ha__nker
harmer	11	47	1955	3	harm__er
hatcher	15	33	1472	3	hat_cher
hater	8	50	3475	3	hat___er
hatlike	14	33	1171	3	hatlike_
hatter	9	47	2487	3	hat__ter
havocker	20	4	239	3	havocker
hawker	16	48	1266	3	ha__wker
homager	13	10	785	3	h_omager
homemaker	20	4	496	3	homemaker
hotcake	16	4	454	3	hotcake_
hotcakes	17	4	470	3	hotcakes
humaner	12	25	766	3	h_umaner
icemaker	16	4	444	3	icemaker
kayaker	13	5	450	3	ka_yaker
lawmakers	18	4	389	3	lawmakers
maker	11	41	2781	3	___maker
mapmakers	19	4	404	3	mapmakers
matchmaker	23	5	271	3	matchmaker
mythmaker	23	5	232	3	mythmaker
oatcake	13	4	536	3	oatcake_
oatcakes	14	4	554	3	oatcakes
pacemaker	19	10	476	3	pacemaker
partaker	14	3	687	3	partaker
platemaker	18	5	290	3	platemaker
playmaker	20	4	362	3	playmaker
rainmaker	15	4	439	3	rainmaker
remaker	13	38	1317	3	_remaker
retaker	11	37	1431	3	ret_aker
sailmaker	15	4	397	3	sailmaker
shirtmaker	19	5	233	3	shirtmaker
shoemaker	18	4	384	3	shoemaker
taker	9	52	2900	3	__t_aker
tastemaker	16	5	274	3	tastemaker
teamaker	14	4	511	3	teamaker
tentmaker	15	4	311	3	tentmaker
unmaker	13	27	951	3	_unmaker
warmakers	18	4	563	3	warmakers
watchmaker	24	6	261	3	watchmaker
wigmaker	18	4	380	3	wigmaker

Search took 7 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	67	6.283	23263.1
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	6.733	26539.6