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

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

24 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
schemed	15	7	775	(None)
scheme	13	7	963	1	scheme_
schemer	14	7	796	1	schemer
schemes	14	8	966	1	schemes
chefed	15	50	1056	2	_chefed
chewed	15	44	1501	2	_chewed
chimed	14	58	1483	2	_chimed
eschewed	17	4	344	2	eschewed
ochered	13	26	1028	2	ochered
sacheted	14	12	784	2	sacheted
scammed	14	47	954	2	scammed
schema	13	8	837	2	schem_a
schemas	14	6	816	2	schemas
schemers	15	7	671	2	schemers
schmeer	14	7	536	2	schmeer
screamed	13	27	760	2	screamed
screed	9	57	1893	2	scre_ed
screwed	13	57	1066	2	screwed
scummed	14	34	791	2	scummed
seemed	9	51	1761	2	s_eemed
shamed	12	51	2021	2	s_hamed
shewed	13	47	1618	2	s_hewed
sphered	13	35	1231	2	sphered
themed	12	59	1258	2	_themed

Search took 6 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	107671	0.766	233278.1
2	DLD Change Limit	107671	24	4.263	25257.1
3	Display Results	24	24	0.016	1500.0
	(SQL Overall)	178691	24	5.045	35419.4