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

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

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

262 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
clons	7	52	2813	(None)
cions	7	52	2285	1	cions
clans	7	50	3101	1	clans
clods	8	53	2086	1	clods
clogs	8	55	1955	1	clogs
clon	6	62	3248	1	clon_
clone	7	57	2816	1	clone
clones	8	45	2656	1	clones
clonk	11	44	1744	1	clonk
clonks	12	50	1347	1	clonks
clonus	8	52	1241	1	clonus
clops	9	59	2485	1	clops
clots	7	56	2764	1	clots
clowns	11	48	1011	1	clowns
cloys	10	49	1694	1	cloys
colons	8	60	2868	1	colons
cons	6	60	5769	1	c_ons
coons	7	67	3728	1	coons
aeons	5	76	2465	2	aeons
agons	6	64	2378	2	agons
alans	5	56	3617	2	alans
aloes	5	49	3367	2	aloes
aloins	6	50	2220	2	aloins
alone	5	57	3296	2	alone
along	6	54	1949	2	along
axons	12	55	1793	2	axons
azlons	15	41	1042	2	azlons
azons	14	65	1825	2	azons
belons	8	41	1941	2	belons
blobs	9	56	2003	2	blobs
blocs	9	52	1965	2	blocs
blogs	8	53	1923	2	blogs
blond	8	56	1837	2	blond
blonds	9	52	1334	2	blonds
blots	7	56	2617	2	blots
blows	10	54	2383	2	blows
boons	7	50	3191	2	boons
cains	7	53	3430	2	cains
calos	7	44	3190	2	calo_s
canons	8	55	2206	2	canons
cans	6	50	5085	2	c_ans
capons	10	41	1950	2	capons
carns	7	59	3756	2	carns
celoms	10	4	1212	2	celoms
chins	10	56	3146	2	chins
chon	9	66	2779	2	chon_
chops	12	50	1987	2	chops
chows	13	56	1820	2	chows
cion	6	133	3091	2	cion_
clads	8	57	2273	2	clads
clags	8	56	2112	2	clags
clams	9	51	2767	2	clams
clan	6	56	3392	2	clan_
clang	8	60	1931	2	clang
clangs	9	51	1361	2	clangs
clank	11	47	1952	2	clank
clanks	12	46	1518	2	clanks
claps	9	56	2618	2	claps
class	7	55	2548	2	class
claws	10	60	2083	2	claws
claxons	16	3	580	2	claxons
clays	10	55	2133	2	clays
cleans	8	58	1705	2	cleans
clefs	10	66	1624	2	clefs
clews	10	55	1633	2	clews
cline	7	64	2853	2	cline
clines	8	49	2604	2	clines
cling	8	64	2467	2	cling
clings	9	57	1621	2	clings
clink	11	53	2004	2	clink
clinks	12	58	1506	2	clinks
clips	9	60	1830	2	clips
cloak	11	52	1401	2	cloak
cloaks	12	44	1126	2	cloaks
clock	13	49	1798	2	clock
clocks	14	49	1623	2	clocks
clod	7	61	2461	2	clo_d
clog	7	61	2324	2	clo_g
clomb	11	57	1470	2	clomb
clomp	11	56	1570	2	clomp
clomps	12	52	1223	2	clomps
clonal	8	3	1091	2	clonal
cloned	9	45	1880	2	cloned
cloner	8	44	1809	2	cloner
cloners	9	45	1482	2	cloners
clonic	10	49	1467	2	clonic
clonism	11	3	898	2	clonism
cloot	7	61	2705	2	cloot
cloots	8	51	1369	2	cloots
clop	8	69	2989	2	clo_p
close	7	64	2522	2	close
closes	8	54	2559	2	closes
clot	6	65	4242	2	clo_t
cloth	10	58	1754	2	cloth
cloths	11	55	1248	2	cloths
cloud	8	67	1642	2	cloud
clouds	9	46	1235	2	clouds
clour	7	66	1728	2	clour
clours	8	52	1509	2	clours
clout	7	53	3046	2	clout
clouts	8	70	1720	2	clouts
clove	10	56	1944	2	clove
cloves	11	49	1882	2	cloves
clown	10	52	1473	2	clown
cloy	9	66	2383	2	clo_y
cloze	16	55	1754	2	cloze
clozes	17	49	1556	2	clozes
clubs	9	54	1510	2	clubs
clues	7	46	2303	2	clues
clung	8	60	1360	2	clung
clunk	11	42	1508	2	clunk
clunks	12	48	1101	2	clunks
cobs	8	70	4314	2	c_obs
codons	9	61	1946	2	codons
cods	7	68	4810	2	c_ods
cogons	9	68	1811	2	cogons
cogs	7	73	4003	2	c_ogs
coins	7	58	3455	2	coins
colas	7	54	3677	2	colas
colds	8	57	2697	2	colds
coles	7	60	5506	2	coles
colins	8	52	2904	2	colins
cologs	9	65	1735	2	cologs
colon	7	86	3019	2	colon_
colone	8	54	2500	2	colone
colones	9	61	2443	2	colones
coloni	8	56	1920	2	coloni
colonus	9	44	1344	2	colonus
colony	11	54	1727	2	colony
colors	8	66	2237	2	colors
cols	6	65	5308	2	c_ols
colts	7	66	3329	2	colts
con	5	102	6802	2	c_on_
cone	6	72	5696	2	c_one
cones	7	64	5742	2	c_ones
coni	6	55	3480	2	c_oni
conk	10	65	3144	2	c_onk
conks	11	55	2570	2	c_onks
conn	6	62	2913	2	c_onn
conns	7	50	2423	2	conns
conus	7	67	2653	2	c_onus
cony	9	65	3783	2	c_ony
coofs	10	59	2471	2	coofs
cooks	11	54	2914	2	cooks
cools	7	56	3263	2	cools
coon	6	72	4894	2	coon_
coops	9	62	2964	2	coops
coos	6	74	5649	2	c_oos
coots	7	56	3684	2	coots
cops	8	67	5137	2	c_ops
corns	7	60	3476	2	corns
cors	6	66	5644	2	c_ors
cos	5	102	7039	2	c_o_s
coss	6	61	4349	2	c_oss
cots	6	80	5484	2	c_ots
cows	9	70	4664	2	c_ows
coys	9	75	3724	2	c_oys
crocs	9	57	2243	2	crocs
crone	7	52	3133	2	crone
crones	8	47	2924	2	crones
crony	10	59	1867	2	crony
croons	8	54	1842	2	croons
crops	9	61	2523	2	crops
cross	7	51	2450	2	cross
crowns	11	56	1511	2	crowns
crows	10	57	2731	2	crows
curns	7	49	2427	2	curns
cyans	10	57	1481	2	cyans
cytons	11	17	1018	2	cytons
dons	5	60	4870	2	_dons
ebons	7	43	1609	2	ebons
elans	5	55	2775	2	elans
eloins	6	54	1938	2	eloins
eons	4	66	3871	2	_eons
exons	12	58	1334	2	exons
felons	9	36	1576	2	felons
flans	8	53	2797	2	flans
flocs	10	55	1923	2	flocs
floes	8	55	2814	2	floes
flogs	9	59	1996	2	flogs
flong	9	58	1568	2	flong
flongs	10	50	1049	2	flongs
flops	10	59	2014	2	flops
floss	8	51	1826	2	floss
flows	11	58	2236	2	flows
fons	7	69	4389	2	_fons
frons	8	61	2404	2	frons
glans	6	51	2583	2	glans
glens	6	65	1985	2	glens
globs	8	56	1640	2	globs
gloms	8	52	1978	2	gloms
glops	8	56	1955	2	glops
gloss	6	43	1962	2	gloss
glows	9	55	1803	2	glows
gluons	7	3	850	2	gluons
goons	6	53	2677	2	goons
halons	9	57	2071	2	halons
hons	7	73	5078	2	_hons
icons	7	65	1649	2	icons
ikons	9	63	1101	2	ikons
ions	4	67	3785	2	_ions
irons	5	53	2413	2	irons
kaons	9	50	1485	2	kaons
klong	10	53	1040	2	klong
klongs	11	43	660	2	klongs
lens	4	61	4649	2	_lens
lins	4	70	5905	2	_lins
lions	5	59	2321	2	lions
loans	5	60	2646	2	_loans
lobs	6	64	4108	2	_lobs
logs	5	73	4311	2	_logs
loins	5	67	2842	2	_loins
lone	4	58	4913	2	_lone
long	5	69	3334	2	_long
longs	6	55	2706	2	_longs
loons	5	57	3172	2	loons
loos	4	90	5112	2	_loos
lops	6	60	4335	2	_lops
loss	4	53	3796	2	_loss
lots	4	76	5209	2	_lots
lows	7	58	4301	2	_lows
melons	8	41	1771	2	melons
mons	6	81	5226	2	_mons
moons	7	53	3100	2	moons
muons	7	58	1617	2	muons
neons	5	58	1868	2	neons
noons	5	41	2528	2	noons
nylons	9	26	797	2	nylons
ons	3	61	4851	2	__ons
orlons	6	4	1101	2	orlons
peons	7	53	2718	2	peons
phons	10	52	2114	2	phons
pions	7	58	2639	2	pions
plans	7	57	3127	2	plans
pleons	8	42	1334	2	pleons
plods	8	57	1929	2	plods
plonk	11	46	1398	2	plonk
plonks	12	42	1042	2	plonks
plops	9	59	2033	2	plops
plots	7	50	2567	2	plots
plows	10	54	1990	2	plows
ploys	10	58	1659	2	ploys
pons	6	58	5060	2	_pons
poons	7	54	3097	2	poons
pylons	11	30	1124	2	pylons
salons	6	38	2369	2	salons
scions	8	26	1224	2	scions
slobs	7	44	1987	2	slobs
sloes	5	47	2887	2	sloes
slogs	6	45	2184	2	slogs
slops	7	50	2601	2	slops
slots	5	48	3053	2	slots
slows	8	53	2346	2	slows
solons	6	51	2002	2	solons
sons	4	60	4955	2	_sons
talons	6	40	1944	2	talons
tons	4	65	5305	2	_tons
toons	5	50	2753	2	toons
udons	6	54	1146	2	udons
ulans	5	49	2130	2	ulans
wons	7	49	4204	2	_wons
zoons	14	49	1969	2	zoons

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	262	1.550	34709.7
3	Display Results	262	262	0.076	3447.4
	(SQL Overall)	178691	262	1.719	103950.6