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

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

82 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
colone	8	54	2500	(None)
clone	7	57	2816	1	c_lone
cologne	10	3	936	1	cologne
colon	7	86	3019	1	colon_
colonel	9	42	1328	1	colonel
colones	9	61	2443	1	colones
coloni	8	56	1920	1	coloni
colons	8	60	2868	1	colons
colony	11	54	1727	1	colony
alone	5	57	3296	2	_alone
boloney	12	4	776	2	boloney
calzone	18	4	862	2	calzone
chalone	12	3	1210	2	chalone
choline	12	29	1538	2	choline
cline	7	64	2853	2	c_line
clon	6	62	3248	2	c_lon_
cloned	9	45	1880	2	c_loned
cloner	8	44	1809	2	c_loner
clones	8	45	2656	2	c_lones
clonk	11	44	1744	2	c_lonk
clons	7	52	2813	2	c_lons
close	7	64	2522	2	c_lose
clove	10	56	1944	2	c_love
cloze	16	55	1754	2	c_loze
codon	8	65	2285	2	codon_
codons	9	61	1946	2	codons
coelome	11	3	969	2	coelome
cogon	8	91	2090	2	cogon_
cogons	9	68	1811	2	cogons
cohune	11	8	942	2	cohune
coigne	9	46	1219	2	coigne
cojones	16	35	1210	2	cojones
cole	6	69	5611	2	col__e
colin	7	62	3169	2	colin_
colins	8	52	2904	2	colins
collie	8	36	2199	2	collie
colobi	10	50	1108	2	colobi
colog	8	66	1993	2	colo_g
cologned	12	3	715	2	cologned
colognes	11	3	1060	2	colognes
cologs	9	65	1735	2	cologs
colonels	10	42	1045	2	colonels
colonic	11	50	1571	2	colonic
colonies	10	36	2001	2	colonies
colonise	10	25	1428	2	colonise
colonize	19	23	1277	2	colonize
colonus	9	44	1344	2	colonus
color	7	61	2374	2	colo_r
colored	10	3	1347	2	colored
colorer	9	3	1252	2	colorer
colors	8	66	2237	2	colors
colour	8	59	1509	2	colour
colure	8	3	1416	2	colure
comose	10	50	1684	2	comose
compone	13	65	1719	2	compone
condone	10	26	1629	2	condone
cone	6	72	5696	2	c__one
conine	8	45	2855	2	conine
cooee	7	45	3102	2	co_oee
coolie	8	38	2160	2	coolie
coon	6	72	4894	2	co_on_
coons	7	67	3728	2	co_ons
corona	8	38	1740	2	corona
coronae	9	42	1489	2	coronae
coronel	9	45	1522	2	coronel
coroner	9	42	1820	2	coroner
coronet	9	42	2717	2	coronet
cosine	8	38	2351	2	cosine
coyote	11	4	1178	2	coyote
crone	7	52	3133	2	c_rone
cyclone	14	3	724	2	cyclone
ecotone	9	3	858	2	ecotone
ionone	6	3	1344	2	ionone
lone	4	58	4913	2	__lone
moline	8	44	2203	2	moline
ochone	11	3	1129	2	ochone
oolong	7	3	807	2	oolong
ozone	14	3	1061	2	_ozone
solon	5	50	2613	2	solon_
solons	6	51	2002	2	solons
tolane	6	43	1658	2	tolane
violone	10	3	715	2	violone

Search took 3 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.343	520965.0
2	DLD Change Limit	82551	82	2.486	33206.4
3	Display Results	82	82	0.013	6307.7
	(SQL Overall)	178691	82	2.842	62875.1