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

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

345 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
cains	7	53	3430	(None)
ains	4	61	5888	1	_ains
cabins	10	44	1892	1	cabins
caids	8	52	2642	1	caids
cain	6	56	4391	1	cain_
cairns	8	53	1330	1	cairns
cans	6	50	5085	1	ca_ns
carns	7	59	3756	1	carns
chains	11	48	1970	1	chains
chins	10	56	3146	1	chins
coins	7	58	3455	1	coins
gains	6	57	2951	1	gains
kains	9	61	2564	1	kains
mains	7	56	3511	1	mains
pains	7	51	3828	1	pains
rains	5	51	4023	1	rains
sains	5	56	3997	1	sains
tains	5	49	3632	1	tains
wains	8	69	3087	1	wains
acids	8	71	2100	2	acids
acing	8	74	2915	2	acing
acini	7	57	1898	2	acini
acinus	8	3	1125	2	acinus
actins	8	63	2110	2	actins
aids	5	78	4636	2	_aids
ails	4	56	5471	2	_ails
aims	6	77	3818	2	_aims
ain	3	75	7909	2	_ain_
airns	5	55	2103	2	_airns
airs	4	64	4742	2	_airs
ais	3	90	8357	2	_ai_s
aits	4	63	5553	2	_aits
amins	7	55	3432	2	amins
anis	4	57	4646	2	_anis
awns	7	53	2443	2	_awns
ayins	8	53	2161	2	ayins
bails	7	59	3352	2	bails
bairns	8	67	1087	2	bairns
baits	7	66	3058	2	baits
banns	7	53	2123	2	banns
bans	6	65	5514	2	ba_ns
barns	7	63	3514	2	barns
basins	8	57	2276	2	basins
bins	6	65	4825	2	_bins
blains	8	45	1637	2	blains
brains	8	51	2547	2	brains
brins	7	55	3397	2	brins
cabin	9	48	2094	2	cabin_
cabs	8	67	3942	2	ca_bs
cacas	9	56	2798	2	cacas
cades	8	54	4073	2	cades
cadis	8	44	2850	2	cadis
cads	7	61	4452	2	ca_ds
cafes	10	64	2692	2	cafes
caffs	13	54	1737	2	caffs
cages	8	59	3601	2	cages
caging	10	53	2102	2	caging
caid	7	78	3753	2	cai_d
caimans	11	38	1178	2	caimans
caird	8	57	1723	2	caird
cairds	9	64	1151	2	cairds
cairn	7	57	1751	2	cairn
cairny	11	55	782	2	cairny
cakes	11	60	3767	2	cakes
caking	13	46	2467	2	caking
calfs	10	49	1938	2	calfs
califs	11	49	1589	2	califs
calkins	13	38	1487	2	calkins
calks	11	54	2160	2	calks
calls	7	56	3473	2	calls
calms	9	52	2235	2	calms
calos	7	44	3190	2	calos
camas	9	63	3352	2	camas
cames	9	70	4731	2	cames
camions	11	39	1613	2	camions
camos	9	59	2761	2	camos
camps	11	63	3026	2	camps
cams	8	70	4728	2	ca_ms
can	5	77	6014	2	ca_n_
cane	6	66	5312	2	ca_ne
canes	7	53	5037	2	canes
canid	8	55	2634	2	canid
canids	9	51	1813	2	canids
canine	8	38	2670	2	canine
canines	9	37	2403	2	canines
caning	9	41	2862	2	caning
canna	7	59	1933	2	canna
cannas	8	45	1840	2	cannas
canny	10	58	1769	2	canny
canons	8	55	2206	2	canons
canso	7	50	1940	2	ca_nso
canst	7	49	3221	2	ca_nst
cant	6	63	6203	2	ca_nt
cants	7	70	3694	2	cants
capes	9	54	4192	2	capes
caphs	12	45	1537	2	caphs
capias	10	3	1835	2	capias
caplins	11	35	1599	2	caplins
capons	10	41	1950	2	capons
capos	9	48	2607	2	capos
caps	8	71	4789	2	ca_ps
carbs	9	60	3146	2	carbs
cards	8	51	3793	2	cards
cares	7	73	6918	2	cares
caries	8	51	4762	2	caries
carina	8	43	2532	2	carina
carinas	9	36	2240	2	carinas
caring	9	51	3799	2	caring
carks	11	55	3421	2	carks
carlins	9	39	2191	2	carlins
carls	7	70	3742	2	carls
carn	6	62	4543	2	carn_
carny	10	58	2292	2	carny
carps	9	69	3225	2	carps
carrs	7	57	3085	2	carrs
cars	6	73	6476	2	ca_rs
carts	7	89	4629	2	carts
casas	7	53	2784	2	casas
caseins	9	31	1505	2	caseins
cases	7	50	4838	2	cases
casing	9	48	2910	2	casing
casings	10	40	1351	2	casings
casini	8	46	1586	2	casini
casino	8	43	1755	2	casino
casinos	9	35	1283	2	casinos
casks	11	57	2006	2	casks
casts	7	72	3779	2	casts
casus	7	64	1925	2	casus
cates	7	59	5189	2	cates
cations	9	45	2414	2	cations
catkins	13	30	1256	2	catkins
catlins	9	38	1884	2	catlins
cats	6	63	5634	2	ca_ts
cauls	7	57	2777	2	cauls
caves	10	56	3970	2	caves
cavies	11	45	2500	2	cavies
cavils	11	40	1439	2	cavils
caving	12	48	2261	2	caving
cavings	13	47	1254	2	cavings
cawing	12	43	2261	2	cawing
caws	9	60	3611	2	ca_ws
cays	9	54	3767	2	ca_ys
ceils	7	50	1940	2	ceils
chain	10	57	2367	2	chain_
chaine	11	51	1922	2	chaine
chaines	12	45	1873	2	chaines
chairs	11	49	1618	2	chairs
chais	10	75	3031	2	chai_s
chias	10	46	2552	2	chias
chics	12	39	2094	2	chics
chin	9	69	3474	2	chin_
china	10	50	2248	2	china
chinas	11	51	1940	2	chinas
chine	10	52	3172	2	chine
chines	11	50	2917	2	chines
chink	14	53	2159	2	chink
chinks	15	58	1757	2	chinks
chino	10	58	2331	2	chino
chinos	11	50	1869	2	chinos
chints	11	51	1783	2	chints
chips	12	57	2125	2	chips
chis	9	59	3331	2	chi_s
chits	10	54	2457	2	chits
cigs	7	56	2510	2	c_igs
cine	6	62	4294	2	c_ine
cines	7	52	3968	2	c_ines
cions	7	52	2285	2	cions
cis	5	77	4803	2	c_i_s
claims	10	52	1157	2	claims
clans	7	50	3101	2	clans
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
clons	7	52	2813	2	clons
cocains	11	13	1392	2	cocains
coifs	10	57	1870	2	coifs
coigns	9	44	1006	2	coigns
coils	7	50	3008	2	coils
coin	6	66	4535	2	coin_
coirs	7	52	2105	2	coirs
colins	8	52	2904	2	colins
conins	8	43	2723	2	conins
conns	7	50	2423	2	conns
cons	6	60	5769	2	c_ons
coons	7	67	3728	2	coons
corns	7	60	3476	2	corns
covins	11	46	1806	2	covins
cribs	9	45	1675	2	cribs
cries	7	54	3840	2	cries
cris	6	62	3343	2	cri_s
crits	7	55	2757	2	crits
cuifs	10	48	1469	2	cuifs
cuing	8	54	2019	2	cuing
cumins	10	33	1493	2	cumins
curns	7	49	2428	2	curns
cutins	8	39	1998	2	cutins
cyanins	12	29	1001	2	cyanins
cyans	10	57	1481	2	cyans
dais	5	70	4070	2	dai_s
damns	8	49	1692	2	damns
dans	5	67	4815	2	da_ns
darns	6	69	2789	2	darns
dawns	9	59	1659	2	dawns
dins	5	66	5204	2	_dins
djins	13	6	845	2	djins
drains	7	37	1940	2	drains
earns	5	59	2756	2	earns
elains	6	49	1985	2	elains
fagins	10	5	1386	2	fagins
fails	8	56	3148	2	fails
fain	7	58	4056	2	fain_
faint	8	58	3706	2	faint
faints	9	48	1878	2	faints
fairs	8	58	2544	2	fairs
fans	7	62	4737	2	fa_ns
fauns	8	45	1675	2	fauns
fawns	11	59	1426	2	fawns
fins	7	58	4909	2	_fins
foins	8	55	2338	2	foins
gain	5	60	4216	2	gain_
gainst	7	49	1470	2	gainst
gaits	6	57	2601	2	gaits
gamins	9	44	2005	2	gamins
gins	5	55	4395	2	_gins
grains	7	42	2309	2	grains
grins	6	54	2722	2	grins
haiks	12	51	2093	2	haiks
hails	8	52	3164	2	hails
haint	8	54	3632	2	haint
haints	9	44	1758	2	haints
hairs	8	62	2517	2	hairs
hins	7	64	4799	2	_hins
ins	3	59	4560	2	__ins
jails	12	54	2294	2	jails
jins	11	56	3501	2	_jins
joins	12	58	1841	2	joins
kaifs	12	57	1564	2	kaifs
kails	9	55	2521	2	kails
kain	8	53	3429	2	kain_
kaons	9	50	1485	2	kaons
karns	9	66	2414	2	karns
kins	8	57	4791	2	_kins
laics	7	64	1925	2	laics
lain	4	61	4628	2	lain_
lairs	5	54	2587	2	lairs
lapins	8	45	2068	2	lapins
lawns	8	52	1542	2	lawns
layins	9	38	1765	2	layins
lins	4	70	5905	2	_lins
loins	5	67	2842	2	loins
maids	8	63	2714	2	maids
mails	7	60	3778	2	mails
maims	9	63	2179	2	maims
main	6	53	4552	2	main_
mairs	7	62	2830	2	mairs
mans	6	63	5455	2	ma_ns
matins	8	45	2778	2	matins
mavins	11	51	1918	2	mavins
naans	5	58	1525	2	naans
naifs	8	76	1742	2	naifs
nails	5	57	3040	2	nails
nans	4	61	3940	2	na_ns
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pain	6	56	4724	2	pain_
paint	7	54	4369	2	paint
paints	8	59	2183	2	paints
pairs	7	53	2583	2	pairs
pans	6	58	5573	2	pa_ns
patins	8	75	2878	2	patins
pavins	11	49	1966	2	pavins
pawns	10	88	1813	2	pawns
peins	7	61	2806	2	peins
pians	7	51	2696	2	pians
pins	6	55	5845	2	_pins
plains	8	50	1959	2	plains
pyins	10	58	1586	2	pyins
qaids	15	61	1631	2	qaids
quins	14	48	1985	2	quins
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rain	4	62	5173	2	rain_
rainy	8	59	2108	2	rainy
rais	4	52	5262	2	rai_s
ranis	5	52	3583	2	ranis
ravins	9	46	2256	2	ravins
rawins	9	56	1762	2	rawins
reins	5	62	3456	2	reins
rins	4	61	5319	2	_rins
ruins	5	58	2203	2	ruins
sabins	8	55	2198	2	sabins
saids	6	53	2885	2	saids
sails	5	57	3810	2	sails
sain	4	55	5129	2	sain_
saint	5	51	4707	2	saint
saints	6	51	2242	2	saints
sans	4	51	5336	2	sa_ns
sarins	6	39	3262	2	sarins
sasins	6	49	2310	2	sasins
satins	6	49	3048	2	satins
savins	9	39	2313	2	savins
scans	7	46	2510	2	sca_ns
shins	8	51	3104	2	shins
sins	4	67	5527	2	_sins
skins	9	47	2346	2	skins
spins	7	53	2798	2	spins
stains	6	49	2365	2	stains
swains	9	45	1395	2	swains
tails	5	56	3419	2	tails
tain	4	55	4807	2	tain_
taint	5	55	4228	2	taint
taints	6	45	2053	2	taints
takins	10	51	1740	2	takins
tans	4	61	5482	2	ta_ns
tarns	5	64	3395	2	tarns
thins	8	58	2633	2	thins
tins	4	52	5130	2	_tins
trains	6	47	2534	2	trains
twains	9	58	1118	2	twains
twins	8	51	1898	2	twins
vails	8	58	2593	2	vails
vain	7	52	3300	2	vain_
vairs	8	50	1913	2	vairs
vans	7	62	3673	2	va_ns
veins	8	46	2049	2	veins
waifs	11	57	1987	2	waifs
wails	8	66	3148	2	wails
wain	7	58	4020	2	wain_
wairs	8	64	2406	2	wairs
waits	8	83	3352	2	waits
wans	7	64	5227	2	wa_ns
warns	8	72	3100	2	warns
whins	11	49	2233	2	whins
wins	7	59	4917	2	_wins
yarns	8	56	2179	2	yarns
yawns	11	42	1327	2	yawns
yins	7	53	3512	2	_yins
zayins	18	40	971	2	zayins
zeins	14	47	1539	2	zeins
zins	13	57	3500	2	_zins

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	53800	0.313	570897.8
2	DLD Change Limit	53800	345	1.780	30224.7
3	Display Results	345	345	0.093	3709.7
	(SQL Overall)	178691	345	2.186	81743.4