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

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

65 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
cometary	15	4	769	(None)
cemetery	15	5	492	2	cemetery
commentary	19	4	575	2	commentary
momentary	16	4	523	2	momentary
monetary	13	4	652	2	monetary
biometry	15	4	618	3	biomet_ry
catenary	13	4	658	3	catenary
cavitary	16	6	496	3	cavitary
cedary	12	41	960	3	c__edary
cinerary	13	4	643	3	cinerary
comeback	20	4	592	3	comeback
comedy	14	37	823	3	come__dy
comelily	15	4	669	3	comelily
comely	13	42	1373	3	come__ly
comer	9	58	3269	3	come__r_
comers	10	53	2808	3	come__rs
comet	9	59	4607	3	comet___
cometh	13	48	1168	3	comet__h
comether	15	3	725	3	comether
comethers	16	3	744	3	comethers
cometic	13	12	1572	3	comet_ic
comets	10	58	2358	3	comet__s
comity	13	3	1271	3	comit__y
company	16	197	1114	3	com_pany
compare	13	58	1499	3	com_pare
compart	13	40	1600	3	com_part
contrary	13	4	749	3	contrary
coquetry	22	4	356	3	coquet_ry
coronary	13	4	769	3	coronary
corsetry	13	6	557	3	corset_ry
costar	8	55	1861	3	co_star_
costard	10	41	1335	3	co_stard
costars	9	42	1801	3	co_stars
costmary	15	4	505	3	costmary
cottar	8	46	1381	3	co_ttar_
cottars	9	44	1224	3	co_ttars
country	12	38	804	3	count_ry
covary	14	3	874	3	co__vary
coveter	12	29	1206	3	coveter_
coveters	13	24	1108	3	coveters
dietary	11	5	866	3	_dietary
dromedary	16	5	207	3	dromedary
geometry	14	4	539	3	geomet_ry
homestay	16	4	581	3	homesta_y
homeward	17	4	532	3	homeward
isometry	13	4	611	3	isomet_ry
limitary	13	4	493	3	limitary
mortary	12	36	904	3	mo_rtary
notary	9	23	1071	3	no__tary
numerary	13	4	428	3	numerary
odometry	14	4	475	3	odomet_ry
poetry	11	3	938	3	po_et_ry
proletary	14	4	584	3	proletary
rosemary	13	4	443	3	rosemary
rotary	9	24	1130	3	ro__tary
scimetar	12	4	404	3	scimetar_
scimetars	13	4	401	3	scimetars
smeary	11	41	1080	3	_sme_ary
solitary	11	4	650	3	solitary
someday	13	4	588	3	someda_y
someway	15	4	561	3	somewa_y
udometry	14	4	382	3	udomet_ry
vomitory	16	4	441	3	vomitory
votary	12	24	833	3	vo__tary
zoometry	22	4	464	3	zoomet_ry

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	146162	0.423	422437.4
2	DLD Change Limit	146162	65	7.420	19698.4
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	7.876	22688.0