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

Here are the results of your fuzzy-string dictionary search for “sysop” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

370 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
sysop	10	3	719	(None)
sysops	11	3	601	1	sysops
hyson	11	3	869	2	hyson
hyssop	14	4	341	2	hyssop
scoop	9	56	1716	2	scoop
scop	8	59	2552	2	s_cop
shop	9	56	2984	2	s_hop
sloop	7	61	1891	2	sloop
slop	6	65	3387	2	s_lop
snoop	7	53	1717	2	snoop
sop	5	75	5786	2	__sop
stoop	7	58	2154	2	stoop
stop	6	65	3203	2	s_top
strop	7	74	2224	2	strop
swoop	10	52	1343	2	swoop
swop	9	51	2050	2	s_wop
sybo	9	7	1474	2	sybo_
synod	9	6	1028	2	synod
syrup	10	30	1096	2	syrup
also	4	64	2344	3	also_
arson	5	51	1883	3	arson
asp	5	72	3534	3	_as_p
atop	6	61	2475	3	_atop
ays	6	70	5029	3	ays__
bebop	11	4	1079	3	bebop
besom	9	57	1697	3	besom
besot	7	64	2971	3	besot
bishop	13	3	694	3	bishop
bison	7	57	1698	3	bison
bloop	9	61	1615	3	bloop
bop	7	75	4948	3	__bop
bosom	9	55	1692	3	bosom
boson	7	60	1973	3	boson
bys	8	52	2946	3	bys__
byssi	10	50	799	3	byssi
chop	11	60	2492	3	_chop
clop	8	69	2989	3	_clop
coop	8	72	3865	3	_coop
cop	7	111	6237	3	__cop
crop	8	76	2863	3	_crop
cusp	8	60	2106	3	cus_p
cymol	12	8	762	3	cymol
cyst	9	63	2281	3	cys_t
cysts	10	59	1277	3	cysts
cyton	10	15	1146	3	cyton
droop	8	58	1482	3	droop
drop	7	53	2440	3	_drop
estop	7	43	1210	3	estop
flop	9	69	2545	3	_flop
fop	8	67	4370	3	__fop
galop	8	47	1622	3	galop
gasp	7	62	2733	3	gas_p
glop	7	67	2463	3	_glop
goop	7	58	2948	3	_goop
gyp	9	83	1901	3	gy__p
gyro	8	52	1788	3	gyro_
gyron	9	53	1462	3	gyron
gyros	9	56	1648	3	gyros
hasp	9	66	2729	3	has_p
hoop	9	61	2998	3	_hoop
hop	8	75	5459	3	__hop
hyp	11	78	2246	3	hy__p
hypo	12	75	1635	3	hypo_
hypos	13	120	1474	3	hypos
hysons	12	3	763	3	hysons
hyssops	15	4	312	3	hyssops
jalop	14	42	1260	3	jalop
joypop	20	6	313	3	joypop
knop	10	71	1660	3	_knop
knosp	11	57	682	3	knosp
kop	9	74	4021	3	__kop
lisp	6	89	2689	3	lis_p
loop	6	78	3501	3	_loop
lop	5	82	5531	3	__lop
lyse	7	63	2059	3	lys_e
lysed	9	50	1156	3	lysed
lyses	8	45	1825	3	lyses
lysin	8	45	1278	3	lysin
lysis	8	45	1146	3	lysis
lyssa	8	3	571	3	lyssa
mason	7	48	2018	3	mason
maypop	15	6	514	3	maypop
meson	7	41	1831	3	meson
miso	6	72	2991	3	miso_
misos	7	65	2329	3	misos
mop	7	69	5082	3	__mop
myope	12	40	1097	3	my_ope
myopy	15	45	735	3	my_opy
mysid	11	6	1069	3	mysid
mysost	11	3	826	3	mysost
netop	7	3	1234	3	netop
nylon	8	29	1051	3	nylon
op	4	58	5016	3	___op
orlop	7	4	1090	3	orlop
peso	6	69	2582	3	peso_
pesos	7	72	2162	3	pesos
piso	6	67	2757	3	piso_
pisos	7	60	2106	3	pisos
plop	8	66	2574	3	_plop
poop	8	65	3281	3	_poop
pop	7	62	5225	3	__pop
postop	10	5	1194	3	postop
preop	9	47	1587	3	preop
prop	8	59	3281	3	_prop
psyops	13	3	434	3	psy_ops
pylon	10	36	1400	3	pylon
pyro	9	60	1939	3	pyro_
pyrope	13	28	1053	3	pyrope
pyros	10	57	1829	3	pyros
rasp	6	60	2916	3	ras_p
rebop	9	3	1328	3	rebop
resod	6	47	2005	3	resod
resow	8	82	1724	3	resow
ryot	7	55	2856	3	ry_ot
sabot	7	9	3178	3	sabot
sago	5	63	3267	3	sago_
sagos	6	61	2387	3	sagos
sajou	12	3	1169	3	sajou
salep	7	70	2295	3	salep
salol	5	52	2214	3	salol
salon	5	52	2855	3	salon
saloop	8	42	1258	3	saloop
salp	6	45	3409	3	s_alp
samp	8	57	3359	3	s_amp
sannop	8	3	737	3	sannop
sap	5	64	6323	3	__sap
sapor	7	51	1925	3	sapor
sarod	6	53	2587	3	sarod
saros	5	52	3806	3	saros
sash	7	72	3530	3	sas_h
sasin	5	46	2657	3	sasin
sass	4	50	3562	3	sas_s
sassy	8	58	1381	3	sassy
savor	8	54	1794	3	savor
savoy	11	47	1388	3	savoy
says	7	59	4210	3	says__
sayst	8	53	2200	3	says_t
scalp	9	52	1798	3	scalp
scamp	11	57	1731	3	scamp
scarp	9	57	2410	3	scarp
scaup	9	55	1599	3	scaup
scion	7	22	1499	3	scion
scoops	10	54	1436	3	scoops
scoot	7	57	2915	3	scoot
scope	9	48	2148	3	s_cope
scops	9	58	2019	3	s_cops
scot	6	62	4261	3	s_cot
scow	9	60	2142	3	s_cow
scrap	9	71	2040	3	scrap
scrip	9	66	1919	3	scrip
scrod	8	51	1507	3	scrod
scroop	10	29	978	3	scroop
sculp	9	53	1484	3	sculp
scup	8	48	2238	3	s_cup
season	6	27	1490	3	season
seep	6	65	4034	3	s_eep
sego	5	65	2518	3	sego_
segos	6	49	1948	3	segos
seisor	6	37	1234	3	seisor
senor	5	38	2280	3	senor
sensor	6	38	1384	3	sensor
sepoy	10	3	1430	3	sepoy
serow	8	67	2044	3	serow
seton	5	52	2354	3	seton
setup	7	39	1582	3	setup
sharp	10	49	2253	3	sharp
sheep	10	53	2152	3	sheep
sheol	8	43	1837	3	sheol
ship	9	52	2824	3	s_hip
shlep	10	49	1483	3	shlep
shmo	9	53	1810	3	shmo_
shod	8	62	2506	3	s_hod
shoe	7	59	3344	3	s_hoe
shog	8	60	2514	3	s_hog
shoo	7	59	2989	3	s_hoo
shook	12	49	2016	3	shook
shool	8	45	2315	3	shool
shoon	8	40	2201	3	shoon
shoos	8	42	2636	3	shoos
shoot	8	42	3591	3	shoot
shops	10	42	2290	3	s_hops
shot	7	61	5026	3	s_hot
show	10	62	2919	3	s_how
silo	4	60	3792	3	silo_
silos	5	60	2943	3	silos
simp	8	52	2878	3	s_imp
sip	5	76	5602	3	__sip
sirup	7	40	1491	3	sirup
sis	3	73	6055	3	sis__
sisal	5	42	1773	3	sisal
sises	5	52	3383	3	sises
sissy	8	58	1207	3	sissy
situp	7	44	1406	3	situp
skelp	11	42	1142	3	skelp
skep	10	52	1935	3	s_kep
skimp	13	54	1133	3	skimp
skip	10	54	2176	3	s_kip
skosh	12	40	727	3	skosh
skybox	22	4	229	3	skybox
skycap	17	4	291	3	skycap
slap	6	64	3404	3	s_lap
sleep	7	49	2018	3	sleep
slip	6	70	3173	3	s_lip
slob	6	60	2942	3	s_lob
sloe	4	55	3495	3	s_loe
slog	5	67	2827	3	s_log
sloops	8	55	1362	3	sloops
slope	7	58	2356	3	s_lope
slops	7	50	2601	3	s_lops
slosh	8	45	1448	3	slosh
slot	4	60	4983	3	s_lot
slow	7	77	2949	3	s_low
slump	9	48	1663	3	slump
slurp	7	40	1498	3	slurp
smog	7	63	1741	3	s_mog
snap	6	57	2703	3	s_nap
sneap	7	55	1482	3	sneap
snip	6	64	2465	3	s_nip
snob	6	58	2559	3	s_nob
snog	5	56	2363	3	s_nog
snood	6	46	1616	3	snood
snook	9	51	1557	3	snook
snool	5	51	1864	3	snool
snoops	8	43	1417	3	snoops
snoopy	11	44	947	3	snoopy
snoot	5	50	3014	3	snoot
snot	4	47	4545	3	s_not
snow	7	63	2479	3	s_now
so	2	88	5544	3	__so_
soap	6	58	3113	3	s_oap
sob	5	78	5794	3	__sob
sod	4	60	5371	3	__sod
sodom	8	8	1491	3	sodom
sokol	9	46	1229	3	sokol
sol	3	72	5662	3	__sol
solo	4	55	3894	3	solo_
solon	5	50	2613	3	solon
solos	5	48	3079	3	solos
som	5	91	5381	3	__som
son	3	77	6195	3	__son
sook	8	49	3339	3	s_ook
soon	4	62	4050	3	s_oon
soot	4	57	6106	3	s_oot
soph	9	70	2420	3	__soph
sopor	7	40	1649	3	sopor
sops	6	52	4456	3	__sops
sos	3	77	6160	3	__sos
sot	3	103	8430	3	__sot
sotol	5	49	1765	3	sotol
sou	3	78	5369	3	__sou
soup	6	62	3291	3	s_oup
soursop	9	4	303	3	soursop
sow	6	65	5476	3	__sow
sox	10	64	4419	3	__sox
soy	6	78	5145	3	__soy
soys	7	52	3393	3	soys__
spoof	10	50	1901	3	spoof
spook	11	54	1604	3	spook
spool	7	52	1904	3	spool
spoon	7	47	1944	3	spoon
spoor	7	50	1635	3	spoor
spot	6	55	4069	3	s_pot
stamp	9	52	1736	3	stamp
steep	7	60	2070	3	steep
step	6	71	2629	3	s_tep
stirp	7	68	1550	3	stirp
stoa	4	54	2591	3	s_toa
stob	6	67	2461	3	s_tob
stomp	9	56	1666	3	stomp
stood	6	55	1771	3	stood
stook	9	52	1821	3	stook
stool	5	56	1989	3	stool
stoops	8	59	1789	3	stoops
stope	7	47	2724	3	s_tope
stops	7	48	2728	3	s_tops
stopt	7	65	2835	3	s_topt
stoss	5	43	1634	3	stoss
stot	4	63	4733	3	s_tot
stoup	7	55	1707	3	stoup
stow	7	73	2574	3	s_tow
stowp	10	56	1423	3	stowp
strap	7	79	2526	3	strap
strep	7	71	2085	3	strep
strip	7	75	2434	3	strip
strops	8	62	2038	3	strops
strow	8	89	2057	3	strow
stroy	8	77	2039	3	stroy
stump	9	46	1646	3	stump
sudor	6	3	1262	3	sudor
sumo	6	73	2631	3	sumo_
sumos	7	57	2009	3	sumos
sump	8	63	3153	3	s_ump
sunup	7	3	1305	3	sunup
sup	5	70	4194	3	__sup
sushi	8	3	1049	3	sushi
suss	4	52	2930	3	sus_s
swamp	12	50	1532	3	swamp
swap	9	59	2543	3	s_wap
sweep	10	47	1572	3	sweep
swob	9	52	1863	3	s_wob
swoon	8	50	1478	3	swoon
swoops	11	49	1092	3	swoops
swoopy	14	48	728	3	swoopy
swops	10	59	1397	3	s_wops
swot	7	51	3466	3	s_wot
syboes	11	3	934	3	syboes
syce	9	58	2028	3	sy_ce
sycee	10	50	1862	3	sycee
syces	10	64	1646	3	syces
syke	11	54	2056	3	sy_ke
sykes	12	48	1686	3	sykes
syli	7	43	1898	3	sy_li
sylis	8	43	1602	3	sylis
sylph	13	4	779	3	sylph
sylva	11	26	844	3	sylva
symbol	13	3	608	3	symbol
syn	6	70	2412	3	sy__n
sync	9	54	1510	3	sy_nc
synch	13	50	1179	3	synch
syncom	13	3	609	3	syncom
syncope	14	4	538	3	syncope
syncs	10	46	1017	3	syncs
syne	7	57	2576	3	sy_ne
synods	10	7	795	3	synods
synth	11	37	1182	3	synth
syph	12	54	1327	3	sy_ph
syphon	14	3	685	3	syphon
syphs	13	51	945	3	syphs
syren	8	52	1674	3	syren
syrups	11	27	795	3	syrups
syrupy	14	28	582	3	syrupy
system	11	3	574	3	system
systole	10	3	576	3	systole
top	5	105	6068	3	__top
toyshop	15	4	487	3	toyshop
troop	7	64	1753	3	troop
trop	6	68	3330	3	_trop
typo	9	54	1812	3	typo_
typos	10	60	1581	3	typos
typp	11	58	1278	3	ty_pp
tyro	7	66	2236	3	tyro_
tyros	8	51	1859	3	tyros
unstop	8	3	747	3	unstop
visor	8	25	1283	3	visor
wasp	9	56	2685	3	was_p
whoop	13	42	1144	3	whoop
whop	12	55	2092	3	_whop
wisp	9	71	2408	3	wis_p
wop	8	71	4513	3	__wop
xylol	15	4	613	3	xylol
xyst	14	47	1407	3	xys_t
xysti	15	53	815	3	xysti
xystoi	16	36	513	3	xystoi
xystos	16	35	691	3	xystos
xysts	15	55	812	3	xysts
yap	8	59	4982	3	_y_ap
yaup	9	66	1848	3	_yaup
yawp	12	52	1558	3	_yawp
yelp	9	56	2135	3	_yelp
yep	8	66	3896	3	_y_ep
yip	8	72	4119	3	_y_ip
yo	5	97	4855	3	_y_o_
yob	8	79	4527	3	_y_ob
yod	7	75	4551	3	_y_od
yok	10	73	3524	3	_y_ok
yom	8	80	4344	3	_y_om
yon	6	73	4895	3	_y_on
you	6	66	4182	3	_y_ou
yow	9	69	4529	3	_y_ow
yup	8	60	3170	3	_y_up

Search took 5 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	83667	0.360	496363.9
2	DLD Change Limit	83667	370	3.983	21006.0
3	Display Results	370	370	0.093	3978.5
	(SQL Overall)	178691	370	4.436	40282.0