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

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

83 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
slubbings	14	21	338	(None)
slubbing	13	24	803	1	slubbing_
subbings	13	23	848	1	s_ubbings
blebbings	13	24	278	2	blebbings
blubbing	12	25	701	2	blubbing_
clubbing	15	26	651	2	clubbing_
drubbings	15	26	288	2	drubbings
dubbings	14	24	547	2	_dubbings
flubbing	16	27	588	2	flubbing_
plumbings	16	21	336	2	plumbings
rubbings	13	30	633	2	_rubbings
slabbing	13	28	778	2	slabbing_
snubbing	13	23	667	2	snubbing_
stubbing	13	23	745	2	stubbing_
subbing	12	39	1558	2	s_ubbing_
subrings	11	22	988	2	s_ubrings
blabbing	12	26	672	3	blabbing_
blebbing	12	26	567	3	blebbing_
blobbing	12	24	692	3	blobbing_
blueings	11	30	551	3	blu_eings
bluings	10	32	796	3	blu__ings
blurbing	13	32	650	3	blurbing_
clubbiness	16	4	299	3	clubbiness
cribbings	16	27	317	3	cribbings
curbings	13	40	731	3	_curbings
drubbing	14	28	605	3	drubbing_
dubbing	13	33	1121	3	_dubbing_
dubbins	12	35	880	3	_dubbin_s
flutings	12	35	737	3	flu_tings
fubbing	15	40	957	3	_fubbing_
grubbing	14	29	540	3	grubbing_
lobbing	12	31	1091	3	_lobbing_
lubing	9	41	1404	3	_lu_bing_
lutings	8	33	1105	3	_lu_tings
nubbins	11	26	802	3	_nubbin_s
plumbing	15	28	643	3	plumbing_
ribbings	13	27	592	3	_ribbings
rubbing	12	34	1227	3	_rubbing_
sabbing	12	33	1474	3	s_abbing_
scabbing	15	27	719	3	scabbing_
scrubbing	16	3	393	3	scrubbing_
scubaing	13	3	573	3	scubaing_
shuckings	19	27	385	3	shuckings
siblings	11	10	812	3	s_iblings
slammings	14	23	412	3	slammings
slashings	13	31	620	3	slashings
slatings	9	40	1172	3	sl_atings
slattings	10	34	607	3	slattings
sleddings	12	26	378	3	sleddings
sleepings	12	33	588	3	sleepings
slings	7	46	1801	3	sl___ings
slubbering	15	12	492	3	slubbering_
slubbers	12	34	994	3	slubb_ers
sludging	11	26	836	3	sludging_
sluffing	15	24	730	3	sluffing_
slugging	11	33	942	3	slugging_
sluicing	11	3	706	3	sluicing_
sluing	7	43	1588	3	slu__ing_
slumming	13	27	838	3	slumming_
slumping	13	35	997	3	slumping_
slurping	11	27	812	3	slurping_
slurring	9	28	883	3	slurring_
slushing	12	29	964	3	slushing_
snibbing	13	29	589	3	snibbing_
snubbiness	14	4	346	3	snubbiness
sobbing	12	76	1288	3	s_obbing_
soundings	11	26	615	3	soundings
southings	13	24	623	3	southings
squibbing	23	4	275	3	squibbing_
stabbing	13	23	876	3	stabbing_
stablings	12	25	610	3	stablings
stobbing	13	22	724	3	stobbing_
studdings	12	4	293	3	studdings
stuffings	16	23	349	3	stuffings
sublines	10	3	1578	3	s_ublines
subring	10	41	1626	3	s_ubring_
suitings	9	28	895	3	s_uitings
surfings	12	26	807	3	s_urfings
swabbing	16	24	645	3	swabbing_
swobbing	16	23	517	3	swobbing_
tubbing	12	35	1009	3	_tubbing_
tubings	10	33	648	3	_tu_bings
webbings	16	3	324	3	_webbings

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	148641	0.420	425454.8
2	DLD Change Limit	148641	83	6.423	23142.0
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	6.873	25999.0