Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

401 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
schmos1337915(None) 
schmo124510201schmo_
schmoe13328331schmoe
schmoes14308541schmoes
schmoos14347511schmoos
camos95927612_camos
chaos105622862_chaos
chemos13311722_chemos
echos105216462ech_os
scamps125014172scamps
scams94423972scam_s
schavs1436492schavs
schemas1468162schemas
schemes1489662schemes
schizos21115432schizos
schmoose15295972schmoose
schnoz2035652schnoz
school11410722school
schools1249112schools
schrod1247882schrod
schrods1337432schrods
schuls11299852schuls
schuss11186732schuss
schwas14396982schwas
scums95017422scum_s
shamos114216982shamos
shmo95318102s_hmo_
shmoes114612102s_hmoes
shoos84226362s_hoos
sixmos1534812sixmos
skimos12548802skimos
sumos75720092s_umos
abmhos1334973abmhos
aches106132293ach_es
achoo10315083ach_oo
acmes96020653ac_mes
alamos8415003alamos
ammos94815823_ammos
anchos114214893anch_os
asthmas12117363asthmas
bohos105618253boh_os
bromos104213313bromos
calos74431903_calos
camas96333523_camas
cameos105818003_cameos
cames97047313_cames
camo85731753_camo_
campos125217953_campos
camps116330263_camps
cams87047283_cam_s
capos94826073_capos
ceros74726073_ceros
chads116122233_chads
chais107530313_chais
chamois143512193_chamois
champs154915683_champs
chams126028503_chams
chao95727313_chao_
chaps125326063_chaps
chars105936643_chars
chats105730093_chats
chaws135022463_chaws
chays135319743_chays
chefs136214663_chefs
chemo12313633_chemo_
chess105016923_chess
chews135418513_chews
chias104625523_chias
chicos134614833_chicos
chics123920943_chics
chimbs153910303_chimbs
chimes134922573_chimes
chimps155713663_chimps
chinos115018693_chinos
chins105631463_chins
chips125721253_chips
chiros114617773_chiros
chis95933313_ch_is
chits105424573_chits
cholos114716853_cholos
chomp144815663_chomp
chomps155112223_chomps
chon96627793_ch_on
chook146015043_chook
chooks155312793_chooks
choose115116143_choose
choosy14459103_choosy
chop116024923_ch_op
chops125019873_chops
chose105925403_ch_ose
chow125820993_ch_ow
chows135618203_chows
chromos142610273_chromos
chubs125412623_chubs
chugs115511943_chugs
chumps154313823_chumps
chums125015833_chums
chymes165912153_chymes
chymous1775703_chymous
cocos95624693_cocos
cohos105921853_cohos
comas95833003_comas
combos125316613_combos
combs116122963_combs
comes97246993_comes
comose105016843_comose
comous10816503_comous
compos124818803_compos
comps115526053_comps
coos67456493_c_oos
cos510270393_c__os
cosmos10311753cosmos
cwms11439573_cwm_s
cymas126417883_cymas
cymes1210118923_cymes
cymol1287623_cymol
cymols1377193_cymols
cymose13429653_cymose
cymous1388403_cymous
demos86022993_demos
duomos936823duomos
eches106322163ech_es
echo96615953ech_o_
echoes114715523echoes
eschars1237173eschars
eschews1534553eschews
escudos1043493escudos
ethnos947053ethnos
ethos85514193eth_os
gismos957183gismos
gizmos1844133gizmos
hommos13128503hommos
homos105921783_homos
hos68364193__h_os
ichor1039483ich_or
ichors11310423ichors
ichs96214713ich__s
isthmus1243263isthmus
limos75320813_limos
machos135217493mach_os
memos95719113_memos
mhos95517773_mh_os
mos57067123___mos
nachos115014183nach_os
nomos75919743_nomos
ochers113915303ochers
ochres113510833ochres
ochrous1237943ochrous
ohms95514033_ohm_s
pomos95321583_pomos
primos104514423primos
promos105116423promos
psychos1765263psych_os
rhos76319063_rh_os
sachems14348903sachems
sachets123914103sachets
sagos66123873s_agos
sahibs1137083sahibs
salmis8514273salmis
salmon84614183salmon
salmons93713263salmons
salvos94613383salvos
sambos104315193sambos
samosa8510203s_amosa
samps96124673s_amps
santos64421833santos
sargos74318273sargos
saros55238063s_aros
scabs94818643sc_abs
scads85419963sc_ads
scags85520973sc_ags
scalds94813693scalds
scales84529313scales
scalls84218203scalls
scalps104315233scalps
scam85932353scam__
scamp115717313scam_p
scampi12469103scampi
scans74625103sc_ans
scants85219723scants
scapes105122263scapes
scapose1147753scapose
scares85033003scares
scarfs114714683scarfs
scarps104718603scarps
scars75433533sc_ars
scarts85321493scarts
scats75930603sc_ats
scatts85914663scatts
scaups105411933scaups
scaurs85512053scaurs
scenas84114703scenas
scends95213003scends
scenes84520353scenes
scents85317023scents
schav1338313sch_av
schema1388373schema
scheme1379633scheme
schemed1577753schemed
schemer1477963schemer
schemers1576713schemers
scherzos2243703scherzos
schism1338173schism
schisms1437173schisms
schist11312653schist
schists1248543schists
schizo20115993schizo
schizy23115043schizy
schlep1347093schlep
schleps1445483schleps
schlock18235873schlock
schlocks19245693schlocks
schlub1355003schlub
schlubs1443193schlubs
schlumps1742743schlumps
schmalz2345293schmalz
schmear1484043schmear
schmears1584103schmears
schmeer1475363schmeer
schmeers1574833schmeers
schmoosed17294303schmoosed
schmooses16275633schmooses
schmooze24255013schmooze
schmoozes25214903schmoozes
schmoozy27262863schmoozy
schmuck2043043schmuck
schmucks2142763schmucks
schnaps1443703schnaps
schnook1654483schnook
schnooks1754243schnooks
schnozes2244493schnozes
schnozz2042733schnozz
schorl1179813schorl
schorls1248353schorls
schrik15206703schrik
schriks16185743schriks
schtik15185423schtik
schtiks16184743schtiks
schuit1139563schuit
schuits1235823schuits
schul102510413sch_ul
schuln11256233schuln
schwa13426843sch_wa
scion72214993sc_ion
scions82612243scions
scoffs14347503scoffs
scolds95011233scolds
scones84521303scones
scoop95617163sc_oop
scoops105414363scoops
scoot75729153sc_oot
scoots85315943scoots
scop85925523sc__op
scopes104719593scopes
scops95820193sc_ops
scores84725923scores
scorns85713023scorns
scot66242613sc__ot
scots74025913sc_ots
scours84913593scours
scouts84817943scouts
scow96021423sc__ow
scowls11549593scowls
scows106617803sc_ows
scrags95713803scrags
scrams105216623scrams
scraps106017243scraps
screes85023973screes
screws115513893screws
scries85226823scries
scrimps13517903scrimps
scrims104615933scrims
scrips105316033scrips
scrod85115073sc_rod
scrods94111613scrods
scroop10299783scroop
scroops11288253scroops
scrubs104210313scrubs
scrums104614253scrums
scubas103710223scubas
scudo85412213scudo_
scuds85116243sc_uds
scuffs14419053scuffs
sculks123610263sculks
sculls84613883sculls
sculps104611753sculps
scum85924523scum__
scummy15265223scummy
scups95316653sc_ups
scurfs113210813scurfs
scutes85219193scutes
scuts74522523sc_uts
seams75731663seam_s
seccos1039923seccos
seems75525023seem_s
segnos73610443segnos
segos64919483s_egos
semes75731583s_emes
semis74623533s_emis
sermon8413553sermon
sermons9311783sermons
servos93812723servos
sextos134012163sextos
shads95124483s_hads
shags95123863s_hags
shahs115919513s_hahs
shakos134912193shakos
shamas113717943shamas
shames114726223shames
shammos14307203shammos
shamois123210423shamois
shamoy14379913shamoy
shamoys15367283shamoys
shams105829413s_hams
shamus114112813shamus
shaws116226263s_haws
shays116021433s_hays
sheas86331793s_heas
sheds96122703s_heds
sheol84318373s_heol
sheols94614163s_heols
shes75734353s_h_es
shews115924713s_hews
shies86136553s_hies
shims104422553s_hims
shins85131043s_hins
ships105123773s_hips
shits84731173s_hits
shivs115018803s_hivs
shod86225063s_h_od
shoe75933443s_h_oe
shoes85429663s_hoes
shog86025143s_h_og
shogs95319713s_hogs
shoo75929893s_h_oo
shook124920163s_hook
shooks134515633s_hooks
shool84523153s_hool
shools94919013s_hools
shoon84022013s_hoon
shoot84235913s_hoot
shoots94619363s_hoots
shop95629843s_h_op
shops104222903s_hops
shot76150263s_h_ot
shots84730853s_hots
show106229193s_h_ow
shows115324583s_hows
shris84221453s_hris
shuls85319713s_huls
shuns85018143s_huns
shuts85622483s_huts
shwas116415103s_hwas
sickos125112033sickos
siglos7311473siglos
sigmas94111363sigmas
silos56029433s_ilos
simas75727553s_imas
simps94719763s_imps
sims65737173s_im_s
sixmo1448303sixmo_
skimo116312543skimo_
skimps14488043skimps
skims114517193skim_s
slams74927903slam_s
slimes84722043slimes
slims75423653slim_s
slumps104313583slumps
slums74623433slum_s
smog76317413s__mog
smogs85112163s__mogs
sodoms989673sodoms
solos54830793s_olos
somas76030373s_omas
soms66239373s_om_s
sorgos74514663sorgos
sos37761603s___os
spams94922193spam_s
spumes1021314883spumes
spumous1135853spumous
stamps105614023stamps
stems75219953stem_s
stenos63915773stenos
stimes85920573stimes
stomas84816323stomas
stomps105612833stomps
stumps104912283stumps
stums75320083stum_s
summas104313163summas
summon1037623summon
summons1158003summons
sumo67326313s_umo_
sumps95023433s_umps
sums65837583s_um_s
swamis114212293swamis
swamps135910263swamps
swims105514143swim_s
synchros1645203synchros
technos1236183technos
wahoos122310593wahoos
yahoos12209243yahoos

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.390458182.1
2DLD Change Limit1127164014.87623116.5
3Display Results4014010.1263182.5
 (SQL Overall)1786914015.39233140.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.