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

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

78 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
chauffers	20	25	344	(None)
chaffers	19	37	800	1	cha_ffers
chaufers	16	34	730	1	chau_fers
chauffer	19	26	379	1	chauffer_
chauffeurs	21	22	161	1	chauffeurs
chafers	15	45	1274	2	cha__fers
chaffer	18	38	947	2	cha_ffer_
chamfers	18	40	922	2	cha_mfers
chaufer	15	34	794	2	chau_fer_
chauffeur	20	22	198	2	chauffeur
chaunters	14	5	582	2	chaunters
chuffer	18	33	714	2	ch_uffer_
gauffers	15	6	383	2	_gauffers
bluffers	16	40	570	3	_bluffers
buffers	15	33	1079	3	__buffers
caulkers	14	37	565	3	c_aulkers
causers	9	40	1479	3	c_au_sers
chafer	14	47	1457	3	cha__fer_
chafes	14	50	1791	3	cha__fe_s
chaffed	19	38	770	3	cha_ffe_d
chaffered	21	15	448	3	cha_ffered
chafferer	20	13	392	3	cha_fferer
chafferers	21	15	317	3	chafferers
chaffier	19	3	547	3	chaffier_
chaffs	17	45	961	3	cha_ff__s
chambers	17	34	1062	3	cha_mbers
chamfer	17	39	986	3	cha_mfer_
chamferers	20	15	395	3	chamferers
champers	17	33	1162	3	cha_mpers
chancers	15	43	1349	3	cha_ncers
chandlers	15	38	767	3	chandlers
changers	14	43	1320	3	cha_ngers
chanters	13	40	1674	3	cha_nters
chapiters	16	3	520	3	chapiters
chapters	15	40	1213	3	cha_pters
chargers	14	40	1132	3	cha_rgers
charmers	15	42	1133	3	cha_rmers
charters	13	41	1558	3	cha_rters
chasers	12	37	1492	3	cha__sers
chatters	13	42	1395	3	cha_tters
chauffeured	23	5	88	3	chauffeured
chaunter	13	6	639	3	chaunter_
chausses	13	4	596	3	chausse_s
chawers	15	44	1205	3	cha__wers
chousers	13	46	1020	3	chou_sers
chudders	15	23	556	3	ch_udders
chuffed	19	31	664	3	ch_uffe_d
chuffest	19	4	419	3	ch_uffest
chuffier	19	3	454	3	ch_uffier_
chuffs	17	42	778	3	ch_uff__s
chuggers	15	5	486	3	ch_uggers
chukkers	16	3	348	3	ch_ukkers
chunters	13	39	1090	3	ch_unters
churners	13	31	689	3	ch_urners
coffers	15	41	1269	3	c__offers
crafters	13	41	995	3	cra_fters
duffers	14	34	1009	3	__duffers
fluffers	13	33	529	3	_fluffers
gaffers	14	42	871	3	_ga_ffers
gauffer	14	7	442	3	_gauffer_
haffets	16	3	605	3	_ha_ffets
hafters	13	46	1433	3	_ha_fters
haulers	10	40	1244	3	_hau_lers
hauliers	11	7	671	3	_hauliers
haunters	11	32	954	3	_haunters
piaffers	16	11	420	3	pia_ffers
puffers	15	34	920	3	__puffers
quaffers	23	3	396	3	qua_ffers
rechauffes	21	5	146	3	rechauffe_s
sclaffers	17	12	252	3	scla_ffers
scuffers	16	30	749	3	_scuffers
shufflers	18	26	515	3	sh_ufflers
snuffers	14	32	692	3	_snuffers
staffers	14	24	708	3	sta_ffers
stuffers	14	27	738	3	_stuffers
suffers	13	31	1354	3	__suffers
whiffers	20	6	449	3	wh_iffers
zaffers	22	38	677	3	_za_ffers

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	78	7.160	20759.9
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.626	23431.8