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

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

333 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
sails	5	57	3810	(None)
ails	4	56	5471	1	_ails
bails	7	59	3352	1	bails
fails	8	56	3148	1	fails
hails	8	52	3164	1	hails
jails	12	54	2294	1	jails
kails	9	55	2521	1	kails
mails	7	60	3778	1	mails
nails	5	57	3040	1	nails
pails	7	58	3306	1	pails
rails	5	59	3740	1	rails
saids	6	53	2885	1	saids
sail	4	54	4716	1	sail_
sains	5	56	3997	1	sains
sals	4	68	5167	1	sa_ls
sauls	5	51	2812	1	sauls
sials	5	42	2724	1	sials
snails	6	48	1665	1	snails
soils	5	53	2798	1	soils
spails	8	48	1782	1	spails
swails	9	49	1312	1	swails
tails	5	56	3419	1	tails
vails	8	58	2593	1	vails
wails	8	66	3148	1	wails
aals	4	99	4114	2	_aals
aids	5	78	4636	2	_aids
ail	3	71	7104	2	_ail_
aims	6	77	3818	2	_aims
ains	4	61	5888	2	_ains
airs	4	64	4742	2	_airs
ais	3	90	8357	2	_ai_s
aits	4	63	5553	2	_aits
alls	4	67	4092	2	_alls
als	3	66	6302	2	_a_ls
anils	5	63	2672	2	anils
arils	5	87	3220	2	arils
assails	7	6	909	2	assails
avails	9	3	969	2	avails
awls	7	59	2609	2	_awls
axils	12	72	1750	2	axils
baals	7	61	2270	2	baals
bail	6	50	4280	2	bail_
baits	7	66	3058	2	baits
balls	7	62	3641	2	balls
bals	6	63	5404	2	ba_ls
basils	8	57	1747	2	basils
bawls	10	57	1932	2	bawls
boils	7	54	2719	2	boils
brails	8	46	2129	2	brails
caids	8	52	2642	2	caids
cains	7	53	3430	2	cains
calls	7	56	3473	2	calls
carls	7	70	3742	2	carls
cauls	7	57	2777	2	cauls
cavils	11	40	1439	2	cavils
ceils	7	50	1940	2	ceils
coils	7	50	3008	2	coils
dahls	9	50	1228	2	dahls
daily	9	59	2233	2	daily
dais	5	70	4070	2	dai_s
dals	5	71	4512	2	da_ls
deils	6	57	2286	2	deils
dials	6	49	2534	2	dials
drails	7	47	1695	2	drails
earls	5	61	2751	2	earls
emails	8	44	1234	2	emails
evils	8	41	1426	2	evils
fail	7	48	4024	2	fail_
fairs	8	58	2544	2	fairs
falls	8	57	2765	2	falls
farls	8	57	3111	2	farls
fils	7	58	3869	2	_fils
flails	9	43	1300	2	flails
foils	8	50	2581	2	foils
frails	9	37	1647	2	frails
gaily	9	50	2097	2	gaily
gains	6	57	2951	2	gains
gaits	6	57	2601	2	gaits
galls	6	47	2932	2	galls
gals	5	79	4650	2	ga_ls
gaols	6	67	1757	2	gaols
grails	7	75	1878	2	grails
haiks	12	51	2093	2	haiks
hail	7	48	3906	2	hail_
hairs	8	62	2517	2	hairs
halls	8	56	3378	2	halls
harls	8	56	3450	2	harls
hauls	8	61	2373	2	hauls
heils	8	52	2219	2	heils
jail	11	55	2909	2	jail_
jarls	12	61	2096	2	jarls
kaifs	12	57	1564	2	kaifs
kail	8	51	3149	2	kail_
kains	9	61	2564	2	kains
laics	7	64	1925	2	laics
lairs	5	54	2587	2	lairs
lalls	5	53	2413	2	lalls
maids	8	63	2714	2	maids
mail	6	55	4345	2	mail_
maile	7	52	3222	2	maile
mailes	8	43	2911	2	mailes
maill	7	44	2079	2	maill
maills	8	42	1528	2	maills
maims	9	63	2179	2	maims
mains	7	56	3511	2	mains
mairs	7	62	2830	2	mairs
malls	7	62	3343	2	malls
marls	7	55	3516	2	marls
mauls	7	65	2495	2	mauls
mils	6	60	4533	2	_mils
moils	7	61	2575	2	moils
naifs	8	76	1742	2	naifs
nail	4	58	3865	2	nail_
nils	4	61	3245	2	_nils
noils	5	50	2433	2	noils
oils	4	63	3797	2	_oils
paiks	11	47	1985	2	paiks
pail	6	61	4183	2	pail_
pains	7	51	3828	2	pains
pairs	7	53	2583	2	pairs
palls	7	43	3256	2	palls
pals	6	69	5135	2	pa_ls
pawls	10	56	1766	2	pawls
qaids	15	61	1631	2	qaids
quails	15	34	1264	2	quails
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rail	4	61	4776	2	rail_
rains	5	51	4023	2	rains
rais	4	52	5262	2	rai_s
resails	7	46	1674	2	resails
rials	5	50	2667	2	rials
roils	5	48	2679	2	roils
sabals	8	46	1886	2	sabals
sabes	7	64	3746	2	sabes
sabins	8	55	2198	2	sabins
sabirs	8	54	1463	2	sabirs
sable	7	47	3216	2	sable
sables	8	50	2669	2	sables
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
sadly	9	45	1912	2	sadly
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
sailed	7	43	2776	2	sailed
sailer	6	35	2610	2	sailer
sailers	7	38	2232	2	sailers
sailor	6	31	1375	2	sailor
sailors	7	32	1372	2	sailors
sain	4	55	5129	2	sai_n
saint	5	51	4707	2	saint
saints	6	51	2242	2	saints
saith	8	58	2655	2	saith
sakes	9	55	4075	2	sakes
sakis	9	53	2367	2	sakis
sal	3	64	6288	2	sa_l_
salals	6	51	2008	2	salals
sale	4	49	5970	2	sa_le
sales	5	60	5559	2	sales
salic	7	34	2471	2	salic
sall	4	45	4468	2	sa_ll
sally	8	51	2971	2	sally
salols	6	40	1787	2	salols
salp	6	45	3409	2	sa_lp
salps	7	44	2324	2	salps
salsa	5	67	1892	2	sa_lsa
salt	4	57	5852	2	sa_lt
salts	5	54	3188	2	salts
samiels	9	3	976	2	samiels
samps	9	61	2467	2	samps
sands	6	52	2858	2	sands
sanes	5	56	4907	2	sanes
sanies	6	30	3195	2	sanies
sans	4	51	5336	2	sa_ns
saps	6	53	4637	2	sa_ps
sards	6	47	3618	2	sards
sarins	6	39	3262	2	sarins
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
sasins	6	49	2310	2	sasins
sass	4	50	3562	2	sa_ss
sates	5	49	4932	2	sates
satins	6	49	3048	2	satins
satis	5	56	3368	2	satis
saul	4	58	3652	2	saul_
sault	5	58	3496	2	sault
saults	6	58	1617	2	saults
saves	8	58	3863	2	saves
savins	9	39	2313	2	savins
saws	7	58	3948	2	sa_ws
saxes	12	52	2934	2	saxes
sayids	10	43	1097	2	sayids
says	7	59	4210	2	sa_ys
scalls	8	42	1820	2	scalls
seals	5	48	3970	2	seals
seels	5	56	3282	2	seels
seifs	8	50	1933	2	seifs
seis	4	55	4239	2	sei_s
sells	5	51	3443	2	sells
sels	4	63	4598	2	s_els
serails	7	33	1836	2	serails
shauls	9	49	1311	2	shauls
shawls	12	54	1197	2	shawls
shiels	9	54	1892	2	shiels
shies	8	61	3655	2	shies
shill	8	53	2533	2	shill
shills	9	45	1961	2	shills
shily	11	52	2201	2	shily
shims	10	44	2255	2	shims
shins	8	51	3104	2	shins
ships	10	51	2377	2	ships
shits	8	47	3117	2	shits
shivs	11	50	1880	2	shivs
shuls	8	53	1971	2	shuls
sial	4	59	3883	2	sial_
sibs	6	59	3354	2	s_ibs
sics	6	52	3409	2	s_ics
sigils	7	39	1236	2	sigils
sild	5	50	3058	2	s_ild
silds	6	55	2052	2	s_ilds
silk	8	55	2932	2	s_ilk
silks	9	46	2068	2	s_ilks
sill	4	55	4515	2	s_ill
sills	5	51	3599	2	sills
silo	4	60	3791	2	s_ilo
silos	5	60	2943	2	s_ilos
silt	4	65	5819	2	s_ilt
silts	5	53	3082	2	s_ilts
sims	6	57	3717	2	s_ims
sins	4	67	5527	2	s_ins
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
skids	10	46	1533	2	skids
skies	9	50	2683	2	skies
skill	9	43	1672	2	skill
skills	10	43	1392	2	skills
skims	11	45	1719	2	skims
skins	9	47	2346	2	skins
skips	11	56	1660	2	skips
skirls	10	44	982	2	skirls
skis	8	48	2529	2	ski_s
skits	9	47	2186	2	skits
slily	8	58	2003	2	slily
slims	7	54	2365	2	slims
slips	7	60	2372	2	slips
slits	5	61	2885	2	slits
smalls	8	45	1412	2	smalls
smile	7	48	2392	2	smile
smiles	8	45	2229	2	smiles
snail	5	70	2020	2	snail_
snarls	6	40	1687	2	snarls
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snits	5	41	2483	2	snits
soil	4	61	3883	2	soil_
sols	4	54	4816	2	s_ols
souls	5	51	2736	2	souls
spail	7	49	2155	2	spail_
spaits	8	50	1747	2	spaits
spalls	8	42	1734	2	spalls
speils	8	41	1622	2	speils
spics	9	41	2324	2	spics
spiels	8	53	1795	2	spiels
spies	7	60	3762	2	spies
spiks	11	41	1747	2	spiks
spile	7	52	3008	2	spile
spiles	8	42	2791	2	spiles
spill	7	48	2116	2	spill
spills	8	47	1746	2	spills
spilt	7	55	3222	2	spilt
spins	7	53	2798	2	spins
spits	7	44	2955	2	spits
spivs	10	51	1424	2	spivs
spoils	8	46	1453	2	spoils
sris	4	54	3415	2	sri_s
staigs	7	54	1481	2	staigs
stains	6	49	2365	2	stains
stairs	6	54	1633	2	stairs
stalls	6	40	1993	2	stalls
sties	5	51	3298	2	sties
stile	5	49	3157	2	stile
stiles	6	43	2877	2	stiles
still	5	49	2208	2	still
stills	6	41	1857	2	stills
stilt	5	48	3198	2	stilt
stilts	6	79	1531	2	stilts
stirs	5	59	2162	2	stirs
suits	5	50	2805	2	suits
swail	8	62	1716	2	swail_
swains	9	45	1395	2	swains
swigs	9	62	1366	2	swigs
swill	8	34	1737	2	swill
swills	9	42	1336	2	swills
swims	10	55	1414	2	swims
swirls	9	40	1013	2	swirls
swiss	8	67	1290	2	swiss
sylis	8	43	1602	2	sylis
taels	5	68	2207	2	taels
tail	4	54	4365	2	tail_
tains	5	49	3632	2	tains
talls	5	51	3343	2	talls
tils	4	57	3961	2	_tils
toils	5	45	2749	2	toils
trails	6	46	2251	2	trails
vail	7	54	3255	2	vail_
vairs	8	50	1913	2	vairs
vakils	13	3	759	2	vakils
veils	8	49	1880	2	veils
vials	8	58	2238	2	vials
waifs	11	57	1987	2	waifs
wail	7	52	3882	2	wail_
wains	8	69	3087	2	wains
wairs	8	64	2406	2	wairs
waits	8	83	3352	2	waits
walls	8	55	2938	2	walls
wauls	8	61	2055	2	wauls
wawls	11	54	1647	2	wawls
yawls	11	46	1360	2	yawls

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	333	1.813	29674.6
3	Display Results	333	333	0.093	3580.6
	(SQL Overall)	178691	333	2.202	81149.4