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

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

325 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
caftans	12	17	944	(None)
caftan	11	17	1012	1	caftan_
captans	11	16	1205	1	captans
kaftans	14	18	535	1	kaftans
caftaned	14	4	509	2	caftaned
caimans	11	38	1178	2	caimans
callans	9	45	1847	2	callans
cancans	11	3	1187	2	cancans
cantals	9	39	1957	2	cantals
cantons	9	52	2120	2	cantons
capstans	12	5	724	2	capstans
captains	12	18	1057	2	captains
captan	10	16	1334	2	captan_
cartons	9	41	2247	2	cartons
caymans	14	34	951	2	caymans
cotans	8	13	1792	2	c_otans
kaftan	13	18	583	2	kaftan_
partans	9	44	1828	2	partans
ratans	6	38	1937	2	ra_tans
rattans	7	34	1195	2	rattans
tartans	7	26	1582	2	tartans
acetals	9	34	1135	3	acetals
acetins	9	3	1317	3	acetins
actins	8	63	2110	3	_actins
afars	8	57	1651	3	_af_ars
afghans	14	4	357	3	_afghans
afters	9	47	1707	3	_afters
alans	5	56	3617	3	_a_lans
altars	6	45	1815	3	_altars
antas	5	54	3203	3	_anta_s
ataps	7	64	1483	3	_a_taps
atmans	8	44	1396	3	_atmans
attains	7	3	1098	3	_attains
attars	6	45	1531	3	_attars
avians	9	37	1157	3	_avians
azans	14	65	1688	3	_a_zans
banians	9	3	1203	3	banians
bantams	11	4	906	3	bantams
banyans	12	3	791	3	banyans
batons	8	55	1942	3	ba_tons
battens	9	53	1326	3	battens
cabals	10	40	2015	3	ca_bals
cabana	10	39	1356	3	ca_bana
cabanas	11	24	1303	3	ca_banas
cabins	10	44	1892	3	ca_bins
cabman	12	38	1251	3	cabman_
cabstand	13	4	441	3	cabstand
cabstands	14	5	373	3	cabstands
cacaos	10	46	1618	3	ca_caos
cacas	9	56	2798	3	ca_ca_s
cactus	10	49	1223	3	cact_us
caesars	9	4	1073	3	caesars
cafes	10	64	2692	3	caf__es
caffeins	16	4	512	3	caffeins
caffs	13	54	1737	3	caf__fs
caiman	10	36	1567	3	caiman_
cains	7	53	3430	3	ca__ins
cairns	8	53	1330	3	ca_irns
calcars	11	3	1265	3	calcars
calkins	13	38	1487	3	calkins
callan	8	36	1960	3	callan_
callant	9	41	2122	3	callant
callants	10	41	1214	3	callants
callas	8	45	2675	3	calla_s
calpacs	13	31	1034	3	calpacs
calpains	12	3	976	3	calpains
caltraps	12	32	725	3	caltraps
camas	9	63	3353	3	ca_ma_s
camass	10	41	1418	3	ca_mass
camions	11	39	1613	3	camions
canals	8	44	2167	3	ca_nals
cancan	10	3	1410	3	cancan_
cannas	8	45	1840	3	canna_s
cannons	9	44	1288	3	cannons
canons	8	55	2206	3	ca_nons
cans	6	50	5085	3	c___ans
cantal	8	41	2203	3	canta_l
cantala	9	41	1467	3	cantala
cantalas	10	40	1352	3	cantalas
cantata	9	38	1181	3	cantata
cantatas	10	34	1009	3	cantatas
canteens	10	3	857	3	canteens
canters	9	48	2773	3	canters
canthus	12	4	871	3	canthus
cantina	9	34	1725	3	cantina
cantinas	10	27	1378	3	cantinas
canting	10	47	2590	3	canting
cantles	9	47	2141	3	cantles
canton	8	57	2299	3	canton_
cantors	9	46	2075	3	cantors
cantos	8	48	2697	3	cant_os
cantraps	12	31	911	3	cantraps
cants	7	70	3694	3	cant__s
cantus	8	51	1776	3	cant_us
canvas	11	38	1333	3	canva_s
canvass	12	37	687	3	canvass
canyons	12	45	1159	3	canyons
capelans	12	3	801	3	capelans
capias	10	3	1835	3	capia_s
capitals	12	20	945	3	capitals
caplins	11	35	1599	3	caplins
capons	10	41	1950	3	ca_pons
capstan	11	3	791	3	capstan_
captain	11	21	1106	3	captain
captions	12	38	1322	3	captions
captors	11	39	1498	3	captors
carates	9	56	3061	3	carates
carats	8	59	2902	3	ca_rats
caravans	13	3	862	3	caravans
carbarns	12	3	856	3	carbarns
carbons	11	54	1894	3	carbons
carcass	11	3	1051	3	carcass
cardons	10	45	1994	3	cardons
careens	9	45	1470	3	careens
carinas	9	36	2242	3	carinas
caritas	9	33	1696	3	carita_s
carlins	9	39	2193	3	carlins
carman	10	39	2076	3	carman_
carns	7	59	3756	3	ca__rns
carotins	10	23	1558	3	carotins
carpals	11	34	1463	3	carpals
cartage	10	3	1259	3	cartage
cartages	11	3	1331	3	cartages
cartels	9	46	1812	3	cartels
carters	9	53	2726	3	carters
cartes	8	62	3947	3	cart_es
carting	10	42	2828	3	carting
carton	8	45	2266	3	carton_
cartoons	10	40	1280	3	cartoons
carts	7	89	4629	3	cart__s
casas	7	53	2784	3	ca_sa_s
casbahs	14	3	646	3	casbahs
caseins	9	31	1505	3	caseins
caserns	9	47	1122	3	caserns
cashaws	15	39	857	3	cashaws
casitas	9	33	1204	3	casita_s
castanet	10	4	1619	3	castanet
castanets	11	4	634	3	castanets
casters	9	47	2990	3	casters
castes	8	56	3186	3	cast_es
casting	10	46	2834	3	casting
castings	11	36	1405	3	castings
castles	9	49	1773	3	castles
castors	9	49	1944	3	castors
casts	7	72	3779	3	cast__s
casuals	9	14	1054	3	casuals
catalo	8	3	1485	3	ca_talo
catalos	9	4	1416	3	ca_talos
catena	8	3	1248	3	ca_tena
catenas	9	3	1311	3	ca_tenas
caterans	10	3	1322	3	caterans
caters	8	53	3650	3	ca_ters
cates	7	59	5189	3	ca_t_es
catface	14	3	676	3	catface
catfaces	15	3	696	3	catfaces
catfall	12	3	739	3	catfall
catfalls	13	4	706	3	catfalls
cations	9	45	2414	3	cations
catjang	17	3	392	3	catjang
catjangs	18	4	322	3	catjangs
catkins	13	30	1256	3	catkins
catlins	9	38	1884	3	catlins
catnap	10	9	838	3	ca_tnap
catnaps	11	9	703	3	catnaps
cats	6	63	5634	3	ca_t__s
cattail	9	3	918	3	cattail
cattails	10	3	855	3	cattails
cattalo	9	3	842	3	cattalo
cattalos	10	3	793	3	cattalos
catties	9	40	2305	3	catties
catting	10	39	2264	3	catting
causals	9	14	1118	3	causals
cautions	10	33	1318	3	cautions
caveats	12	3	980	3	caveats
caverns	12	45	1025	3	caverns
caviars	12	3	862	3	caviars
cayman	13	36	1322	3	cayman_
centals	9	43	1705	3	centals
centas	8	50	2070	3	centa_s
cestas	8	50	1854	3	cesta_s
cetane	8	3	1528	3	c_etane
cetanes	9	3	1513	3	c_etanes
chastens	13	42	918	3	chastens
chazans	21	26	812	3	chazans
chazzans	21	23	450	3	chazzans
chetahs	15	34	707	3	chetahs
chitins	12	27	1379	3	chitins
chitons	12	26	1191	3	chitons
clachans	15	4	641	3	clachans
clans	7	50	3101	3	c__lans
claypans	15	4	387	3	claypans
cleans	8	58	1705	3	c_leans
coffins	15	31	1019	3	coffins
contains	10	3	1653	3	contains
corbans	11	3	1317	3	corbans
cortins	9	24	2133	3	cortins
costars	9	42	1801	3	costars
cotan	7	15	2178	3	c_otan_
cottars	9	44	1224	3	cottars
cottas	8	46	1557	3	cotta_s
cottons	9	3	1219	3	cottons
crafters	13	41	995	3	crafters
crafting	14	37	1017	3	crafting
crafts	11	53	1274	3	craft__s
cratons	9	43	1603	3	cratons
cretins	9	32	1642	3	cretins
crotons	9	37	1437	3	crotons
currans	9	3	1061	3	currans
curtains	10	25	970	3	curtains
curtals	9	31	1162	3	curtals
cutins	8	39	1998	3	c_utins
cyans	10	57	1481	3	c__yans
cytons	11	17	1018	3	c_ytons
daltons	8	3	1040	3	daltons
damans	9	47	1598	3	da_mans
fans	7	62	4737	3	__f_ans
fastens	10	55	1175	3	fastens
fattens	10	51	1171	3	fattens
flans	8	53	2797	3	__flans
habitans	13	4	662	3	habitans
haftara	13	13	609	3	haftara
haftaras	14	13	607	3	haftaras
hafters	13	46	1433	3	hafters
hafting	14	40	1417	3	hafting
hafts	11	62	1946	3	haft__s
haptens	12	45	1134	3	haptens
hartals	10	3	1302	3	hartals
hastens	10	62	1481	3	hastens
hazans	18	34	1165	3	ha_zans
hazzans	18	21	578	3	hazzans
japans	15	3	982	3	ja_pans
jawans	16	5	784	3	ja_wans
kalians	11	3	1018	3	kalians
kanbans	13	3	772	3	kanbans
kantars	11	3	1003	3	kantars
katas	9	59	2210	3	ka_ta_s
lactams	11	3	695	3	lactams
lagans	7	57	1778	3	la_gans
lallans	7	41	1354	3	lallans
lantana	7	3	961	3	lantana
lantanas	8	3	826	3	lantanas
latens	6	46	2021	3	la_tens
lattens	7	50	1467	3	lattens
lattins	7	41	1548	3	lattins
lauans	6	51	1353	3	la_uans
mafias	11	39	1357	3	mafia_s
maftirs	12	3	604	3	maftirs
magians	10	3	1075	3	magians
mannans	9	36	1152	3	mannans
mantas	8	57	2536	3	manta_s
martens	9	37	1495	3	martens
martians	10	31	1161	3	martians
martins	9	33	2207	3	martins
matins	8	45	2778	3	ma_tins
mattins	9	33	1614	3	mattins
naans	5	58	1525	3	na__ans
natant	6	3	1873	3	na_tant
octans	8	14	1114	3	_octans
paeans	8	51	1826	3	pa_eans
paesans	9	33	1269	3	paesans
pagans	9	57	1792	3	pa_gans
paisans	9	36	1475	3	paisans
parians	9	35	1974	3	parians
partan	8	38	2057	3	partan_
partons	9	46	2051	3	partons
pastas	8	54	2287	3	pasta_s
patens	8	48	2086	3	pa_tens
patins	8	75	2878	3	pa_tins
pattens	9	54	1492	3	pattens
pavans	11	57	1559	3	pa_vans
platans	9	34	1312	3	platans
quartans	17	3	629	3	quartans
radians	8	30	1382	3	radians
rafters	10	37	1563	3	rafters
rafting	11	38	1575	3	rafting
rafts	8	78	2063	3	raft__s
raglans	8	24	1013	3	raglans
ragtags	9	3	537	3	ragtags
raitas	6	44	1767	3	raita_s
randans	8	3	1321	3	randans
ratals	6	42	1958	3	ra_tals
ratan	5	37	2266	3	ra_tan_
ratany	9	34	1187	3	ra_tany
rattan	6	36	1360	3	rattan_
rattens	7	42	1340	3	rattens
rattons	7	38	1532	3	rattons
saltant	7	3	1677	3	saltant
saltpans	10	3	481	3	saltpans
sampans	11	24	1100	3	sampans
sarans	6	42	2443	3	sa_rans
satang	7	57	1156	3	sa_tang
satangs	8	47	971	3	sa_tangs
satays	9	44	1168	3	sa_tays
satins	6	49	3048	3	sa_tins
seitans	7	33	1230	3	seitans
sextans	14	34	927	3	sextans
shaitans	11	3	641	3	shaitans
softas	9	44	1040	3	softa_s
softens	10	34	762	3	softens
sultans	7	24	1183	3	sultans
suntans	7	21	1173	3	suntans
tafias	9	31	1196	3	tafia_s
taipans	9	26	955	3	taipans
tampans	11	33	1098	3	tampans
tans	4	61	5483	3	___tans
tarpans	9	25	1353	3	tarpans
tartan	6	42	1752	3	tartan_
tartana	7	30	1019	3	tartana
tartanas	8	25	889	3	tartanas
tartars	7	33	1340	3	tartars
tarzans	16	32	992	3	tarzans
tatars	6	46	1979	3	ta_tars
tautens	7	31	784	3	tautens
titans	6	34	1491	3	_titans
waftage	14	11	532	3	waftage
waftages	15	10	539	3	waftages
wafters	13	41	1281	3	wafters
wafting	14	39	1166	3	wafting
wafts	11	69	2055	3	waft__s
wangans	11	4	950	3	wangans
wantons	10	37	1301	3	wantons
wataps	11	24	868	3	wa_taps
witans	9	34	1293	3	_witans
xanthans	18	4	569	3	xanthans
zaffars	22	32	523	3	zaffars

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.423	422437.4
2	DLD Change Limit	134027	325	6.453	20769.7
3	Display Results	325	325	0.110	2954.5
	(SQL Overall)	178691	325	6.986	25578.4