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

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

88 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
shellacking	21	5	186	(None)
shellackings	22	5	107	1	shellackings
shacking	18	40	1408	3	sh___acking
shellack	17	4	508	3	shellack___
shellacked	20	4	200	3	shellack_ed
shellacks	18	4	455	3	shellack__s
shelling	12	35	1521	3	shell___ing
shylocking	23	4	251	3	sh_ylocking
slacking	15	39	1413	3	s___lacking
beflecking	22	4	303	4	_beflecking
bellyaching	22	5	208	4	_bellyaching
blacking	17	42	1360	4	___blacking
cellaring	12	3	852	4	_cella_ring
checking	20	37	920	4	che___cking
chelating	15	4	935	4	che_la_ting
clacking	17	33	1349	4	___clacking
enlacing	11	4	877	4	__enlac_ing
fellating	13	3	924	4	_fella_ting
flacking	18	43	1179	4	___flacking
hacking	17	37	2061	4	_h___acking
hallmarking	21	5	227	4	_hallmarking
helling	11	46	2322	4	_hell___ing
helloing	12	15	912	4	_hell__oing
henpecking	22	4	230	4	_henpecking
hijacking	26	4	276	4	_h_ijacking
hollaing	12	16	709	4	_holla__ing
hopsacking	22	4	253	4	_hopsacking
lacking	14	38	2154	4	____lacking
overpacking	23	4	653	4	overpacking
prepacking	21	4	577	4	pre_packing
preplacing	17	4	600	4	preplac_ing
relacing	11	25	1604	4	_re_lac_ing
relocking	16	13	768	4	_re_locking
repacking	18	3	828	4	_re_packing
replacing	14	22	1016	4	_replac_ing
reracking	16	3	931	4	_re_racking
restacking	17	3	718	4	_restacking
retacking	16	5	897	4	_re_tacking
retracking	17	3	816	4	_retracking
rollicking	17	4	293	4	_rollicking
sacking	14	41	2270	4	s____acking
safecracking	24	5	130	4	safecracking
selecting	12	3	1053	4	s_e_lecting
selling	8	32	2583	4	s_ell___ing
shackling	19	28	617	4	sh___ackling
shaking	15	33	1725	4	sh___a_king
shallowing	17	4	411	4	shall_owing
shanking	16	36	1228	4	sh___anking
sharking	16	39	1297	4	sh___arking
sheafing	15	32	948	4	she__a_fing
shealing	12	34	1546	4	she__a_ling
shearing	12	39	1590	4	she__a_ring
shearling	13	3	692	4	she__arling
sheathing	16	3	687	4	she__athing
sheaving	15	41	1025	4	she__a_ving
sheetrocking	22	10	169	4	sheetrocking
shellac	12	3	669	4	shellac____
shellacs	13	4	557	4	shellac___s
shellback	20	4	360	4	shellback___
shellbacks	21	5	341	4	shellback__s
sheltering	14	4	649	4	she_ltering
shelving	15	27	817	4	she_l__ving
shilling	12	33	1538	4	shill___ing
shocking	18	43	1154	4	sh___ocking
shucking	18	33	943	4	sh___ucking
sidetracking	20	5	212	4	sidetracking
skyjacking	26	4	160	4	s_kyjacking
skylarking	17	4	172	4	s_kylarking
slaking	12	37	1747	4	s___la_king
slicking	15	37	1259	4	s___licking
smacking	17	35	1076	4	s___macking
smelling	11	37	1272	4	smell___ing
snacking	15	34	1170	4	s___nacking
sneaking	13	32	1109	4	sne__a_king
snelling	9	39	1356	4	snell___ing
solacing	11	3	1013	4	s__olac_ing
speaking	15	32	1249	4	spe__a_king
specking	17	35	973	4	spe___cking
spelling	11	33	1523	4	spell___ing
spelunking	17	11	200	4	spe_lunking
stacking	15	42	1508	4	s___tacking
steelmaking	18	14	249	4	steelmaking
stellifying	18	4	270	4	stellifying
swelling	12	32	1275	4	swell___ing
syllabling	16	5	249	4	s_yllabling
thacking	18	31	1004	4	th___acking
thwacking	22	5	319	4	th__wacking
whacking	21	37	748	4	wh___acking

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.423	422437.4
2	DLD Change Limit	148819	88	8.483	17543.2
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	8.936	19996.8