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

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

86 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
tufter	9	31	993	(None)
tufted	10	35	928	1	tufted
tufters	10	29	835	1	tufters
tuftier	10	9	660	1	tuftier
after	8	57	1979	2	_after
buffer	14	45	1268	2	buffer
bunter	8	50	2038	2	bunter
buster	8	47	2649	2	buster
butter	8	47	2423	2	butter
curter	8	53	2008	2	curter
cuter	7	47	2823	2	cu_ter
cutter	8	45	2100	2	cutter
dafter	10	48	1334	2	dafter
defter	10	42	1592	2	defter
duffer	13	47	1166	2	duffer
duster	7	49	1972	2	duster
gutter	7	38	1771	2	gutter
hafter	12	48	1588	2	hafter
hefter	12	43	1392	2	hefter
hunter	9	48	1777	2	hunter
hurter	9	39	1585	2	hurter
juster	13	46	1701	2	juster
lefter	9	36	1343	2	lefter
lifter	9	38	1481	2	lifter
lofter	9	46	1472	2	lofter
luster	6	40	2367	2	luster
muster	8	47	2452	2	muster
muter	7	45	2554	2	mu_ter
mutter	8	44	1888	2	mutter
nutter	6	39	1805	2	nutter
ofter	8	41	1687	2	_ofter
ouster	6	42	2373	2	ouster
outer	5	56	3330	2	ou_ter
puffer	14	46	1073	2	puffer
punter	8	43	2003	2	punter
putter	8	39	2144	2	putter
quoter	15	35	1009	2	quoter
rafter	9	45	1758	2	rafter
sifter	9	45	1623	2	sifter
softer	9	40	1531	2	softer
stuffer	13	34	979	2	stuffer
stutter	7	29	1146	2	stutter
suffer	12	43	1451	2	suffer
suiter	6	41	2181	2	suiter
tarter	6	40	2356	2	tarter
taster	6	49	3057	2	taster
tater	5	41	3861	2	t_ater
tatter	6	40	2457	2	tatter
taunter	7	31	1145	2	taunter
tauter	6	43	1802	2	tauter
teeter	6	54	2031	2	teeter
tenter	6	46	2393	2	tenter
tester	6	42	2715	2	tester
tetter	6	43	2245	2	tetter
tilter	6	34	1769	2	tilter
tinter	6	39	2364	2	tinter
titer	5	54	3061	2	t_iter
titfer	9	40	952	2	titfer
titter	6	34	2116	2	titter
tooter	6	44	2080	2	tooter
toter	5	59	3213	2	t_oter
totter	6	50	2146	2	totter
touter	6	38	2103	2	touter
triter	6	51	2059	2	triter
truster	7	31	1431	2	truster
tuatera	7	5	638	2	tuatera
tubber	10	43	1320	2	tubber
tuber	7	54	2068	2	tu_ber
tucker	12	43	1695	2	tucker
tuffet	12	26	1208	2	tuffet
tuft	7	69	2951	2	tuft__
tufts	8	57	1327	2	tuft_s
tufty	11	48	1041	2	tuft_y
tugger	8	40	1310	2	tugger
tuner	5	60	2268	2	tu_ner
turfier	10	24	979	2	turfier
turner	6	39	1461	2	turner
turtler	7	26	1032	2	turtler
tusker	10	42	1219	2	tusker
tusser	6	46	1583	2	tusser
tutee	5	4	2352	2	tu_tee
tutor	5	7	1249	2	tu_tor
tutted	7	51	1744	2	tutted
tuyer	8	54	1429	2	tu_yer
utter	5	42	1876	2	_utter
wafter	12	41	1461	2	wafter

Search took 5 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	82551	0.716	249568.4
2	DLD Change Limit	82551	86	3.626	22766.4
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	4.372	40871.7