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

Here are the results of your fuzzy-string dictionary search for “tufters” with Change Limit: [1] [2] [3]

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.

72 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
tufters	10	29	835	(None)
tufter	9	31	993	1	tufter_
afters	9	47	1707	2	_afters
buffers	15	33	1079	2	buffers
bunters	9	47	1712	2	bunters
busters	9	47	2413	2	busters
butters	9	45	2172	2	butters
cutters	9	42	1896	2	cutters
duffers	14	34	1009	2	duffers
dusters	8	49	1836	2	dusters
gutters	8	37	1551	2	gutters
hafters	13	46	1433	2	hafters
hefters	13	43	1200	2	hefters
hunters	10	39	1573	2	hunters
hurters	10	34	1364	2	hurters
justers	14	38	1573	2	justers
lifters	10	43	1378	2	lifters
lofters	10	39	1290	2	lofters
lusters	7	39	2144	2	lusters
musters	9	45	2251	2	musters
mutters	9	41	1714	2	mutters
nutters	7	42	1543	2	nutters
ousters	7	41	2279	2	ousters
outers	6	42	3017	2	ou_ters
puffers	15	34	920	2	puffers
punters	9	36	1704	2	punters
putters	9	42	1919	2	putters
quoters	16	36	926	2	quoters
rafters	10	37	1563	2	rafters
sifters	10	37	1479	2	sifters
stuffers	14	27	738	2	stuffers
stutters	8	32	1047	2	stutters
suffers	13	31	1354	2	suffers
suiters	7	36	1888	2	suiters
tasters	7	42	2564	2	tasters
taters	6	49	3220	2	t_aters
tatters	7	45	2048	2	tatters
taunters	8	25	927	2	taunters
teeters	7	40	1830	2	teeters
tenters	7	39	2110	2	tenters
testers	7	41	2454	2	testers
tetters	7	43	2047	2	tetters
tilters	7	33	1595	2	tilters
tinters	7	42	2111	2	tinters
titers	6	45	2641	2	t_iters
titfers	10	31	893	2	titfers
titters	7	42	1962	2	titters
tooters	7	38	1877	2	tooters
toters	6	50	2636	2	t_oters
totters	7	46	1873	2	totters
touters	7	40	1835	2	touters
trusters	8	31	1226	2	trusters
tuatera	7	5	637	2	tuatera
tuateras	8	3	619	2	tuateras
tubbers	11	34	1125	2	tubbers
tubers	8	50	1703	2	tu_bers
tuckers	13	40	1435	2	tuckers
tuffets	13	26	652	2	tuffets
tufted	10	35	928	2	tufte_d
tuftier	10	9	660	2	tuftier_
tufts	8	57	1327	2	tuft__s
tuggers	9	37	1144	2	tuggers
tuners	6	44	1734	2	tu_ners
turners	7	39	1289	2	turners
turtlers	8	25	820	2	turtlers
tuskers	11	37	1004	2	tuskers
tussers	7	43	1356	2	tussers
tutees	6	5	1455	2	tu_tees
tutors	6	9	1233	2	tu_tors
tuyers	9	46	1256	2	tu_yers
utters	6	38	1712	2	_utters
wafters	13	41	1281	2	wafters

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	72	3.046	35348.3
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.452	51764.5