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

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

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
lobstering	13	4	511	(None)
lobsterings	14	4	288	1	lobsterings
bolstering	13	4	687	2	bolstering
cloistering	14	4	482	2	cloistering
fostering	13	24	1125	2	fo_stering
holstering	14	4	707	2	holstering
leistering	11	4	798	2	leistering
loitering	10	3	968	2	lo_itering
lustering	10	27	1120	2	l_ustering
oystering	13	3	755	2	_oystering
roistering	11	4	856	2	roistering
roystering	14	4	540	2	roystering
absterging	14	5	335	3	_absterging
blistering	13	10	706	3	blistering
blustering	13	10	618	3	blustering
bowstring	15	16	512	3	bowst_ring
clobbering	17	10	393	3	clob_bering
clustering	13	11	681	3	clustering
coshering	15	5	1002	3	co_shering
countering	13	3	1447	3	countering
festering	13	24	1317	3	_festering
flustering	14	10	593	3	flustering
fosterling	14	4	516	3	fo_sterling
glistering	12	10	642	3	glistering
hosteling	13	3	789	3	ho_steling
koshering	17	3	536	3	ko_shering
lettering	10	21	1207	3	l_ettering
lightering	15	24	611	3	lightering
listening	10	12	895	3	l_istening
littering	10	24	1197	3	l_ittering
lobster	9	28	885	3	lobster___
lobstered	12	4	463	3	lobster_ed
lobsterer	11	4	403	3	lobster_er
lobsterers	12	4	348	3	lobsterers
lobsterlike	17	5	124	3	lobsterlike
lobsterman	14	5	231	3	lobsterman
lobstermen	14	5	252	3	lobstermen
lobsters	10	26	873	3	lobster__s
loosening	10	4	493	3	loos_ening
loppering	14	23	728	3	lo_ppering
lowering	12	22	1091	3	lo__wering
lustring	9	26	972	3	l_ust_ring
mastering	12	23	1530	3	_mastering
moistening	13	4	623	3	moistening
mustering	12	22	1233	3	_mustering
obscuring	14	4	402	3	_obscuring
observing	15	4	438	3	_obs_erving
oysterings	14	4	388	3	_oysterings
pestering	12	23	1566	3	_pestering
plaistering	14	4	459	3	plaistering
plastering	13	3	924	3	plastering
portering	12	20	1230	3	po_rtering
posturing	12	3	899	3	po_sturing
pottering	12	26	1200	3	po_ttering
sistering	10	12	1373	3	_sistering
slobbering	15	10	388	3	slob_bering
sobering	11	19	1278	3	sob__ering
tottering	10	22	961	3	to_ttering
westering	13	21	1264	3	_westering

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	140603	0.233	766914.2
2	DLD Change Limit	140603	59	7.986	17606.2
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	8.252	21654.3