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

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

86 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
compts	12	52	1665	(None)
coapts	10	46	1400	1	coapts
coempts	13	3	568	1	coempts
comets	10	58	2358	1	comets
compas	12	58	1706	1	compas
compos	12	48	1880	1	compos
comps	11	55	2605	1	comp_s
compt	11	63	2822	1	compt_
coopts	10	58	1458	1	coopts
campos	12	52	1795	2	campos
camps	11	63	3026	2	camp_s
campus	12	52	1392	2	campus
chomps	15	51	1222	2	chomp_s
clomps	12	52	1223	2	clomp_s
coacts	10	53	1432	2	coacts
coapt	9	61	3152	2	coapt_
coasts	8	57	1913	2	coasts
coats	7	56	3499	2	co_ats
coempt	12	3	1103	2	coempt_
colts	7	66	3329	2	co_lts
comas	9	58	3300	2	com_as
comate	10	41	2484	2	comate
comates	11	41	2363	2	comates
combats	13	3	1168	2	combats
combes	12	53	2173	2	combes
combos	12	53	1661	2	combos
combs	11	61	2296	2	com_bs
comers	10	53	2808	2	comers
comes	9	72	4699	2	com_es
comet	9	59	4607	2	comet_
cometh	13	48	1168	2	cometh
comfits	14	32	874	2	comfits
comics	12	40	1556	2	comics
comity	13	3	1271	2	comity
commas	12	48	1457	2	commas
commits	13	38	1237	2	commits
comous	10	8	1650	2	comous
comp	10	67	3125	2	comp__
compacts	16	36	890	2	compacts
comparts	14	42	1083	2	comparts
compass	13	37	956	2	compass
comped	13	59	1987	2	comped
compel	12	44	1289	2	compel
compels	13	32	1088	2	compels
compete	13	47	1655	2	compete
competes	14	41	1724	2	competes
complots	14	3	816	2	complots
comply	15	28	1038	2	comply
compo	11	53	1857	2	comp_o
comports	14	34	1198	2	comports
compose	13	57	1666	2	compose
compost	13	45	1535	2	compost
composts	14	42	1091	2	composts
compote	13	56	1646	2	compote
compotes	14	47	1651	2	compotes
compted	14	38	1352	2	compted
compute	13	45	1365	2	compute
computes	14	39	1453	2	computes
comte	9	61	2547	2	com_te
comtes	10	62	2281	2	comtes
coops	9	62	2964	2	coop_s
coopt	9	59	2985	2	coopt_
coots	7	56	3684	2	co_ots
copes	9	77	4710	2	co_pes
cops	8	67	5137	2	co_p_s
corps	9	59	2704	2	corp_s
corpus	10	60	1529	2	corpus
cosets	8	58	2440	2	cosets
costs	7	72	3114	2	co_sts
cots	6	80	5484	2	co__ts
counts	8	46	1827	2	counts
coupes	10	50	2252	2	coupes
coups	9	55	2247	2	coup_s
courts	8	42	1616	2	courts
covets	11	48	1964	2	covets
cowpats	14	3	771	2	cowpats
coypus	13	38	930	2	coypus
crypts	13	39	774	2	crypts
omits	7	50	1826	2	_omits
oomphs	13	4	472	2	oomphs
opts	6	81	2474	2	_o_pts
pomps	11	53	1619	2	pomp_s
prompts	13	3	747	2	prompts
romps	9	46	1754	2	romp_s
tempts	10	43	945	2	tempts
vomits	11	26	1092	2	vomits

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	86	2.860	28864.0
3	Display Results	86	86	0.013	6615.4
	(SQL Overall)	178691	86	2.999	59583.5