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

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

77 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
sclaffers	17	12	252	(None)
sclaffer	16	11	265	1	sclaffer_
chaffers	19	37	800	2	_chaffers
scarfers	13	40	846	2	sc_arfers
sclaffed	17	10	267	2	sclaffe_d
sclaffs	15	4	357	2	sclaff__s
scoffers	16	28	613	2	sc_offers
scuffers	16	30	749	2	sc_uffers
staffers	14	24	708	2	s_taffers
bluffers	16	40	570	3	_bluffers
chafers	15	45	1274	3	_cha_fers
chaffer	18	38	947	3	_chaffer_
chamfers	18	40	922	3	_chamfers
chaufers	16	34	730	3	_chaufers
chauffers	20	25	344	3	_chauffers
clabbers	14	35	990	3	_clabbers
clackers	16	39	1170	3	_clackers
claimers	12	29	874	3	_claimers
clambers	14	42	1129	3	_clambers
clammers	14	35	1069	3	_clammers
clampers	14	32	1189	3	_clampers
clangers	11	43	1234	3	_clangers
clappers	14	33	1083	3	_clappers
claquers	19	22	620	3	_claquers
clashers	13	42	1399	3	_clashers
claspers	12	44	1091	3	_claspers
classers	10	41	1183	3	_classers
clatters	10	33	1391	3	_clatters
clavers	12	43	1490	3	_cla_vers
claviers	13	6	710	3	_claviers
clawers	12	39	1097	3	_cla_wers
coffers	15	41	1269	3	_c_offers
crafters	13	41	995	3	_crafters
fluffers	13	33	529	3	_fluffers
gaffers	14	42	871	3	__gaffers
piaffers	16	11	420	3	_piaffers
quaffers	23	3	396	3	_quaffers
scalers	9	38	1726	3	sc_a_lers
scalpers	12	37	1086	3	sc_alpers
scammers	14	33	977	3	sc_ammers
scampers	14	36	1103	3	sc_ampers
scanners	10	37	970	3	sc_anners
scarers	9	46	1851	3	sc_a_rers
scarfer	12	45	1108	3	sc_arfer_
scarpers	12	47	1251	3	sc_arpers
scatters	10	36	1275	3	sc_atters
scaupers	12	37	817	3	sc_aupers
sclaff	14	3	831	3	sclaff___
sclaffing	18	4	336	3	sclaffing
scoffer	15	31	702	3	sc_offer_
scrapers	12	55	1053	3	scra_pers
scrappers	15	4	586	3	scrappers
scrawlers	14	3	475	3	scrawlers
scuffer	15	32	888	3	sc_uffer_
scufflers	17	28	503	3	scufflers
slabbers	12	36	1012	3	s_labbers
slackers	14	38	1274	3	s_lackers
slakers	11	41	1575	3	s_la_kers
slammers	12	35	1122	3	s_lammers
slanders	9	40	1401	3	s_landers
slappers	12	37	1094	3	s_lappers
slashers	11	33	1361	3	s_lashers
slaters	7	31	2373	3	s_la_ters
slathers	11	39	1478	3	s_lathers
slavers	10	37	1650	3	s_la_vers
slayers	10	45	1332	3	s_la_yers
sniffers	14	25	712	3	s_niffers
snuffers	14	32	692	3	s_nuffers
solacers	10	26	889	3	sola_cers
solanders	10	3	696	3	solanders
splashers	14	4	528	3	splashers
splatters	11	32	754	3	splatters
staffer	13	29	909	3	s_taffer_
strafers	11	37	991	3	stra_fers
stuffers	14	27	738	3	s_tuffers
suffers	13	31	1354	3	s__uffers
zaffers	22	38	677	3	__zaffers

Search took 8 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.436	409841.7
2	DLD Change Limit	148641	77	7.440	19978.6
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.906	22601.9