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

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

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.

59 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
hallmarking	21	5	227	(None)
earmarking	17	4	358	3	ea_rmarking
hallmark	17	4	421	3	hallmark___
hallmarked	20	7	204	3	hallmark_ed
hallmarks	18	4	354	3	hallmark__s
halloaing	13	8	703	3	halloa__ing
landmarking	19	5	244	3	landmarking
alarming	11	3	858	4	_a_l_arming
allaying	12	33	930	4	_all_a_ying
alluring	9	3	907	4	_all_ur_ing
ballasting	13	4	529	4	ball_asting
bookmarking	19	5	219	4	bookmarking
bulwarking	20	4	255	4	_bulwarking
cellaring	12	3	852	4	cell_ar_ing
checkmarking	25	5	136	4	checkmarking
collaring	12	3	1054	4	coll_ar_ing
damasking	17	4	460	4	da__masking
demarking	17	3	677	4	__demarking
filmmaking	22	4	209	4	filmma_king
gallanting	12	4	534	4	gall_anting
gallerying	15	4	303	4	gall_erying
halloing	12	15	1007	4	hall___oing
hallooing	13	6	634	4	hall__ooing
hallowing	16	7	694	4	hall__owing
haltering	13	22	1200	4	ha_lter_ing
hammering	17	3	763	4	ha_mmer_ing
hangaring	14	3	803	4	ha_ngar_ing
hardworking	23	5	167	4	hardworking
harking	15	41	2094	4	h____arking
hazarding	23	4	340	4	ha__zarding
hilloaing	13	7	543	4	hilloa__ing
hollaing	12	16	709	4	holl_a__ing
hollering	13	3	774	4	holl_er_ing
holloaing	13	8	579	4	holloa__ing
homemaking	22	4	374	4	homema_king
hulloaing	13	8	452	4	hulloa__ing
larking	12	37	1825	4	___l_arking
lawmaking	19	4	394	4	la_wma_king
mapmaking	20	4	462	4	ma_pma_king
marking	14	40	2013	4	____marking
matchmarking	26	5	197	4	matchmarking
mismarking	19	5	586	4	_mismarking
pacemaking	21	4	438	4	pacema_king
palliating	13	4	788	4	pallia_ting
pillaring	12	3	764	4	pill_ar_ing
playmaking	22	4	339	4	playma_king
pockmarking	21	5	238	4	pockmarking
pollarding	14	4	423	4	poll_arding
postmarking	20	5	369	4	postmarking
rainmaking	17	4	397	4	rainma_king
remarking	16	3	889	4	__remarking
salarying	13	3	607	4	sa_l_arying
shellacking	21	5	186	4	shell_acking
skylarking	17	4	172	4	skyl_arking
tallaging	11	4	648	4	tall_a_ging
tarmacking	19	4	423	4	ta_rmacking
toolmaking	17	4	275	4	toolma_king
trademarking	20	5	202	4	trademarking
watermarking	22	5	268	4	watermarking

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	148819	0.440	406115.9
2	DLD Change Limit	148819	59	8.220	18104.5
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	8.690	20562.8