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

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

80 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
teemer	8	55	1574	(None)
seemer	8	44	1804	1	seemer
teemed	9	51	1487	1	teemed
teemers	9	50	1290	1	teemers
teener	6	47	1750	1	teener
teeter	6	54	2031	1	teeter
termer	8	57	1725	1	termer
beeper	10	37	1409	2	beeper
beezer	17	40	1052	2	beezer
deemed	10	47	1306	2	deemed
deeper	9	36	1350	2	deeper
emeer	7	48	1536	2	_emeer
emmer	9	43	1446	2	_emmer
feeder	10	35	1384	2	feeder
feeler	9	32	1517	2	feeler
geezer	16	27	801	2	geezer
heeder	10	42	1604	2	heeder
heeler	9	39	1732	2	heeler
hemmer	13	41	1264	2	hemmer
jeerer	13	38	993	2	jeerer
keener	10	40	1284	2	keener
keeper	12	38	1192	2	keeper
meeker	12	35	998	2	meeker
meeter	8	36	1650	2	meeter
needer	7	36	1495	2	needer
peeler	8	35	1738	2	peeler
peeper	10	36	1480	2	peeper
reamer	8	43	2521	2	reamer
reefer	9	33	1436	2	reefer
reeker	10	37	1559	2	reeker
reeler	6	38	2257	2	reeler
seamer	8	42	2361	2	seamer
seeder	7	43	2077	2	seeder
seeker	10	36	1536	2	seeker
seemed	9	51	1761	2	seemed
seemers	9	38	1433	2	seemers
steamer	9	33	1309	2	steamer
steeper	9	38	1277	2	steeper
steerer	7	31	1363	2	steerer
stemmer	11	32	1018	2	stemmer
tamer	7	52	3010	2	t_amer
teamed	9	54	1859	2	teamed
tearer	6	48	2290	2	tearer
teaser	6	54	2152	2	teaser
tedder	8	33	1216	2	tedder
teem	6	61	3260	2	teem__
teems	7	60	1978	2	teem_s
teeners	7	44	1545	2	teeners
teenier	7	26	1114	2	teenier
teepee	8	3	1436	2	teepee
teeters	7	40	1830	2	teeters
teether	10	34	969	2	teether
tegmen	9	8	840	2	tegmen
telemen	9	3	1017	2	telemen
telfer	9	37	990	2	telfer
teller	6	35	1983	2	teller
temper	10	39	1409	2	temper
tender	7	41	2184	2	tender
tenner	6	41	1710	2	tenner
tenser	6	49	1943	2	tenser
tenter	6	46	2393	2	tenter
termed	9	48	1670	2	termed
termers	9	54	1450	2	termers
termor	8	44	1251	2	termor
terser	6	73	1782	2	terser
tester	6	42	2715	2	tester
tether	9	37	1610	2	tether
tetter	6	43	2245	2	tetter
theme	10	59	2173	2	theme_
themed	12	59	1258	2	themed
themes	11	53	1925	2	themes
timer	7	56	2604	2	t_imer
tremor	8	42	1040	2	tremor
trimer	8	57	1715	2	trimer
tweener	10	30	683	2	tweener
tweeter	10	28	853	2	tweeter
tweezer	19	30	576	2	tweezer
weeder	10	33	1551	2	weeder
weeper	11	43	1330	2	weeper
weever	12	38	1144	2	weever

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.356	501941.0
2	DLD Change Limit	82551	80	2.596	31799.3
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	2.982	59923.2