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

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

376 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
sains	5	56	3997	(None)
ains	4	61	5888	1	_ains
cains	7	53	3430	1	cains
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
sabins	8	55	2198	1	sabins
saids	6	53	2885	1	saids
sails	5	57	3810	1	sails
sain	4	55	5129	1	sain_
saint	5	51	4707	1	saint
saints	6	51	2242	1	saints
sans	4	51	5336	1	sa_ns
sarins	6	39	3262	1	sarins
sasins	6	49	2310	1	sasins
satins	6	49	3048	1	satins
savins	9	39	2313	1	savins
shins	8	51	3104	1	shins
sins	4	67	5527	1	s_ins
skins	9	47	2346	1	skins
spins	7	53	2798	1	spins
stains	6	49	2365	1	stains
swains	9	45	1395	1	swains
tains	5	49	3632	1	tains
wains	8	69	3087	1	wains
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
cabins	10	44	1892	2	cabins
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain_
cairns	8	53	1330	2	cairns
cans	6	50	5085	2	ca_ns
carns	7	59	3756	2	carns
chains	11	48	1970	2	chains
chins	10	56	3146	2	chins
coins	7	58	3455	2	coins
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
fusains	10	3	836	2	fusains
gain	5	60	4216	2	gain_
gainst	7	49	1469	2	gainst
gaits	6	57	2601	2	gaits
gamins	9	44	2004	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
isatins	7	3	1077	2	isatins
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
sabes	7	64	3746	2	sabes
sabin	7	49	2495	2	sabin_
sabine	8	40	2039	2	sabine
sabines	9	43	1848	2	sabines
sabirs	8	54	1463	2	sabirs
sabs	6	66	4374	2	sa_bs
sacks	11	42	2887	2	sacks
sacs	6	57	3907	2	sa_cs
sades	6	52	3989	2	sades
sadis	6	49	3085	2	sadis
safes	8	52	2672	2	safes
sagas	6	60	2588	2	sagas
sages	6	53	3906	2	sages
sagos	6	61	2387	2	sagos
sags	5	59	4840	2	sa_gs
sahibs	11	3	708	2	sahibs
saice	7	54	2405	2	saice
saices	8	42	2180	2	saices
said	5	57	4211	2	sai_d
saiga	6	47	1793	2	saiga
saigas	7	41	1429	2	saigas
sail	4	54	4716	2	sai_l
saimins	9	3	1211	2	saimins
sained	7	54	2424	2	sained
saith	8	58	2655	2	saith
sakes	9	55	4075	2	sakes
sakis	9	53	2367	2	sakis
sales	5	60	5559	2	sales
salina	6	42	2112	2	salina
salinas	7	31	1609	2	salinas
saline	6	51	3270	2	saline
salines	7	40	2941	2	salines
salons	6	38	2369	2	salons
salps	7	44	2324	2	salps
sals	4	68	5167	2	sa_ls
salts	5	54	3188	2	salts
samps	9	61	2467	2	samps
sand	5	53	3847	2	sa_nd
sands	6	52	2858	2	sands
sane	4	59	5434	2	sa_ne
sanes	5	56	4907	2	sanes
sang	5	54	4123	2	sa_ng
sanies	6	30	3195	2	sanies
saning	7	51	2764	2	saning
sank	8	52	3683	2	sa_nk
sapiens	9	3	1017	2	sapiens
saps	6	53	4637	2	sa_ps
sarans	6	42	2443	2	sarans
sards	6	47	3618	2	sards
sarin	5	52	3925	2	sarin_
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
sasin	5	46	2657	2	sasin_
sass	4	50	3562	2	sa_ss
sates	5	49	4932	2	sates
satin	5	59	3522	2	satin_
sating	7	47	3545	2	sating
satiny	9	38	1798	2	satiny
satis	5	56	3368	2	satis
sauls	5	51	2812	2	sauls
sauna	5	41	1755	2	sauna
saunas	6	39	1543	2	saunas
saves	8	58	3863	2	saves
savin	8	46	2508	2	savin_
savine	9	42	2028	2	savine
savines	10	44	1763	2	savines
saving	10	47	2451	2	saving
savings	11	44	1295	2	savings
sawing	10	43	2381	2	sawing
sawn	7	54	2816	2	sawn_
saws	7	58	3948	2	sa_ws
saxes	12	52	2934	2	saxes
sayids	10	43	1097	2	sayids
saying	10	43	2554	2	saying
sayings	11	36	1083	2	sayings
says	7	59	4210	2	sa_ys
scans	7	46	2510	2	scans
scions	8	26	1224	2	scions
seifs	8	50	1933	2	seifs
seine	5	57	3287	2	seine
seines	6	50	2990	2	seines
seis	4	55	4239	2	sei_s
serins	6	40	2967	2	serins
shairns	10	27	678	2	shairns
sharns	9	55	1698	2	sharns
shies	8	61	3655	2	shies
shims	10	44	2255	2	shims
shin	7	56	3431	2	shin_
shine	8	55	3309	2	shine
shines	9	50	2891	2	shines
shiny	11	51	2214	2	shiny
ships	10	51	2377	2	ships
shits	8	47	3117	2	shits
shivs	11	50	1880	2	shivs
shuns	8	50	1814	2	shuns
sials	5	42	2724	2	sials
sibs	6	59	3354	2	s_ibs
sics	6	52	3409	2	s_ics
signs	6	55	1632	2	signs
sims	6	57	3717	2	s_ims
sin	3	62	6589	2	s_in_
sine	4	65	6062	2	s_ine
sines	5	59	5482	2	s_ines
sing	5	75	4417	2	s_ing
sings	6	55	3270	2	s_ings
sinh	7	62	3804	2	s_inh
sinhs	8	67	1960	2	s_inhs
sink	8	66	4014	2	s_ink
sinks	9	55	2918	2	s_inks
sinus	5	55	2385	2	s_inus
sips	6	57	4010	2	s_ips
sirs	4	43	3833	2	s_irs
sis	3	73	6054	2	s_i_s
sits	4	50	5020	2	s_its
skeins	10	39	1190	2	skeins
skids	10	46	1533	2	skids
skies	9	50	2683	2	skies
skims	11	45	1719	2	skims
skin	8	59	2753	2	skin_
skink	8	59	1685	2	skink
skinks	9	45	1165	2	skinks
skint	9	56	2922	2	skint
skips	11	56	1660	2	skips
skis	8	48	2529	2	ski_s
skits	9	47	2186	2	skits
slain	5	49	2357	2	slain_
slims	7	54	2365	2	slims
sling	6	60	2880	2	sling
slings	7	46	1801	2	slings
slink	9	54	2291	2	slink
slinks	10	43	1515	2	slinks
slips	7	60	2372	2	slips
slits	5	61	2885	2	slits
snails	6	48	1665	2	snails
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snits	5	41	2483	2	snits
soils	5	53	2798	2	soils
sons	4	60	4955	2	s_ons
sorns	5	50	2842	2	sorns
sozins	15	5	1079	2	sozins
spails	8	48	1782	2	spails
spaits	8	50	1747	2	spaits
spans	7	45	2873	2	spans
spavins	12	41	932	2	spavins
spawns	11	57	792	2	spawns
spics	9	41	2324	2	spics
spies	7	60	3762	2	spies
spiks	11	41	1747	2	spiks
spin	6	62	3130	2	spin_
spine	7	65	3442	2	spine
spines	8	51	3203	2	spines
spiny	10	49	2130	2	spiny
spits	7	44	2955	2	spits
spivs	10	51	1424	2	spivs
sprains	9	30	1359	2	sprains
sris	4	54	3415	2	sri_s
staigs	7	54	1481	2	staigs
stain	5	57	2794	2	stain_
stairs	6	54	1633	2	stairs
statins	7	37	1977	2	statins
steins	6	48	1834	2	steins
sties	5	51	3298	2	sties
sting	6	53	3024	2	sting
stings	7	62	2018	2	stings
stink	9	51	2250	2	stink
stinks	10	56	1683	2	stinks
stint	5	70	3766	2	stint
stints	6	51	1976	2	stints
stirs	5	59	2162	2	stirs
strains	7	42	1815	2	strains
stuns	5	47	1949	2	stuns
suing	6	50	2636	2	suing
suint	5	56	3818	2	suint
suints	6	46	1778	2	suints
suits	5	50	2805	2	suits
sunns	5	50	1735	2	sunns
suns	4	58	4190	2	s_uns
swails	9	49	1312	2	swails
swain	8	49	1905	2	swain_
swans	8	46	2501	2	swans
swigs	9	62	1366	2	swigs
swims	10	55	1414	2	swims
swine	8	56	2530	2	swine
swing	9	61	2484	2	swing
swings	10	47	1445	2	swings
swink	12	51	1635	2	swink
swinks	13	46	1065	2	swinks
swiss	8	67	1290	2	swiss
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.296	603685.8
2	DLD Change Limit	53800	376	1.656	32487.9
3	Display Results	376	376	0.110	3418.2
	(SQL Overall)	178691	376	2.062	86659.1