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

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

278 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
soils	5	53	2798	(None)
boils	7	54	2719	1	boils
coils	7	50	3008	1	coils
foils	8	50	2581	1	foils
moils	7	61	2575	1	moils
noils	5	50	2433	1	noils
oils	4	63	3797	1	_oils
roils	5	48	2679	1	roils
sails	5	57	3810	1	sails
soil	4	61	3883	1	soil_
sols	4	54	4816	1	so_ls
souls	5	51	2736	1	souls
spoils	8	46	1453	1	spoils
toils	5	45	2749	1	toils
ails	4	56	5471	2	_ails
anils	5	63	2672	2	anils
arils	5	87	3220	2	arils
assoils	7	7	666	2	assoils
axils	12	72	1750	2	axils
bails	7	59	3352	2	bails
boil	6	63	3518	2	boil_
bolls	7	55	3131	2	bolls
bowls	10	61	2143	2	bowls
broils	8	41	1417	2	broils
ceils	7	50	1940	2	ceils
coals	7	61	2960	2	coals
coifs	10	57	1870	2	coifs
coil	6	64	3965	2	coil_
coins	7	58	3455	2	coins
coirs	7	52	2105	2	coirs
cols	6	65	5308	2	co_ls
cools	7	56	3263	2	cools
cowls	10	69	2221	2	cowls
deils	6	57	2286	2	deils
diols	6	55	2101	2	diols
doily	9	53	2103	2	doily
doits	6	62	2367	2	doits
dolls	6	61	2692	2	dolls
dols	5	69	4305	2	do_ls
evils	8	41	1426	2	evils
fails	8	56	3148	2	fails
fils	7	58	3869	2	_fils
foals	8	57	2169	2	foals
foil	7	64	3391	2	foil_
foins	8	55	2338	2	foins
fools	8	68	2420	2	fools
fouls	8	72	2143	2	fouls
fowls	11	55	1889	2	fowls
goals	6	55	2129	2	goals
hails	8	52	3164	2	hails
heils	8	52	2219	2	heils
hols	7	69	4629	2	ho_ls
howls	11	62	1922	2	howls
jails	12	54	2294	2	jails
joins	12	58	1841	2	joins
jowls	15	62	1452	2	jowls
kails	9	55	2521	2	kails
koels	9	46	1390	2	koels
kohls	12	43	780	2	kohls
kois	8	51	2940	2	koi_s
loids	6	62	2070	2	loids
loins	5	67	2842	2	loins
lolls	5	121	2173	2	lolls
mails	7	60	3778	2	mails
mils	6	60	4533	2	_mils
moil	6	55	3409	2	moil_
molls	7	51	2978	2	molls
mols	6	59	4857	2	mo_ls
mools	7	60	2717	2	mools
nails	5	57	3040	2	nails
nils	4	61	3245	2	_nils
noels	5	64	1870	2	noels
noil	4	61	3324	2	noil_
noily	8	61	2099	2	noily
noirs	5	56	1546	2	noirs
oil	3	74	5205	2	_oil_
oily	7	79	3225	2	_oily
owls	7	60	2293	2	_owls
pails	7	58	3306	2	pails
poilu	7	23	1600	2	poilu
poilus	8	22	1057	2	poilus
pois	6	65	3904	2	poi_s
polis	7	47	3116	2	polis
polls	7	46	2772	2	polls
pols	6	60	4456	2	po_ls
pools	7	44	2770	2	pools
rails	5	59	3740	2	rails
reoils	6	45	1687	2	reoils
roil	4	62	3529	2	roil_
roily	8	61	2111	2	roily
rolls	5	53	2623	2	rolls
rotls	5	56	2016	2	rotls
saids	6	53	2885	2	saids
sail	4	54	4716	2	sail_
sains	5	56	3997	2	sains
sals	4	68	5167	2	s_als
sauls	5	51	2812	2	sauls
scowls	11	54	959	2	scowls
seals	5	48	3969	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
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
shoals	9	42	1579	2	shoals
shools	9	49	1901	2	shools
shorls	9	45	1620	2	shorls
shuls	8	53	1971	2	shuls
sials	5	42	2724	2	sials
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	1532	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
skoals	10	43	824	2	skoals
slily	8	58	2003	2	slily
slims	7	54	2365	2	slims
slips	7	60	2372	2	slips
slits	5	61	2885	2	slits
sloids	7	37	1269	2	sloids
smile	7	48	2392	2	smile
smiles	8	45	2229	2	smiles
snails	6	48	1665	2	snails
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snits	5	41	2483	2	snits
snools	6	57	1588	2	snools
soaks	9	52	2029	2	soaks
soaps	7	51	2071	2	soaps
soars	5	47	3251	2	soars
sobas	7	44	2425	2	sobas
sobs	6	49	4175	2	so_bs
socas	7	40	2618	2	socas
socials	9	9	963	2	socials
socks	11	49	2608	2	socks
socle	7	4	1957	2	socle
socles	8	4	1845	2	socles
sodas	6	41	2354	2	sodas
sods	5	49	4021	2	so_ds
sofas	8	53	2071	2	sofas
softs	8	50	1923	2	softs
soiled	7	38	2247	2	soiled
sojas	12	47	1639	2	sojas
sokes	9	50	3142	2	sokes
sokols	10	39	909	2	sokols
sol	3	72	5662	2	so_l_
sola	4	55	4186	2	so_la
sold	5	48	3741	2	so_ld
sole	4	60	5367	2	so_le
soles	5	55	4792	2	soles
soli	4	66	3701	2	so_li
solid	6	50	2508	2	solid
solids	7	41	1640	2	solids
solo	4	55	3894	2	so_lo
solos	5	48	3079	2	solos
solus	5	47	2698	2	solus
somas	7	60	3037	2	somas
soms	6	62	3937	2	so_ms
sones	5	54	4414	2	sones
songs	6	77	2555	2	songs
sonics	8	43	1563	2	sonics
sonly	8	57	1805	2	sonly
sons	4	60	4955	2	so_ns
sooks	9	44	2545	2	sooks
soots	5	55	3621	2	soots
sophs	10	49	1602	2	sophs
sops	6	52	4456	2	so_ps
soras	5	50	4101	2	soras
sorbs	7	50	2210	2	sorbs
sords	6	45	2780	2	sords
sorels	6	39	2116	2	sorels
sores	5	54	5428	2	sores
sorns	5	50	2842	2	sorns
sorts	5	45	3666	2	sorts
sorus	5	45	2758	2	sorus
sos	3	77	6160	2	so__s
soths	8	62	1863	2	soths
sotols	6	37	1447	2	sotols
sots	4	55	5245	2	so_ts
souks	9	48	2052	2	souks
soul	4	64	3571	2	soul_
soups	7	53	2294	2	soups
sours	5	52	3050	2	sours
sous	4	69	4721	2	so_us
sows	7	53	4249	2	so_ws
soyas	8	45	2091	2	soyas
soys	7	52	3393	2	so_ys
sozins	15	5	1079	2	sozins
spails	8	48	1782	2	spails
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
spoil	7	58	1865	2	spoil_
spoilt	8	50	1659	2	spoilt
spools	8	51	1591	2	spools
sris	4	54	3415	2	sri_s
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
stoics	8	3	1111	2	stoics
stools	6	51	1702	2	stools
suits	5	50	2805	2	suits
swails	9	49	1312	2	swails
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
tails	5	56	3419	2	tails
tils	4	57	3961	2	_tils
toil	4	65	3628	2	toil_
toile	5	46	2649	2	toile
toiles	6	39	2351	2	toiles
toits	5	53	2747	2	toits
tolls	5	47	2843	2	tolls
tools	5	53	2524	2	tools
vails	8	58	2593	2	vails
veils	8	49	1880	2	veils
viols	8	61	1810	2	viols
voids	9	54	1467	2	voids
voila	8	48	1394	2	voila
voile	8	47	1972	2	voile
voiles	9	46	1644	2	voiles
wails	8	66	3148	2	wails
wools	8	44	2146	2	wools
yowls	11	57	1543	2	yowls
zorils	15	38	1088	2	zorils

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	278	1.720	31279.1
3	Display Results	278	278	0.076	3657.9
	(SQL Overall)	178691	278	2.092	85416.3