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

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

37 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
comfier	14	3	916	(None)
campier	13	33	1327	2	campier
coalier	9	34	1618	2	coalier
cobbier	13	34	1016	2	cobbier
cockier	15	40	1362	2	cockier
codifier	14	4	716	2	codifier
coffer	14	41	1286	2	co_ffer
collier	9	36	1815	2	collier
comaker	15	34	1060	2	comaker
comber	12	51	1850	2	com_ber
combiner	14	25	972	2	combiner
comelier	12	3	1065	2	comelier
comer	9	58	3269	2	com__er
comfiest	15	3	913	2	comfiest
comfit	13	31	1242	2	comfi_t
comfits	14	32	874	2	comfits
comfrey	17	3	468	2	comfrey
commie	12	42	1552	2	commie_
commies	13	37	1845	2	commies
compeer	13	38	1155	2	compeer
compiler	14	3	837	2	compiler
complier	14	3	1025	2	complier
confer	11	40	1868	2	conf_er
confider	14	3	812	2	confider
confiner	13	3	1119	2	confiner
conifer	12	32	1264	2	conifer
copier	10	37	2289	2	co_pier
corkier	13	31	1430	2	corkier
cornier	9	30	1709	2	cornier
cosier	8	44	2375	2	co_sier
cottier	9	38	1417	2	cottier
courier	9	36	1789	2	courier
cowier	11	36	1616	2	co_wier
cozier	17	33	1514	2	co_zier
goofier	11	33	931	2	goofier
homier	11	64	1699	2	hom_ier
wombier	14	3	654	2	wombier

Search took 4 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.373	479064.3
2	DLD Change Limit	107671	37	3.016	35699.9
3	Display Results	37	37	0.016	2312.5
	(SQL Overall)	178691	37	3.405	52479.0