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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
comfort	14	36	1169	(None)
comforts	15	34	732	1	comforts
comport	13	36	1684	1	comport
cohort	11	107	2026	2	co_hort
comfit	13	31	1242	2	comf_it
comforted	17	31	596	2	comforted
comforter	16	25	598	2	comforter
compart	13	40	1600	2	compart
comports	14	34	1198	2	comports
compost	13	45	1535	2	compost
conform	14	3	1045	2	conform
consort	9	13	1990	2	consort
contort	9	14	2234	2	contort
amort	7	58	3220	3	_am_ort
campout	13	4	1285	3	campout
carport	11	3	1603	3	carport
cavort	11	3	1617	3	c_avort
coexert	16	3	1236	3	coexert
coffer	14	41	1286	3	coffer_
coffers	15	41	1269	3	coffers
coffret	15	3	1007	3	coffret
coft	9	79	3968	3	co_f__t
cohorts	12	34	1110	3	co_horts
cohost	11	52	1721	3	co_host
colewort	13	4	1061	3	colewort
coliform	15	4	555	3	coliform
color	7	61	2374	3	co_lor_
colors	8	66	2237	3	co_lors
combat	12	3	1675	3	com_bat
comber	12	51	1850	3	comber_
combers	13	45	1662	3	combers
combo	11	45	1943	3	combo__
combos	12	53	1661	3	combo_s
combust	13	3	836	3	combust
comer	9	58	3269	3	com_er_
comers	10	53	2808	3	com_ers
comet	9	59	4607	3	com__et
comfier	14	3	916	3	comfier
comfiest	15	3	913	3	comfiest
comfits	14	32	874	3	comfits
comforters	17	27	519	3	comfort~~ers~~
comforting	18	16	593	3	comfort~~ing~~
comfrey	17	3	468	3	comfrey
comfy	15	37	1021	3	comf__y
comment	13	103	1770	3	comment
commit	12	40	1670	3	com_mit
commixt	20	35	762	3	commixt
commode	14	3	812	3	commode
common	12	3	1080	3	commo_n
commons	13	3	1104	3	commons
commove	16	3	596	3	commove
comose	10	50	1684	3	com_ose
comous	10	8	1650	3	com_ous
compact	15	37	1221	3	compact
compare	13	58	1499	3	compare
comparts	14	42	1083	3	comparts
compere	13	46	1662	3	compere
complot	13	3	1068	3	complot
compo	11	53	1857	3	compo__
compone	13	65	1719	3	compone
compony	16	130	1191	3	compony
comported	16	31	953	3	comported
compos	12	48	1880	3	compo_s
compose	13	57	1666	3	compose
composts	14	42	1091	3	composts
compote	13	56	1646	3	compote
compt	11	63	2822	3	com__pt
concert	11	33	2522	3	concert
concoct	10	3	1290	3	concoct
concord	12	5	1034	3	concord
condor	9	46	1697	3	condor_
condors	10	40	1857	3	condors
confect	14	36	1427	3	confect
confer	11	40	1868	3	confer_
confers	12	41	2009	3	confers
confirm	14	3	736	3	confirm
confit	11	33	1640	3	conf_it
conforms	15	3	887	3	conforms
confront	13	4	1160	3	confront
consorts	10	15	1234	3	consorts
contorts	10	11	1264	3	contorts
convert	12	37	2147	3	convert
cookout	13	4	1015	3	cookout
coopt	9	59	2985	3	co__opt
coot	6	78	6038	3	co__o_t
coplot	10	5	1827	3	coplo_t
copout	10	4	1878	3	co_pout
corpora	11	3	935	3	corpora
court	7	55	3277	3	co__urt
covert	11	49	2550	3	co_vert
crowfoot	16	4	409	3	crowfoot
discomfort	18	5	393	3	~~dis~~comfort
effort	12	3	862	3	_effort
fort	7	64	5644	3	___fort
gosport	10	10	1028	3	gosport
homeport	15	14	894	3	homeport
hotfoot	13	4	705	3	hotfoot
import	10	27	1376	3	_import
mort	6	67	5883	3	__m_ort
oxford	17	6	366	3	_oxford
piefort	12	4	953	3	piefort
pomfret	14	4	699	3	pomfret
tomfool	12	5	424	3	tomfool

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	134027	0.140	1276364.3
2	DLD Change Limit	134027	103	7.546	17761.3
3	Display Results	103	103	0.046	2239.1
	(SQL Overall)	178691	103	7.732	23110.6