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

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

81 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
titfer	9	40	952	(None)
titer	5	54	3061	1	tit_er
titfers	10	31	893	1	titfers
tither	9	49	2028	1	tither
titter	6	34	2116	1	titter
biter	7	50	3003	2	bit_er
bitter	8	46	2267	2	bitter
citer	7	48	2733	2	cit_er
cither	11	46	1668	2	cither
differ	13	39	1084	2	differ
dither	10	44	1768	2	dither
either	9	45	1742	2	either
fifer	11	55	1997	2	fi_fer
fitter	9	41	2003	2	fitter
hither	12	44	1725	2	hither
hitter	9	44	1986	2	hitter
infer	8	42	1503	2	_infer
ither	8	46	1760	2	_ither
jitter	13	33	1499	2	jitter
kiter	9	55	2321	2	kit_er
liefer	9	52	957	2	liefer
lifer	8	58	2215	2	li_fer
lifter	9	38	1481	2	lifter
liter	5	47	3634	2	lit_er
lither	9	45	2095	2	lither
litter	6	43	2485	2	litter
miter	7	57	3479	2	mit_er
mither	11	42	1856	2	mither
mitier	8	36	2067	2	mitier
niffer	12	37	844	2	niffer
niter	5	50	2897	2	nit_er
pilfer	11	3	916	2	pilfer
pitier	8	40	1982	2	pitier
rifer	8	47	2198	2	ri_fer
ritter	6	38	2242	2	ritter
sifter	9	45	1623	2	sifter
sitter	6	33	2338	2	sitter
stiffer	13	31	939	2	stiffer
tater	5	41	3861	2	tat_er
tatter	6	40	2457	2	tatter
telfer	9	37	989	2	telfer
tether	9	37	1610	2	tether
tetter	6	43	2245	2	tetter
thither	13	32	810	2	thither
ticker	12	43	2150	2	ticker
tidier	7	35	1511	2	tidier
tier	4	49	3614	2	ti__er
tiffed	13	36	839	2	tiffed
tiger	6	57	1863	2	ti_ger
tiler	5	61	3102	2	ti_ler
tiller	6	42	2254	2	tiller
tilter	6	34	1769	2	tilter
timber	10	40	1268	2	timber
timer	7	56	2604	2	ti_mer
tinder	7	38	2180	2	tinder
tinier	6	36	2223	2	tinier
tinker	10	36	1992	2	tinker
tinner	6	41	1996	2	tinner
tinter	6	39	2364	2	tinter
tipper	10	39	1841	2	tipper
titers	6	45	2641	2	tit_ers
tithe	8	53	1970	2	tithe_
tithed	10	41	1559	2	tithed
tithers	10	42	1673	2	tithers
tithes	9	47	2021	2	tithes
title	5	47	2107	2	title_
titled	7	38	1500	2	titled
titles	6	37	1992	2	titles
titmen	8	23	988	2	titmen
titre	5	46	1939	2	titre_
titres	6	47	1893	2	titres
titters	7	42	1962	2	titters
toter	5	59	3213	2	tot_er
tother	9	41	1714	2	tother
totter	6	50	2146	2	totter
triter	6	51	2059	2	trit_er
tufter	9	31	993	2	tufter
twitter	10	27	809	2	twitter
twofer	12	3	435	2	twofer
wither	12	43	2135	2	wither
zither	18	38	1308	2	zither

Search took 3 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.346	516448.0
2	DLD Change Limit	82551	81	2.576	32046.2
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	2.955	60470.7