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

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

270 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
solos	5	48	3079	(None)
bolos	7	55	3137	1	bolos
kolos	9	49	2121	1	kolos
nolos	5	44	2335	1	nolos
polos	7	61	2991	1	polos
silos	5	60	2943	1	silos
soles	5	55	4792	1	soles
solo	4	55	3894	1	solo_
solon	5	50	2613	1	solon
solons	6	51	2002	1	solons
sols	4	54	4816	1	sol_s
solus	5	47	2698	1	solus
bohos	10	56	1825	2	bohos
bolas	7	47	3376	2	bolas
bolds	8	58	2528	2	bolds
boles	7	54	4860	2	boles
bolls	7	55	3131	2	bolls
bolo	6	55	3595	2	bolo_
bolts	7	62	3211	2	bolts
bolus	7	91	2554	2	bolus
boos	6	79	5503	2	bo_os
boyos	10	54	1828	2	boyos
bozos	16	52	1686	2	bozos
calos	7	44	3190	2	calos
cholos	11	47	1685	2	cholos
cocos	9	56	2469	2	cocos
cohos	10	59	2185	2	cohos
colas	7	54	3677	2	colas
colds	8	57	2697	2	colds
coles	7	60	5506	2	coles
colog	8	66	1993	2	colog
cologs	9	65	1735	2	cologs
colon	7	86	3019	2	colon
colons	8	60	2868	2	colons
color	7	61	2374	2	color
colors	8	66	2237	2	colors
cols	6	65	5308	2	col_s
colts	7	66	3329	2	colts
cools	7	56	3263	2	cools
coos	6	74	5649	2	co_os
dodos	7	58	1939	2	dodos
dojos	13	51	1179	2	dojos
doles	6	78	4375	2	doles
dolls	6	61	2692	2	dolls
dolor	6	76	1796	2	dolor
dolors	7	51	1531	2	dolors
dols	5	69	4305	2	dol_s
dolts	6	56	2631	2	dolts
filos	8	61	2538	2	filos
folds	9	52	2169	2	folds
folios	9	39	1546	2	folios
folks	12	60	1712	2	folks
fools	8	68	2420	2	fools
gobos	8	62	1938	2	gobos
gogos	7	75	1652	2	gogos
golds	7	54	2131	2	golds
golfs	9	56	1610	2	golfs
golosh	10	3	646	2	golosh
goos	5	76	4491	2	go_os
halos	8	52	3025	2	halos
helos	8	49	2806	2	helos
hobos	10	63	2135	2	hobos
holds	9	46	2324	2	holds
holes	8	47	4865	2	holes
holks	12	47	2056	2	holks
hollos	9	53	2063	2	hollos
holms	10	51	1780	2	holms
hols	7	69	4629	2	hol_s
holts	8	56	2791	2	holts
homos	10	59	2179	2	homos
isolog	7	3	740	2	isolog
isologs	8	3	743	2	isologs
joles	12	52	3083	2	joles
jolts	12	50	1888	2	jolts
kilos	9	50	2148	2	kilos
kobos	11	56	1689	2	kobos
kolas	9	48	2223	2	kolas
kolo	8	70	2623	2	kolo_
kotos	9	57	1770	2	kotos
lilos	5	58	2187	2	lilos
lobos	7	59	2184	2	lobos
locos	7	58	2260	2	locos
logos	6	72	2533	2	logos
lolls	5	121	2173	2	lolls
loos	4	90	5112	2	lo_os
lotos	5	47	2463	2	lotos
milos	7	54	2801	2	milos
mojos	14	53	1446	2	mojos
molas	7	51	3209	2	molas
molds	8	53	2483	2	molds
moles	7	47	4792	2	moles
molls	7	51	2978	2	molls
mols	6	59	4857	2	mol_s
molts	7	60	3209	2	molts
monos	7	59	3086	2	monos
mools	7	60	2717	2	mools
moos	6	60	5130	2	mo_os
mozos	16	55	1633	2	mozos
nolo	4	62	2931	2	nolo_
nomos	7	59	1974	2	nomos
olds	5	59	2658	2	_olds
oleos	5	54	1968	2	_oleos
oles	4	64	5347	2	_oles
olios	5	45	2085	2	_olios
onos	4	62	2900	2	_onos
ovolos	9	25	720	2	ovolos
poles	7	53	5100	2	poles
polios	8	40	1972	2	polios
polis	7	47	3116	2	polis
polls	7	46	2772	2	polls
polo	6	62	3663	2	polo_
pols	6	60	4456	2	pol_s
polys	10	57	1876	2	polys
pomos	9	53	2158	2	pomos
pools	7	44	2770	2	pools
poos	6	59	4911	2	po_os
roles	5	67	4798	2	roles
rolfs	8	48	1712	2	rolfs
rolls	5	53	2623	2	rolls
rotos	5	60	2788	2	rotos
sagos	6	61	2387	2	sagos
sales	5	60	5559	2	sales
salol	5	52	2214	2	salol
salols	6	40	1787	2	salols
salon	5	52	2855	2	salon
salons	6	38	2369	2	salons
salps	7	44	2324	2	salps
sals	4	68	5167	2	sal_s
salts	5	54	3188	2	salts
salvos	9	46	1338	2	salvos
saros	5	52	3806	2	saros
scolds	9	50	1123	2	scolds
segos	6	49	1948	2	segos
selfs	8	52	2024	2	selfs
sells	5	51	3443	2	sells
sels	4	63	4598	2	sel_s
sholom	11	9	1011	2	sholom
sholoms	12	7	803	2	sholoms
shools	9	49	1901	2	shools
shoos	8	42	2636	2	shoos
siglos	7	3	1147	2	siglos
silds	6	55	2053	2	silds
silks	9	46	2068	2	silks
sills	5	51	3599	2	sills
silo	4	60	3792	2	silo_
silts	5	53	3082	2	silts
slob	6	60	2942	2	s_lob
slobs	7	44	1987	2	slobs
sloe	4	55	3495	2	s_loe
sloes	5	47	2887	2	sloes
slog	5	67	2827	2	s_log
slogs	6	45	2184	2	slogs
sloop	7	61	1891	2	sloop
sloops	8	55	1362	2	sloops
slop	6	65	3387	2	s_lop
slops	7	50	2601	2	slops
slosh	8	45	1448	2	s_losh
slot	4	60	4983	2	s_lot
slots	5	48	3053	2	slots
slow	7	77	2949	2	s_low
slows	8	53	2346	2	slows
smolts	8	44	1188	2	smolts
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
socks	11	49	2608	2	socks
socles	8	4	1845	2	socles
sodas	6	41	2354	2	sodas
sodom	8	8	1491	2	sodom
sodoms	9	8	967	2	sodoms
sods	5	49	4022	2	so_ds
sofas	8	53	2071	2	sofas
softs	8	50	1923	2	softs
soils	5	53	2798	2	soils
sojas	12	47	1639	2	sojas
sokes	9	50	3142	2	sokes
sokol	9	46	1229	2	sokol
sokols	10	39	909	2	sokols
sol	3	72	5662	2	sol__
sola	4	55	4186	2	sol_a
solan	5	53	2815	2	solan
solanos	7	44	1285	2	solanos
solans	6	41	2249	2	solans
solar	5	59	2734	2	solar
sold	5	48	3741	2	sol_d
soldi	6	57	1720	2	soldi
soldo	6	71	1656	2	soldo
sole	4	60	5367	2	sol_e
soled	6	58	3517	2	soled
solei	5	56	2434	2	solei
soleus	6	46	1561	2	soleus
soli	4	66	3701	2	sol_i
solid	6	50	2508	2	solid
solids	7	41	1640	2	solids
solion	6	6	1638	2	solion
solions	7	5	1375	2	solions
soloed	7	45	1574	2	soloed
soloist	7	9	1589	2	soloist
solum	7	47	1761	2	solum
solums	8	52	1133	2	solums
solve	8	56	1894	2	solve
solves	9	50	1822	2	solves
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
sons	4	60	4955	2	so_ns
sook	8	49	3339	2	so_ok
sooks	9	44	2545	2	sooks
soon	4	62	4050	2	so_on
soot	4	57	6106	2	so_ot
soots	5	55	3621	2	soots
sophs	10	49	1602	2	sophs
sopor	7	40	1649	2	sopor
sopors	8	52	1520	2	sopors
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
sores	5	54	5428	2	sores
sorgos	7	45	1466	2	sorgos
sorns	5	50	2842	2	sorns
sorts	5	45	3666	2	sorts
sorus	5	45	2758	2	sorus
sos	3	77	6160	2	s__os
soths	8	62	1863	2	soths
sotol	5	49	1765	2	sotol
sotols	6	37	1447	2	sotols
sots	4	55	5245	2	so_ts
souks	9	48	2052	2	souks
souls	5	51	2736	2	souls
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
splosh	11	8	654	2	splosh
spools	8	51	1591	2	spools
stoles	6	39	2767	2	stoles
stolon	6	41	1207	2	stolon
stolons	7	34	1024	2	stolons
stools	6	51	1702	2	stools
sulks	9	48	1846	2	sulks
sulus	5	48	2188	2	sulus
sumos	7	57	2009	2	sumos
sylis	8	43	1602	2	sylis
telos	5	54	2452	2	telos
tholos	9	42	1300	2	tholos
tolas	5	45	3277	2	tolas
toles	5	51	4713	2	toles
tolls	5	47	2843	2	tolls
tolus	5	50	2448	2	tolus
tools	5	53	2524	2	tools
topos	7	57	2639	2	topos
toros	5	43	3619	2	toros
toyos	8	75	1914	2	toyos
voles	8	62	3404	2	voles
volost	9	4	1264	2	volost
volts	8	54	2129	2	volts
wolds	9	54	2018	2	wolds
wolfs	11	62	1416	2	wolfs
wools	8	44	2146	2	wools
woos	7	62	3880	2	wo_os
yolks	12	54	1277	2	yolks
zoos	13	58	2880	2	zo_os

Search took 2 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.310	576422.6
2	DLD Change Limit	53800	270	1.440	37361.1
3	Display Results	270	270	0.076	3552.6
	(SQL Overall)	178691	270	1.826	97859.3