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

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

303 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
column	10	3	810	(None)
columns	11	3	647	1	columns
calumny	14	4	386	2	calumny
clump	11	55	1745	2	c_lump
colin	7	62	3169	2	col_in
colon	7	86	3019	2	col_on
colugo	9	3	586	2	colugo
columel	11	3	627	2	columel
columnal	12	4	441	2	columnal
columnar	12	4	371	2	columnar
columnea	12	4	367	2	columnea
columned	13	3	492	2	columned
colure	8	3	1416	2	colure
solemn	8	3	864	2	solemn
solum	7	47	1761	2	solum_
solums	8	52	1133	2	solums
volume	11	35	827	2	volume
alum	6	52	2761	3	_alum_
alumin	8	5	1354	3	_alumin
alumna	8	5	734	3	_alumna
alumni	8	5	675	3	_alumni
alums	7	57	2060	3	_alums
autumn	8	3	601	3	autumn
blume	9	56	1989	3	_blume
bolson	8	4	1068	3	bolson
bolus	7	91	2554	3	bolu_s
bosun	7	51	1359	3	bosu_n
bourn	7	55	1848	3	bo_urn
calami	10	3	1342	3	calami
calkin	12	35	1549	3	calkin
callan	8	36	1960	3	callan
calm	8	50	3236	3	cal_m_
calms	9	52	2235	3	cal_ms
calumet	11	3	1329	3	calumet
cecum	11	6	1184	3	cecum_
celom	9	5	1568	3	celom_
celoms	10	4	1212	3	celoms
cerumen	11	4	776	3	cerumen
chum	11	63	1800	3	c_hum_
chump	14	53	1544	3	c_hump
chums	12	50	1583	3	c_hums
churn	10	51	1310	3	c_hurn
cilium	10	43	1137	3	cilium_
clam	8	63	3229	3	c_lam_
clamp	11	55	1765	3	c_lamp
clams	9	51	2767	3	c_lams
clan	6	56	3392	3	c_l_an
clean	7	54	2041	3	c_lean
climb	11	54	1359	3	c_limb
clime	9	57	2089	3	c_lime
clomb	11	57	1470	3	c_lomb
clomp	11	56	1570	3	c_lomp
clon	6	62	3248	3	c_l_on
cloud	8	67	1642	3	clou_d
clouds	9	46	1235	3	clouds
cloudy	12	51	780	3	cloudy
clough	12	53	913	3	clough
clour	7	66	1728	3	clou_r
clours	8	52	1509	3	clours
clout	7	53	3046	3	clou_t
clouts	8	70	1720	3	clouts
cloven	11	42	1151	3	cloven
clown	10	52	1473	3	c_lown
club	8	58	1947	3	c_lu_b
clubman	13	4	402	3	c_lubman
clubmen	13	3	425	3	c_lubmen
clubs	9	54	1510	3	c_lubs
cluck	13	49	1489	3	c_luck
clue	6	53	2453	3	c_lu_e
clued	8	49	1768	3	c_lued
clues	7	46	2303	3	c_lues
cluing	9	39	1350	3	c_luing
clumps	12	153	1464	3	c_lumps
clumpy	15	40	957	3	c_lumpy
clumsy	13	32	619	3	c_lumsy
clung	8	60	1360	3	c_lung
clunk	11	42	1508	3	c_lunk
coalbin	11	3	753	3	coalbin
cocain	10	13	1501	3	cocain
cochin	13	13	1320	3	cochin
cocoon	10	3	1226	3	cocoon
codein	9	49	1672	3	codein
coden	8	61	2854	3	co_den
codlin	9	45	1644	3	codlin
codon	8	65	2285	3	co_don
coelom	10	3	1042	3	coelom_
coelome	11	3	968	3	coelome
coeloms	11	3	906	3	coeloms
coffin	14	33	981	3	coffin
cogon	8	91	2090	3	co_gon
cohune	11	8	942	3	cohune
coign	8	50	1391	3	co_ign
coin	6	66	4535	3	co__in
cojoin	15	3	950	3	cojoin
col	5	93	6035	3	col___
cola	6	65	4139	3	col__a
colas	7	54	3677	3	col_as
colby	12	44	1506	3	col_by
colbys	13	40	715	3	colbys
cold	7	73	3877	3	col__d
colder	9	51	2184	3	colder
coldly	12	45	995	3	coldly
colds	8	57	2697	3	col_ds
cole	6	69	5611	3	col__e
colead	9	41	1464	3	colead
coled	8	55	4075	3	col_ed
coles	7	60	5506	3	col_es
coleus	8	68	1827	3	coleus
colic	9	57	2617	3	col_ic
colicin	11	3	1374	3	colicin
colics	10	42	1990	3	colics
colies	8	48	3705	3	colies
colins	8	52	2904	3	colins
collar	8	38	1617	3	collar
colleen	9	3	953	3	colleen
collet	8	40	3036	3	collet
collie	8	36	2199	3	collie
collins	9	34	1983	3	collins
collop	10	73	1231	3	collop
collude	10	33	798	3	collude
colly	10	49	2677	3	col_ly
colobi	10	50	1108	3	colobi
colog	8	66	1993	3	col_og
cologne	10	3	935	3	cologne
cologs	9	65	1735	3	cologs
colone	8	54	2500	3	colone
coloni	8	56	1920	3	coloni
colons	8	60	2868	3	colons
colony	11	54	1727	3	colony
color	7	61	2374	3	col_or
colorman	12	4	789	3	colorman
colormen	12	4	724	3	colormen
colors	8	66	2237	3	colors
colour	8	59	1509	3	colour
colours	9	59	1344	3	colours
cols	6	65	5308	3	col__s
colt	6	71	5824	3	col__t
colter	8	46	2509	3	colter
colts	7	66	3329	3	col_ts
colugos	10	3	569	3	colugos
columbic	16	4	344	3	columbic
columbine	15	4	426	3	columbine
columels	12	4	481	3	columels
columneas	13	4	301	3	column~~eas~~
columnist	13	4	647	3	column~~ist~~
colures	9	3	1514	3	colures
coly	9	69	4053	3	col__y
colza	16	51	1298	3	col_za
colzas	17	40	1051	3	colzas
coma	8	71	3485	3	co__ma
comb	10	66	3211	3	co__mb
come	8	75	4770	3	co__me
comma	11	45	1479	3	co_mma
common	12	3	1080	3	common
commune	13	32	936	3	commune
commy	14	47	1264	3	co_mmy
comp	10	67	3125	3	co__mp
con	5	102	6802	3	co___n
condemn	12	3	711	3	condemn
conin	7	62	3272	3	co_nin
conium	10	4	1531	3	conium_
coniums	11	3	1186	3	coniums
conn	6	62	2913	3	co__nn
consume	11	5	1013	3	consume
contemn	11	3	780	3	contemn
conus	7	67	2653	3	conu_s
coomb	11	56	1570	3	co_omb
coon	6	72	4894	3	co__on
copen	9	48	2643	3	co_pen
copula	10	28	1204	3	copula
coquet	17	43	1801	3	coquet
coquina	18	3	574	3	coquina
corban	10	3	1469	3	corban
cordon	9	50	1729	3	cordon
corium	10	3	1572	3	corium_
corm	8	57	3537	3	co_rm_
corms	9	56	2622	3	co_rms
corn	6	99	4581	3	co__rn
cortin	8	24	2315	3	cortin
corymb	15	3	522	3	corymb
cosign	9	5	878	3	cosign
costume	11	5	785	3	costume
cotan	7	15	2178	3	co_tan
cothurn	12	4	505	3	cothurn
cotton	8	3	1299	3	cotton
couch	12	53	2011	3	co_uch
coude	8	50	2263	3	co_ude
cough	11	58	1964	3	co_ugh
could	8	65	1771	3	co_uld
coulee	8	3	2350	3	coulee
coulis	8	40	1876	3	coulis
coulomb	13	4	455	3	coulomb
count	7	49	3205	3	co_unt
coup	8	67	2979	3	co_u_p
coupe	9	60	2348	3	co_upe
coupon	10	28	1099	3	coupon
coups	9	55	2247	3	co_ups
court	7	55	3277	3	co_urt
cousin	8	5	1716	3	cousin
couth	10	61	2249	3	co_uth
coven	10	69	2504	3	co_ven
covin	10	56	2112	3	co_vin
cowman	13	9	1037	3	cowman
cowmen	13	8	1092	3	cowmen
cozen	16	50	1970	3	co_zen
crumb	11	43	1359	3	c_rumb
crump	11	56	1642	3	c_rump
culm	8	58	2238	3	cul_m_
culms	9	53	1419	3	cul_ms
cum	7	64	4016	3	c__um_
cumin	9	46	1697	3	c__umin
curn	6	67	3188	3	c__urn
dolma	8	62	1417	3	dol_ma
dolman	9	53	1240	3	dolman
dolmen	9	39	1137	3	dolmen
doum	7	62	2667	3	do_um_
douma	8	58	1770	3	do_uma
doums	8	54	1764	3	do_ums
eolian	6	3	1259	3	eolian
filum	10	50	1543	3	filum_
flume	10	60	2117	3	_flume
flump	12	46	1472	3	_flump
folium	11	3	1045	3	folium_
foliums	12	3	717	3	foliums
forum	10	83	1876	3	forum_
forums	11	46	1184	3	forums
glum	7	58	2510	3	_glum_
glume	8	51	2046	3	_glume
glums	8	46	2142	3	_glums
gluon	6	3	1122	3	_gluon
golden	8	44	1115	3	golden
goldurn	9	4	333	3	goldurn
golem	8	4	1611	3	golem_
golems	9	3	932	3	golems
hilum	10	55	1460	3	hilum_
hokum	14	3	677	3	hokum_
hokums	15	3	392	3	hokums
holden	10	41	1395	3	holden
holm	9	56	2811	3	hol_m_
holms	10	51	1780	3	hol_ms
holpen	11	29	941	3	holpen
illume	8	29	822	3	illume
jorum	14	55	1374	3	jorum_
jorums	15	40	809	3	jorums
korun	9	4	1192	3	koru_n
limn	6	65	2769	3	__limn
locum	9	48	1217	3	locum_
locums	10	47	830	3	locums
louma	7	62	1363	3	lo_uma
lum	5	55	4293	3	__lum_
luma	6	55	2752	3	__luma
lumen	7	52	2090	3	__lumen
lump	8	65	3170	3	__lump
lums	6	57	3424	3	__lums
molten	8	33	1181	3	molten
moulin	8	3	1328	3	moulin
mourn	7	72	1501	3	mo_urn
notum	7	6	1169	3	notum_
noun	4	57	2418	3	no_u_n
olden	6	51	1485	3	_olden
olein	5	3	1600	3	_olein
oleum	7	36	1332	3	_oleum_
oleums	8	35	878	3	_oleums
ovum	9	23	1017	3	_ovum_
plum	8	51	2210	3	_plum_
plumb	11	45	1407	3	_plumb
plume	9	48	1946	3	_plume
plump	11	53	1526	3	_plump
plums	9	46	1995	3	_plums
plumy	12	42	1323	3	_plumy
poleyn	11	5	732	3	poleyn
pollen	8	34	1645	3	pollen
relume	8	3	1327	3	relume
rouen	5	49	2090	3	ro_uen
schlump	16	4	326	3	schlump
shlump	13	4	571	3	shlump
slum	6	54	3051	3	_slum_
slump	9	48	1663	3	_slump
slums	7	46	2343	3	_slums
solan	5	53	2815	3	sol_an
soldan	7	35	1185	3	soldan
solion	6	6	1638	3	solion
solon	5	50	2613	3	sol_on
solus	5	47	2698	3	solu_s
solute	6	40	1666	3	solute
tolan	5	51	2401	3	tol_an
tollman	9	3	586	3	tollman
tollmen	9	3	573	3	tollmen
tolu	4	55	2915	3	tolu__
toluene	7	3	646	3	toluene
toluic	8	3	769	3	toluic
toluid	7	3	821	3	toluid
toluol	6	3	690	3	toluol
tolus	5	50	2448	3	tolu_s
toluyl	9	3	344	3	toluyl
velum	10	7	1338	3	velum_
vodun	9	3	722	3	vodu_n
volumed	13	28	568	3	volumed
volumes	12	29	823	3	volumes
voluming	14	3	504	3	voluming
volute	9	39	1276	3	volute
volutin	10	9	810	3	volutin
yourn	8	75	1277	3	yo_urn

Search took 6 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	112716	0.170	1051123.5
2	DLD Change Limit	112716	303	5.686	19823.4
3	Display Results	303	303	0.096	3156.3
	(SQL Overall)	178691	303	5.952	30022.0