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

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

416 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
schmo	12	45	1020	(None)
schmoe	13	32	833	1	schmoe
schmos	13	37	915	1	schmos
shmo	9	53	1809	1	s_hmo
achoo	10	3	1508	2	achoo
camo	8	57	3175	2	_camo
chao	9	57	2731	2	_chao
chemo	12	3	1363	2	_chemo
echo	9	66	1595	2	ech_o
scam	8	59	3235	2	scam_
scamp	11	57	1731	2	scamp
scams	9	44	2397	2	scams
schav	13	3	831	2	schav
schema	13	8	837	2	schema
scheme	13	7	963	2	scheme
schizo	20	11	599	2	schizo
schmoes	14	30	854	2	schmoes
schmoos	14	34	751	2	schmoos
schnoz	20	3	564	2	schnoz
school	11	4	1072	2	school
schrod	12	4	788	2	schrod
schul	10	25	1041	2	schul
schwa	13	42	684	2	schwa
scudo	8	54	1221	2	scudo
scum	8	59	2452	2	scum_
scums	9	50	1742	2	scums
shoo	7	59	2988	2	s_hoo
sixmo	14	4	830	2	sixmo
skimo	11	63	1253	2	skimo
sumo	6	73	2631	2	s_umo
abmho	12	3	679	3	abmho
ache	9	68	2982	3	ach_e
ached	11	92	2783	3	ached
aches	10	61	3229	3	aches
achy	12	63	1609	3	ach_y
acme	8	69	2432	3	ac_me
ahchoo	14	4	571	3	ahchoo
alamo	7	4	1814	3	alamo
ammo	8	55	2013	3	_ammo
ancho	10	45	1529	3	anch_o
asthma	11	12	656	3	asthma
boho	9	69	2332	3	boh_o
bromo	9	52	1720	3	bromo
calo	6	49	3644	3	_calo
cam	7	80	5898	3	_cam_
came	8	76	4875	3	_came
cameo	9	59	2499	3	_cameo
camos	9	59	2761	3	_camos
camp	10	63	3645	3	_camp
campo	11	52	1976	3	_campo
cams	8	70	4728	3	_cams
capo	8	58	2921	3	_capo
cero	6	63	2945	3	_cero
chad	10	55	2550	3	_chad
chai	9	59	2990	3	_chai
cham	11	55	3231	3	_cham
champ	14	50	1796	3	_champ
chams	12	60	2850	3	_chams
chaos	10	56	2286	3	_chaos
chap	11	49	2849	3	_chap
char	9	51	3215	3	_char
chat	9	55	4613	3	_chat
chaw	12	62	2463	3	_chaw
chay	12	49	2487	3	_chay
chef	12	51	2562	3	_chef
chemos	13	3	1172	3	_chemos
chew	12	66	2213	3	_chew
chez	18	45	1902	3	_chez
chi	8	62	2865	3	_ch_i
chia	9	60	2662	3	_chia
chiao	10	56	1836	3	_chiao
chic	11	59	2520	3	_chic
chico	12	42	1825	3	_chico
chid	10	66	2640	3	_chid
chimb	14	48	1356	3	_chimb
chime	12	53	2259	3	_chime
chimp	14	52	1647	3	_chimp
chin	9	69	3474	3	_chin
chino	10	58	2331	3	_chino
chip	11	67	2642	3	_chip
chiro	10	53	2034	3	_chiro
chis	9	59	3331	3	_chis
chit	9	69	3746	3	_chit
cholo	10	52	1797	3	_cholo
chomp	14	48	1566	3	_chomp
chon	9	66	2779	3	_chon
chook	14	60	1504	3	_chook
chop	11	60	2492	3	_chop
chow	12	58	2099	3	_chow
chromo	13	28	1101	3	_chromo
chub	11	55	1641	3	_chub
chug	10	59	1411	3	_chug
chum	11	63	1800	3	_chum
chump	14	53	1544	3	_chump
chums	12	50	1583	3	_chums
chyme	15	65	1250	3	_chyme
ciao	6	49	2418	3	_ciao
coco	8	73	3060	3	_coco
coho	9	75	2449	3	_coho
coma	8	71	3485	3	_coma
comb	10	66	3211	3	_comb
combo	11	45	1943	3	_combo
come	8	75	4770	3	_come
comp	10	67	3125	3	_comp
compo	11	53	1857	3	_compo
coo	5	95	6636	3	_c_oo
cum	7	64	4016	3	_cum_
cwm	10	68	1508	3	_cwm_
cwms	11	43	957	3	_cwms
cyma	11	67	1584	3	_cyma
cyme	11	94	2037	3	_cyme
cymol	12	8	762	3	_cymol
demo	7	74	2755	3	_demo
duomo	8	3	975	3	duomo
eche	9	75	2028	3	ech_e
eched	11	69	1922	3	eched
eches	10	63	2216	3	eches
echos	10	52	1646	3	echos
echt	9	57	2290	3	ech_t
eschar	11	3	652	3	eschar
eschew	14	3	633	3	eschew
escudo	9	4	337	3	escudo
gismo	8	4	886	3	gismo
gizmo	17	5	601	3	gizmo
hao	6	72	5112	3	__hao
hm	7	81	2673	3	__hm_
hmm	10	62	1899	3	__hmm
ho	5	102	5827	3	__h_o
homo	9	61	2647	3	_homo
ich	8	62	2774	3	ich__
ichor	10	3	947	3	ichor
ichs	9	62	1471	3	ich_s
ischia	11	3	638	3	ischia
isthmi	11	4	360	3	isthmi
limo	6	55	2973	3	_limo
macho	12	61	2015	3	mach_o
memo	8	59	2479	3	_memo
mho	8	66	2462	3	_mh_o
mo	4	91	5848	3	___mo
mucho	12	50	1344	3	much_o
nacho	10	54	1437	3	nach_o
ocher	10	45	1610	3	ocher
ochre	10	34	1159	3	ochre
ochry	13	34	693	3	ochry
ohm	8	65	2301	3	_ohm_
ohms	9	55	1403	3	_ohms
oho	6	65	3438	3	_oh_o
pomo	8	58	2845	3	_pomo
primo	9	50	1791	3	primo
promo	9	56	1999	3	promo
psycho	16	7	453	3	psych_o
rho	6	59	2483	3	_rh_o
sachem	13	40	1222	3	sachem
sachems	14	34	890	3	sachems
sachet	11	47	2577	3	sachet
sago	5	63	3267	3	s_ago
sahib	10	3	1475	3	sahib
salmi	7	8	1586	3	salmi
salmon	8	46	1418	3	salmon
salvo	8	44	1564	3	salvo
sambo	9	51	1801	3	sambo
same	6	52	4564	3	s_ame
samp	8	57	3359	3	s_amp
santo	5	62	2728	3	santo
sargo	6	54	2441	3	sargo
scab	8	59	2671	3	sc_ab
scabs	9	48	1864	3	scabs
scad	7	57	2576	3	sc_ad
scads	8	54	1995	3	scads
scag	7	66	2689	3	sc_ag
scags	8	55	2097	3	scags
scald	8	48	1812	3	scald
scale	7	46	2914	3	scale
scall	7	44	2037	3	scall
scalp	9	52	1798	3	scalp
scaly	10	47	1872	3	scaly
scampi	12	46	910	3	scampi
scamps	12	50	1417	3	scamps
scan	6	55	3045	3	sc_an
scans	7	46	2510	3	scans
scant	7	97	3507	3	scant
scape	9	69	2184	3	scape
scar	6	64	3420	3	sc_ar
scare	7	53	3446	3	scare
scarf	10	54	2714	3	scarf
scarp	9	57	2410	3	scarp
scars	7	54	3353	3	scars
scart	7	61	3977	3	scart
scary	10	52	2259	3	scary
scat	6	58	4837	3	sc_at
scats	7	59	3060	3	scats
scatt	7	60	3009	3	scatt
scaup	9	55	1599	3	scaup
scaur	7	58	1490	3	scaur
scena	7	48	1578	3	scena
scend	8	55	1629	3	scend
scene	7	72	2057	3	scene
scent	7	58	3162	3	scent
schavs	14	3	649	3	schavs
schemas	14	6	816	3	schemas
schemed	15	7	775	3	schemed
schemer	14	7	795	3	schemer
schemes	14	8	966	3	schemes
scherzo	21	5	393	3	scherzo
schism	13	3	817	3	schism
schisms	14	3	717	3	schisms
schist	11	3	1265	3	schist
schizos	21	11	542	3	schizos
schizy	23	11	504	3	schizy
schlep	13	4	709	3	schlep
schlock	18	23	587	3	schlock
schlub	13	5	500	3	schlub
schlump	16	4	326	3	schlump
schmalz	23	4	529	3	schmalz
schmear	14	8	404	3	schmear
schmeer	14	7	536	3	schmeer
schmoose	15	29	597	3	schmoose
schmooze	24	25	500	3	schmooze
schmoozy	27	26	285	3	schmoozy
schmuck	20	4	304	3	schmuck
schnook	16	5	448	3	schnook
schnozz	20	4	272	3	schnozz
schools	12	4	911	3	schools
schorl	11	7	980	3	schorl
schrik	15	20	670	3	schrik
schrods	13	3	743	3	schrods
schtik	15	18	541	3	schtik
schuit	11	3	956	3	schuit
schuln	11	25	623	3	schuln
schuls	11	29	985	3	schuls
schuss	11	18	673	3	schuss
schwas	14	39	698	3	schwas
scion	7	22	1499	3	scion
scoff	13	44	1334	3	scoff
scold	8	54	1486	3	scold
scone	7	46	2183	3	scone
scoop	9	56	1716	3	scoop
scoot	7	57	2914	3	scoot
scop	8	59	2552	3	sc_op
scope	9	48	2148	3	scope
scops	9	58	2019	3	scops
score	7	55	2673	3	score
scorn	7	58	1744	3	scorn
scot	6	62	4260	3	sc_ot
scots	7	40	2590	3	scots
scour	7	53	1553	3	scour
scout	7	50	3145	3	scout
scow	9	60	2142	3	sc_ow
scowl	10	120	1297	3	scowl
scows	10	66	1780	3	scows
scrag	8	59	1617	3	scrag
scram	9	106	2161	3	scram
scrams	10	52	1662	3	scrams
scrap	9	71	2040	3	scrap
scree	7	200	3170	3	scree
screw	10	93	1853	3	screw
scrim	9	54	1972	3	scrim
scrimp	12	51	1058	3	scrimp
scrims	10	46	1593	3	scrims
scrip	9	66	1919	3	scrip
scrod	8	51	1506	3	scrod
scroop	10	29	977	3	scroop
scrub	9	49	1420	3	scrub
scrum	9	54	1819	3	scrum
scrums	10	46	1425	3	scrums
scry	9	60	1776	3	sc_ry
scuba	9	42	1159	3	scuba
scud	7	62	2128	3	sc_ud
scudi	8	51	1216	3	scudi
scuds	8	51	1624	3	scuds
scuff	13	39	1489	3	scuff
sculk	11	51	1246	3	sculk
scull	7	53	1576	3	scull
sculp	9	53	1484	3	sculp
scummy	15	26	522	3	scummy
scup	8	48	2238	3	sc_up
scups	9	53	1665	3	scups
scurf	10	47	1932	3	scurf
scut	6	58	3554	3	sc_ut
scuta	7	58	1575	3	scuta
scute	7	55	2094	3	scute
scuts	7	45	2252	3	scuts
scuzz	15	3	757	3	scuzz
seam	6	66	4597	3	seam_
seams	7	57	3166	3	seams
seamy	10	59	2127	3	seamy
secco	9	3	1242	3	secco
seem	6	54	3856	3	seem_
seems	7	55	2502	3	seems
segno	6	48	1474	3	segno
sego	5	65	2518	3	s_ego
seme	6	58	3665	3	s_eme
semi	6	51	2722	3	s_emi
sermon	8	4	1355	3	sermon
servo	8	45	1668	3	servo
sexto	12	44	1545	3	sexto
sh	5	68	2852	3	s_h__
sha	6	98	3778	3	s_h_a
shad	8	62	3091	3	s_had
shag	8	64	3056	3	s_hag
shah	10	56	2778	3	s_hah
shako	12	55	1608	3	shako
sham	9	64	3635	3	s_ham
shame	10	57	2670	3	shame
shamos	11	42	1698	3	shamos
shamoy	14	37	991	3	shamoy
shams	10	58	2941	3	shams
shat	7	64	5659	3	s_hat
shaw	10	81	3255	3	s_haw
shay	10	71	3334	3	s_hay
she	6	68	3769	3	s_h_e
shea	7	60	3157	3	s_hea
shed	8	65	3615	3	s_hed
sheol	8	43	1836	3	s_heol
shes	7	57	3435	3	s_hes
shew	10	80	3076	3	s_hew
shh	9	71	2107	3	s_h_h
shim	9	58	2784	3	s_him
shims	10	44	2254	3	shims
shin	7	56	3430	3	s_hin
ship	9	52	2823	3	s_hip
shit	7	67	4593	3	s_hit
shiv	10	57	2116	3	s_hiv
shmoes	11	46	1209	3	s_hmoes
shod	8	62	2505	3	s_hod
shoe	7	59	3343	3	s_hoe
shog	8	60	2513	3	s_hog
shook	12	49	2015	3	s_hook
shool	8	45	2314	3	s_hool
shoon	8	40	2200	3	s_hoon
shoos	8	42	2635	3	s_hoos
shoot	8	42	3589	3	s_hoot
shop	9	56	2983	3	s_hop
shot	7	61	5024	3	s_hot
show	10	62	2918	3	s_how
shri	7	60	2169	3	s_hri
shul	7	58	2315	3	s_hul
shun	7	51	2277	3	s_hun
shut	7	61	3758	3	s_hut
shwa	10	60	1496	3	s_hwa
shy	9	67	2819	3	s_h_y
sicko	11	53	1539	3	sicko
sigma	8	45	1382	3	sigma
silo	4	60	3791	3	s_ilo
sim	5	65	5313	3	s_im_
sima	6	47	3078	3	s_ima
simp	8	52	2877	3	s_imp
sims	6	57	3717	3	s_ims
sixmos	15	3	481	3	sixmos
skim	10	53	2249	3	skim_
skimos	12	54	880	3	skimos
skimp	13	54	1131	3	skimp
skims	11	45	1718	3	skims
slam	6	77	3797	3	slam_
slams	7	49	2790	3	slams
slim	6	66	3195	3	slim_
slime	7	49	2575	3	slime
slims	7	54	2365	3	slims
slimy	10	54	1742	3	slimy
slum	6	54	3051	3	slum_
slump	9	48	1663	3	slump
slums	7	46	2343	3	slums
smog	7	63	1741	3	s__mog
so	2	88	5544	3	s___o
socko	11	52	1511	3	socko
sodom	8	8	1490	3	sodom
soldo	6	71	1656	3	soldo
solo	4	55	3894	3	s_olo
som	5	91	5380	3	s_om_
soma	6	56	3529	3	s_oma
some	6	60	4038	3	s_ome
soms	6	62	3937	3	s_oms
sorgo	6	47	1972	3	sorgo
spado	8	37	1370	3	spado
spam	8	59	3004	3	spam_
spams	9	49	2219	3	spams
spume	9	58	1731	3	spume
spumy	12	46	1036	3	spumy
stamp	9	52	1736	3	stamp
stem	6	106	2824	3	stem_
stems	7	52	1995	3	stems
steno	5	47	1686	3	steno
stime	7	65	2179	3	stime
stimy	10	51	1473	3	stimy
stoma	7	59	1827	3	stoma
stomp	9	56	1666	3	stomp
stum	6	55	2601	3	stum_
stump	9	46	1646	3	stump
stums	7	53	2008	3	stums
stymy	13	35	829	3	stymy
such	9	64	2481	3	such__
sulfo	8	3	1336	3	sulfo
sum	5	63	4601	3	s_um_
summa	9	47	1331	3	summa
summon	10	3	762	3	summon
sumos	7	57	2009	3	s_umos
sump	8	63	3153	3	s_ump
sums	6	58	3758	3	s_ums
swam	9	63	2998	3	swam_
swami	10	56	1452	3	swami
swamp	12	50	1532	3	swamp
swamy	13	67	1440	3	swamy
swim	9	62	2139	3	swim_
swims	10	55	1414	3	swims
swum	9	64	1682	3	swum_
sybo	9	7	1474	3	s_ybo
synchro	15	4	453	3	synchro
techno	11	3	595	3	techno
thio	7	72	2541	3	_thio
tho	6	74	3396	3	_th_o
thro	7	77	2642	3	_thro
wahoo	11	24	1308	3	wahoo
whamo	13	55	1126	3	whamo
who	9	55	2677	3	_wh_o
whom	12	70	1817	3	_whom
yahoo	11	29	1154	3	yahoo

Search took 4 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.110	1624463.6
2	DLD Change Limit	83667	416	3.423	24442.6
3	Display Results	416	416	0.106	3924.5
	(SQL Overall)	178691	416	3.639	49104.4