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

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

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.

21 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
lemmatizes	23	4	501	(None)
lemmatize	22	4	556	1	lemmatize_
lemmatized	24	4	428	1	lemmatized
aromatizes	21	5	919	3	aromatizes
clematises	14	4	573	3	cle_matises
climatizes	23	11	613	3	climatizes
dogmatizes	23	6	549	3	dogmatizes
dramatizes	22	4	736	3	dramatizes
empathizes	26	7	344	3	_empathizes
gemmates	13	30	767	3	gemmat__es
gemmations	15	4	500	3	gemmations
germanizes	22	4	815	3	germanizes
hematines	14	13	1220	3	he_matines
hematites	14	15	1079	3	he_matites
hepatizes	23	4	782	3	he_patizes
legalizes	19	3	867	3	le_galizes
lemmatizing	25	5	436	3	lemmatizing
mediatizes	22	4	560	3	mediatizes
pegmatites	15	4	475	3	pegmatites
rheumatizes	25	5	339	3	rheumatizes
summarizes	23	12	565	3	summarizes

Search took 8 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	140603	0.436	409841.7
2	DLD Change Limit	140603	21	6.563	21423.6
3	Display Results	21	21	0.013	1615.4
	(SQL Overall)	178691	21	7.012	25483.6