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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

116 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
tuff	10	45	2852	(None)
buff	12	52	2985	1	buff
cuff	12	53	2799	1	cuff
duff	11	43	2664	1	duff
guff	11	46	2493	1	guff
huff	13	56	2384	1	huff
luff	10	44	2670	1	luff
muff	12	47	2385	1	muff
puff	12	55	2543	1	puff
ruff	10	51	2765	1	ruff
stuff	11	38	1705	1	stuff
teff	10	60	2376	1	teff
tiff	10	47	2771	1	tiff
toff	10	59	2990	1	toff
tufa	7	50	1661	1	tufa
tuffs	11	51	1826	1	tuffs
tuft	7	69	2951	1	tuft
turf	7	53	3405	1	turf
aff	9	55	3761	2	_aff
baff	12	46	3226	2	baff
biff	12	50	2687	2	biff
bluff	13	44	1383	2	bluff
boff	12	47	2732	2	boff
buffi	13	61	1220	2	buffi
buffo	13	51	1218	2	buffo
buffs	13	55	1951	2	buffs
buffy	16	50	1337	2	buffy
bumf	11	61	2650	2	bumf
caff	12	56	3167	2	caff
chuff	16	48	1249	2	chuff
coff	12	69	3078	2	coff
cuffs	13	50	1749	2	cuffs
cuif	9	65	2913	2	cuif
curf	9	75	3878	2	curf
daff	11	52	2968	2	daff
diff	11	62	2883	2	diff
doff	11	62	2578	2	doff
duffs	12	52	1662	2	duffs
eff	9	61	2862	2	_eff
fluff	10	39	1361	2	fluff
gaff	11	48	2815	2	gaff
gruff	12	47	1214	2	gruff
guffs	12	44	1482	2	guffs
gulf	8	49	2942	2	gulf
huffs	14	45	1474	2	huffs
huffy	17	48	1023	2	huffy
iff	9	67	3038	2	_iff
jiff	17	53	2140	2	jiff
kufi	11	9	1065	2	kufi
luffa	11	40	902	2	luffa
luffs	11	45	1628	2	luffs
miff	12	56	2504	2	miff
muffs	13	41	1421	2	muffs
naff	10	51	2893	2	naff
off	9	63	3163	2	_off
pouff	13	52	1542	2	pouff
puffs	13	41	1493	2	puffs
puffy	16	44	1075	2	puffy
quaff	20	13	1135	2	quaff
quiff	20	11	1155	2	quiff
raff	10	49	3304	2	raff
riff	10	44	3009	2	riff
ruffe	11	47	1381	2	ruffe
ruffs	11	45	1674	2	ruffs
scuff	13	39	1489	2	scuff
sluff	11	40	1681	2	sluff
snuff	11	35	1404	2	snuff
staff	11	38	1771	2	staff
stiff	11	42	1923	2	stiff
stuffs	12	38	1022	2	stuffs
stuffy	15	31	708	2	stuffy
surf	7	60	3931	2	surf
taffy	14	51	1082	2	taffy
teffs	11	51	1173	2	teffs
tiffs	11	44	1488	2	tiffs
toffs	11	60	1672	2	toffs
toffy	14	53	1028	2	toffy
toft	7	74	4165	2	toft
tofu	7	69	2133	2	tofu
tref	7	70	3099	2	tref
truffe	12	7	623	2	truffe
tub	5	56	4003	2	tu_b
tuba	6	54	2236	2	tuba
tube	6	58	2866	2	tube
tubs	6	54	3006	2	tubs
tuck	10	46	2657	2	tuck
tufas	8	53	1438	2	tufas
tuffet	12	26	1208	2	tuffet
tufts	8	57	1327	2	tufts
tufty	11	48	1041	2	tufty
tug	4	59	3740	2	tu_g
tugs	5	62	3167	2	tugs
tui	3	70	3402	2	tu_i
tuis	4	48	2964	2	tuis
tule	4	57	3587	2	tule
tump	8	59	2703	2	tump
tun	3	58	4519	2	tu_n
tuna	4	51	2784	2	tuna
tune	4	56	3586	2	tune
tung	5	53	2816	2	tung
tuns	4	51	3866	2	tuns
tup	5	60	3754	2	tu_p
tups	6	56	2876	2	tups
turd	5	60	2762	2	turd
turfs	8	46	2044	2	turfs
turfy	11	43	1540	2	turfy
turk	8	61	2586	2	turk
turn	4	63	3038	2	turn
tush	7	45	2390	2	tush
tusk	8	56	2163	2	tusk
tut	3	67	5809	2	tu_t
tuts	4	58	3845	2	tuts
tutu	4	84	2317	2	tutu
tux	10	54	2657	2	tu_x
waff	13	42	2804	2	waff
yaff	13	53	2426	2	yaff

Search took 2 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	29872	0.063	2836365.1
2	DLD Change Limit	29872	116	0.920	32469.6
3	Display Results	116	116	0.016	7250.0
	(SQL Overall)	178691	116	0.999	178869.9