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

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

63 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
bricklaying	23	5	183	(None)
bricklayings	24	5	86	1	bricklayings
tracklaying	21	5	239	2	tracklaying
bricking	17	39	1140	3	brick___ing
bricklayer	21	5	172	3	bricklay_er
bricklayers	22	5	164	3	bricklayers
prickling	18	3	653	3	prickl__ing
sicklying	19	4	388	3	_sickl_ying
tracklayings	22	5	113	3	tracklayings
trickling	16	4	772	3	trickl__ing
articulating	15	5	676	4	articulating
backdating	20	4	572	4	b_ackdating
backlashing	23	5	343	4	b_acklashing
backloading	21	5	382	4	b_ackloading
belaying	14	31	1060	4	b___elaying
bickering	18	3	766	4	b_ick_ering
blockading	20	8	283	4	block_ading
brachiating	19	4	443	4	brachiating
bracketing	19	4	523	4	brack_eting
braying	13	44	1631	4	br____aying
brecciating	18	4	422	4	brecciating
bricklike	16	4	311	4	brickl__ike
bridling	12	26	1058	4	bri_dl__ing
brigading	14	4	514	4	bri__gading
brisking	15	32	947	4	brisk___ing
brisling	11	24	1084	4	bri_sl__ing
bristling	12	4	666	4	bristl__ing
brittling	12	3	554	4	brittl__ing
brocading	15	5	625	4	broc__ading
bucklering	19	4	404	4	b_ucklering
buckling	17	25	911	4	b_uckl__ing
buckraming	21	4	311	4	b_uckraming
circulating	16	4	773	4	circulating
claying	13	36	1430	4	___c_laying
crackling	18	15	700	4	crackl__ing
cricketing	19	4	403	4	crick_eting
cricking	17	34	1265	4	crick___ing
crinkling	16	14	586	4	crinkl__ing
displaying	17	4	631	4	_displaying
freckling	19	3	470	4	freckl__ing
inlaying	12	4	789	4	__i_nlaying
mislaying	15	5	791	4	_mi_slaying
misplaying	18	4	555	4	_misplaying
necklacing	19	4	281	4	_necklacing
nickling	15	27	870	4	_nickl__ing
nicknaming	19	5	211	4	_nicknaming
pickaxing	25	4	310	4	_pick_axing
pickling	17	23	920	4	_pickl__ing
pricking	17	32	1260	4	prick___ing
relaying	12	25	1515	4	_r__elaying
replaying	15	25	960	4	_r_eplaying
ricking	14	39	2023	4	_rick___ing
rockling	15	25	938	4	_rockl__ing
ruckling	15	25	857	4	_ruckl__ing
sickling	15	29	1033	4	_sickl__ing
stickling	16	4	700	4	stickl__ing
strickling	17	4	495	4	strickl__ing
tickling	15	30	943	4	_tickl__ing
tribulating	14	4	535	4	tribulating
tricking	15	27	1451	4	trick___ing
truckling	16	4	507	4	truckl__ing
wricking	18	34	949	4	wrick___ing
wrinkling	17	14	495	4	wrinkl__ing

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	148819	0.423	422437.4
2	DLD Change Limit	148819	63	8.560	17385.4
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	9.016	19819.3