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

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

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.

19 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
toxophilite	23	5	252	(None)
toxophilites	24	5	189	1	toxophilites
toxophilies	23	5	365	2	toxophilies
toxophily	24	4	312	3	toxophil__y
homophile	19	4	810	4	homophil__e
logophile	15	11	510	4	logophil__e
lyophilise	18	5	406	4	_lyophilise
lyophilize	27	5	341	4	_lyophilize
ophiolite	14	4	463	4	___ophiolite
oxyphile	23	4	239	4	_oxyphil__e
oxyphilic	26	5	226	4	_oxyphili_c
toothlike	16	4	372	4	to_oth_like
troilite	8	4	954	4	t_ro__ilite
turophile	14	7	588	4	turophil__e
zoophile	22	4	645	4	zo_ophil__e
zoophilia	23	5	465	4	zo_ophili_a
zoophilias	24	5	400	4	zo_ophilias
zoophilic	25	4	508	4	zo_ophili_c
zoophilies	24	4	480	4	zo_ophilies

Search took 10 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	148819	0.470	380193.6
2	DLD Change Limit	148819	19	8.670	17164.8
3	Display Results	19	19	0.016	1187.5
	(SQL Overall)	178691	19	9.156	19516.3