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

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

308 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
canteen	9	4	1108	(None)
canteens	10	3	857	1	canteens
anteed	7	56	1611	2	_anteed
canted	9	48	2578	2	cant_ed
canter	8	52	3011	2	cant_er
cantered	11	34	1598	2	cantered
canters	9	48	2773	2	canters
cantle	8	45	2215	2	cantle_
cantles	9	47	2141	2	cantles
canton	8	57	2299	2	cant_on
careen	8	41	1949	2	ca_reen
contemn	11	3	780	2	contemn
lantern	7	3	1001	2	lantern
lateen	6	40	1486	2	la_teen
nankeen	11	3	504	2	nankeen
ratteen	7	32	911	2	ratteen
sateen	6	38	1501	2	sa_teen
antae	5	68	2829	3	_antae_
ante	4	65	3890	3	_ant_e_
anted	6	63	2824	3	_ant_ed
anteing	8	3	1281	3	_anteing
antenna	7	4	638	3	_antenna
antes	5	63	3432	3	_ant_es
anthem	11	34	1034	3	_anthem
anther	9	37	1506	3	_anther
antigen	8	3	1112	3	_antigen
antler	6	46	1555	3	_antler
antre	5	52	2452	3	_antre_
antres	6	50	2100	3	_antres
astern	6	48	1581	3	_astern
atween	9	16	661	3	_atween
baleen	8	6	1305	3	ba_leen
banteng	10	4	636	3	banteng
banter	8	48	2533	3	bant_er
bantered	11	33	1363	3	bantered
banterer	10	28	1177	3	banterer
banters	9	46	2311	3	banters
banties	9	43	2476	3	banties
batmen	10	44	1430	3	ba_tmen
batten	8	52	1712	3	ba_tten
cabmen	12	36	1065	3	ca_bmen
caffein	15	3	533	3	caffein
caftan	11	17	1012	3	caft_an
callee	8	43	2729	3	callee_
callees	9	41	1778	3	callees
canakin	13	18	1083	3	canakin
canaled	10	36	1556	3	canaled
canape	10	9	1351	3	canape_
canapes	11	12	1308	3	canapes
cancan	10	3	1410	3	can_can
cancel	10	53	1668	3	can_cel
canceled	13	27	940	3	canceled
canceler	12	23	891	3	canceler
cancels	11	41	1331	3	cancels
cancer	10	42	2092	3	can_cer
cancered	13	24	1155	3	cancered
cancers	11	40	1858	3	cancers
candela	10	8	974	3	candela
candent	10	4	1736	3	candent
candied	11	38	1602	3	candied
candies	10	41	2561	3	candies
candle	9	43	2148	3	candle_
candled	11	38	1574	3	candled
candler	10	35	1659	3	candler
candles	10	44	2234	3	candles
cane	6	66	5312	3	can__e_
caned	8	58	3809	3	can__ed
caner	7	53	3477	3	can__er
caners	8	46	2920	3	can_ers
canes	7	53	5037	3	can__es
cangue	9	10	1244	3	cangue_
cangues	10	6	1182	3	cangues
canikin	13	18	975	3	canikin
canine	8	38	2670	3	canine_
canines	9	37	2403	3	canines
canities	10	15	1926	3	canities
canker	12	44	2252	3	can_ker
cankered	15	30	1022	3	cankered
cankers	13	44	1875	3	cankers
canned	9	50	2206	3	can_ned
cannel	8	42	1640	3	can_nel
cannelon	10	4	512	3	cannelon
cannels	9	34	1336	3	cannels
canner	8	46	2598	3	can_ner
canners	9	38	2266	3	canners
cannery	12	36	1001	3	cannery
cannie	8	38	1936	3	cannie_
cannier	9	40	1416	3	cannier
cannon	8	45	1444	3	can_non
canoe	7	56	2725	3	can_oe_
canoed	9	46	1896	3	can_oed
canoeing	11	3	1021	3	canoeing
canoer	8	51	2107	3	can_oer
canoers	9	43	1837	3	canoers
canoes	8	47	2588	3	can_oes
canon	7	47	2530	3	can__on
cant	6	63	6203	3	cant___
cantal	8	41	2203	3	cant_al
cantala	9	41	1467	3	cantala
cantals	9	39	1957	3	cantals
cantata	9	38	1181	3	cantata
cantdog	11	3	457	3	cantdog
cantering	12	24	1737	3	cantering
canthal	12	4	1005	3	canthal
canthi	11	3	1097	3	cant_hi
canthus	12	4	871	3	canthus
cantic	10	39	2054	3	cant_ic
cantilena	11	4	447	3	cantilena
cantina	9	34	1725	3	cantina
canting	10	47	2590	3	canting
canto	7	49	3101	3	cant__o
cantoned	11	14	1152	3	cantoned
cantons	9	52	2120	3	cantons
cantor	8	56	2152	3	cant_or
cantors	9	46	2075	3	cantors
cantos	8	48	2697	3	cant_os
cantrap	11	33	1028	3	cantrap
cantrip	11	29	1004	3	cantrip
cants	7	70	3694	3	cant__s
cantus	8	51	1776	3	cant_us
canty	10	52	2680	3	cant__y
canyon	11	45	1203	3	can_yon
canzone	18	5	881	3	canzone
captain	11	21	1106	3	captain
captan	10	16	1334	3	capt_an
caption	11	35	1369	3	caption
carageen	11	5	563	3	carageen
careens	9	45	1470	3	ca_reens
career	8	58	2224	3	ca_reer
carmen	10	40	1934	3	ca_rmen
carotene	10	3	913	3	carotene
carte	7	59	4042	3	cart_e_
carted	9	86	3144	3	cart_ed
cartel	8	50	2253	3	cart_el
cartels	9	46	1812	3	cartels
carter	8	49	3227	3	cart_er
carters	9	53	2725	3	carters
cartes	8	62	3947	3	cart_es
carton	8	45	2266	3	cart_on
cartoon	9	41	1446	3	cartoon
carven	11	47	1666	3	ca_rven
casein	8	32	1645	3	ca_sein
casern	8	47	1331	3	ca_sern
cassene	9	31	1154	3	cassene
caste	7	59	3236	3	cast_e_
caster	8	52	3257	3	cast_er
casters	9	47	2990	3	casters
castes	8	56	3186	3	cast_es
castle	8	49	1896	3	castle_
castled	10	43	1151	3	castled
castles	9	49	1773	3	castles
cate	6	62	5460	3	ca_t_e_
catena	8	3	1248	3	ca_tena
cater	7	48	4072	3	ca_t_er
cateran	9	3	1377	3	ca_teran
catered	10	31	1777	3	ca_tered
caterer	9	28	1594	3	ca_terer
caters	8	53	3650	3	ca_ters
cates	7	59	5189	3	ca_t_es
cation	8	39	2550	3	ca_tion
catkin	12	35	1238	3	ca_tkin
catlin	8	38	1908	3	ca_tlin
catted	9	54	2247	3	ca_tted
cattery	12	38	1160	3	cattery
cattie	8	52	2102	3	cattie_
cattier	9	33	1707	3	cattier
catties	9	40	2305	3	catties
cattle	8	51	1890	3	cattle_
cattlemen	13	4	433	3	cattlemen
cautery	12	34	959	3	cautery
caution	9	30	1352	3	caution
cavemen	14	3	714	3	cavemen
cavern	11	53	1245	3	ca_vern
center	8	44	2141	3	cent_er
centered	11	25	1352	3	centered
centers	9	44	2060	3	centers
centeses	10	7	944	3	centeses
centner	9	4	685	3	centner
centre	8	43	1664	3	centre_
centred	10	34	1168	3	centred
centres	9	38	1712	3	centres
chanted	13	40	1595	3	chant_ed
chanter	12	39	1973	3	chant_er
chanters	13	40	1674	3	chanters
chantey	15	41	1254	3	chant_ey
chanteys	16	38	749	3	chanteys
chanties	13	26	1580	3	chanties
chasten	12	43	1240	3	chast_en
cistern	9	33	1070	3	cistern
cittern	9	33	914	3	cittern
clansmen	12	4	572	3	clansmen
coatee	8	43	2722	3	coatee_
coatees	9	38	1655	3	coatees
colleen	9	3	954	3	colleen
concern	11	30	1196	3	concern
condemn	12	3	711	3	condemn
congee	9	60	2447	3	congee_
congeed	11	32	1231	3	congeed
congees	10	35	1792	3	congees
contain	9	3	1583	3	contain
conte	7	66	3320	3	cont_e_
contemns	12	3	740	3	contemns
contend	10	35	1189	3	contend
content	9	43	2615	3	content
contes	8	44	3291	3	cont_es
contest	9	35	2323	3	contest
context	16	39	1343	3	context
convene	12	33	1432	3	convene
cyanogen	14	10	451	3	cyanogen
cystein	12	4	605	3	cystein
dasheen	11	3	639	3	dasheen
earthen	10	3	925	3	earthen
eastern	7	44	1253	3	eastern
eaten	5	53	2305	3	ea_t_en
fasten	9	51	1489	3	fast_en
fatten	9	43	1490	3	fa_tten
fifteen	13	4	392	3	fifteen
gantlet	8	36	1624	3	gantlet
gatemen	10	4	760	3	ga_temen
genteel	8	3	675	3	genteel
grantee	8	32	1713	3	grantee_
grantees	9	25	1097	3	grantees
hangmen	13	3	738	3	hangmen
hanted	10	41	2431	3	hant_ed
hantle	9	43	1820	3	hantle_
hantles	10	41	1751	3	hantles
hapten	11	53	1298	3	hapt_en
haptene	12	38	1093	3	haptene
hasten	9	57	1856	3	hast_en
intern	6	40	1654	3	_intern
kamseen	13	4	401	3	kamseen
kantele	11	3	825	3	kantele
kanteles	12	3	812	3	kanteles
lactean	9	5	647	3	lactean
landmen	10	3	855	3	landmen
lanterns	8	3	830	3	lanterns
lateens	7	42	1055	3	la_teens
laten	5	43	2834	3	la_t_en
latten	6	50	1820	3	la_tten
lenten	6	3	1288	3	lent_en
manatee	9	3	1766	3	manatee_
manatees	10	3	1042	3	manatees
manteau	9	3	786	3	manteau
mantel	8	43	1797	3	mant_el
mantelet	10	6	1382	3	mantelet
mantels	9	45	1504	3	mantels
mantes	8	44	3078	3	mant_es
mantle	8	44	2092	3	mantle_
mantled	10	41	1339	3	mantled
mantles	9	48	2070	3	mantles
mantlet	9	36	2099	3	mantlet
marten	8	45	1826	3	mart_en
mentee	8	41	2129	3	mentee_
mentees	9	32	1450	3	mentees
nankeens	12	4	324	3	nankeens
nineteen	8	4	415	3	nineteen
oaten	5	52	2240	3	oa_t_en
pangen	9	41	1591	3	pan_gen
pangene	10	27	1196	3	pangene
panted	9	50	2482	3	pant_ed
pantheon	13	4	631	3	pantheon
panther	12	6	1144	3	panther
pantie	8	43	2647	3	pantie_
panties	9	42	3093	3	panties
pastern	9	44	1506	3	pastern
paten	7	48	2734	3	pa_t_en
pattee	8	43	2338	3	pattee_
patten	8	44	1819	3	pa_tten
pattern	9	37	1205	3	pattern
pentene	9	3	1379	3	pentene
posteen	9	35	1262	3	posteen
poteen	8	35	1426	3	_poteen
potteen	9	31	967	3	potteen
preteen	9	3	987	3	preteen
ranee	5	54	3810	3	ran_ee_
ranees	6	46	2396	3	ran_ees
ranted	7	43	2470	3	rant_ed
ranter	6	38	2682	3	rant_er
ranters	7	33	2364	3	ranters
ratteens	8	25	605	3	ratteens
ratten	6	42	1738	3	ra_tten
rontgen	8	3	517	3	rontgen
saltern	7	40	1065	3	saltern
sandmen	10	3	941	3	sandmen
santera	7	3	1130	3	santera
santero	7	3	1113	3	santero
sateens	7	37	1075	3	sa_teens
sauteed	8	34	961	3	sauteed
scanted	10	41	1439	3	scant_ed
scanter	9	42	1518	3	scant_er
scantest	10	17	1018	3	scantest
scantier	10	30	998	3	scantier
scanties	10	32	1542	3	scanties
sixteen	14	3	411	3	sixteen
subteen	9	3	852	3	subteen
tauten	6	43	1189	3	taut_en
teen	4	59	3820	3	___teen
umpteen	11	4	384	3	umpteen
unseen	6	20	1262	3	_unseen
vanmen	11	3	840	3	van_men
wanted	10	43	1972	3	want_ed
wanter	9	44	2305	3	want_er
wanters	10	44	2009	3	wanters
wanton	9	44	1381	3	want_on
xanthan	17	3	601	3	xanthan
xanthein	18	4	501	3	xanthein
xanthene	18	5	555	3	xanthene
xanthin	17	4	704	3	xanthin

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	134027	0.420	425454.8
2	DLD Change Limit	134027	308	6.956	19267.8
3	Display Results	308	308	0.106	2905.7
	(SQL Overall)	178691	308	7.482	23882.8