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

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

105 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
tiffs	11	44	1488	(None)
biffs	13	48	1441	1	biffs
diffs	12	63	1548	1	diffs
jiffs	18	57	1031	1	jiffs
miffs	13	45	1288	1	miffs
riffs	11	51	1461	1	riffs
stiffs	12	38	996	1	stiffs
teffs	11	51	1173	1	teffs
tiff	10	47	2772	1	tiff_
toffs	11	60	1672	1	toffs
tuffs	11	51	1826	1	tuffs
baffs	13	47	1805	2	baffs
biff	12	50	2689	2	biff_
biffy	16	47	1113	2	biffy
boffs	13	49	1550	2	boffs
buffs	13	55	1951	2	buffs
caffs	13	54	1737	2	caffs
cliffs	14	47	759	2	cliffs
coffs	13	49	1630	2	coffs
cuffs	13	50	1749	2	cuffs
daffs	12	51	1642	2	daffs
diff	11	62	2884	2	diff_
difs	8	60	2732	2	di_fs
doffs	12	56	1433	2	doffs
duffs	12	52	1662	2	duffs
effs	10	51	1403	2	_effs
fiefs	11	62	1370	2	fiefs
fifes	11	48	2239	2	fifes
gaffs	12	49	1465	2	gaffs
gifts	9	62	1496	2	gifts
gliffs	13	43	632	2	gliffs
griffs	13	39	899	2	griffs
guffs	12	44	1482	2	guffs
huffs	14	45	1474	2	huffs
iff	9	67	3039	2	_iff_
iffy	13	53	1228	2	_iffy
ifs	6	71	2424	2	_i_fs
jiff	17	53	2141	2	jiff_
jiffy	21	45	831	2	jiffy
kiefs	12	61	1220	2	kiefs
kifs	11	60	2351	2	ki_fs
lifts	8	57	1906	2	lifts
luffs	11	45	1628	2	luffs
miff	12	56	2506	2	miff_
miffy	16	39	1020	2	miffy
muffs	13	41	1421	2	muffs
naffs	11	62	1396	2	naffs
offs	10	71	1701	2	_offs
puffs	13	41	1493	2	puffs
quiffs	21	13	543	2	quiffs
raffs	11	50	1752	2	raffs
riff	10	44	3010	2	riff_
rifs	7	49	2900	2	ri_fs
rifts	8	57	1864	2	rifts
ruffs	11	45	1674	2	ruffs
sifts	8	49	1892	2	sifts
skiffs	16	32	701	2	skiffs
sniffs	12	37	884	2	sniffs
spiffs	14	32	847	2	spiffs
staffs	12	34	975	2	staffs
stiff	11	42	1924	2	stiff_
stuffs	12	38	1022	2	stuffs
taffy	14	51	1082	2	taffy
tariffs	13	3	459	2	tariffs
teff	10	60	2376	2	teff_
ticks	11	58	2329	2	ticks
tics	6	57	2963	2	ti_cs
tides	6	48	3015	2	tides
tiers	5	55	2652	2	tiers
ties	4	52	4831	2	ti_es
tiffed	13	36	839	2	tiffed
tiffin	12	32	793	2	tiffin
tiffins	13	32	798	2	tiffins
tikes	9	56	2890	2	tikes
tikis	9	56	1597	2	tikis
tiles	5	55	4210	2	tiles
tills	5	46	3171	2	tills
tils	4	57	3961	2	ti_ls
tilts	5	53	2561	2	tilts
times	7	56	3082	2	times
tines	5	48	4842	2	tines
tings	6	53	2920	2	tings
tins	4	52	5130	2	ti_ns
tints	5	60	3092	2	tints
tipis	7	60	1992	2	tipis
tipoffs	15	4	303	2	tipoffs
tips	6	64	3676	2	ti_ps
tires	5	54	3749	2	tires
tirls	5	45	1980	2	tirls
tiros	5	45	2489	2	tiros
tis	3	70	5664	2	ti__s
titis	5	60	2381	2	titis
tits	4	61	4504	2	ti_ts
toff	10	59	2990	2	toff_
toffy	14	53	1028	2	toffy
tofts	8	49	1924	2	tofts
tofus	8	64	1542	2	tofus
tufas	8	53	1438	2	tufas
tuff	10	45	2852	2	tuff_
tufts	8	57	1327	2	tufts
turfs	8	46	2044	2	turfs
waffs	14	63	1547	2	waffs
whiffs	18	3	508	2	whiffs
wifes	11	45	2256	2	wifes
yaffs	14	53	1112	2	yaffs

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	53800	0.313	570897.8
2	DLD Change Limit	53800	105	1.533	35094.6
3	Display Results	105	105	0.030	3500.0
	(SQL Overall)	178691	105	1.876	95251.1