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 “ohs” with Change Limit: [1] [2]

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

436 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
ohs6623231(None) 
ahs68644821ahs
hos68364191hos
ods47546211ods
oes35866191oes
oh57447001oh_
ohm86523011ohm
ohms95514031ohms
oho66534381oho
oms56337511oms
ons36148511ons
oohs75220691oohs
ops56641251ops
ors35750111ors
os211359881o_s
aahs716428562aahs
aas310975392aas
abs59356072abs
ads49755732ads
ags47551662ags
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahis76135382ahis
ais39083572ais
als36663022als
ars37670932ars
as211083072_as
ash67944602ash
ass37844062ass
ays67050292ays
bas58681752bas
bes56557432bes
bis56860652bis
boas66150832boas
bobs86340642bobs
bods76244712bods
bogs75742752bogs
boho96923322boho
bohos105618252bohos
boos67955032boos
bops86037982bops
bos57966812bos
bosh96328972bosh
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
bus56950972bus
bys85229462bys
chi86228652chi
chis95933312chis
cis57748032cis
cobs87043142cobs
cods76848102cods
cogs77340032cogs
coho97524492coho
cohos105921852cohos
cols66553082cols
cons66057692cons
coos67456492coos
cops86751372cops
cors66656442cors
cos510270392cos
cosh96127622cosh
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
dahs88231812dahs
dis46459892dis
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dors56747602dors
dos48062312dos
doss56235042doss
dots55647662dots
dows85941052dows
edhs86212102edhs
eds46638922eds
efs66829602efs
eh58339962eh_
els37645722els
ems56435492ems
ens37245922ens
eons46638712eons
ers36046282ers
es29048222_es
ess36030882ess
eths76619522eths
fas68262932fas
fehs106522382fehs
fes66551672fes
fobs96034272fobs
foes76543442foes
fogs87035002fogs
foh98135892foh_
fohn106116552fohn
fohns117310782fohns
fons76943892fons
fops96532682fops
foss76431642foss
foys105628292foys
gas48870252gas
ghi77019882ghi
ghis85020162ghis
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
goos57644912goos
gos47155132gos
gosh86123422gosh
goths96513002goths
goys86328412goys
ha510259942_ha
hahs108333362hahs
has67372652has
he58151952_he
hehs106723962hehs
hes66654202hes
hi57947582_hi
his66359502his
hm78126732_hm
ho510258272_ho
hob87550922hob
hobs97038982hobs
hod76852462hod
hods87239862hods
hoe67562722hoe
hoes75755732hoes
hog78049062hog
hogs87139662hogs
hols76946292hols
hon67759382hon
hons77350782hons
hop87554592hop
hops97942632hops
hose76547242hose
host77852832host
hot67776052hot
hots78349322hots
how97252432how
hows106345602hows
hoy97447912hoy
hoys107733932hoys
ichs96214712ichs
ids47535462ids
ifs67124242ifs
ins35945602ins
ions46737852ions
is27048212_is
its35538832its
jobs136529432jobs
joes116635892joes
jogs127129332jogs
john145512902john
johns15398712johns
josh145117612josh
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
jus106930222jus
kas77058582kas
khi106318302khi
khis117017982khis
kis78051472kis
koas85635092koas
kobs105831082kobs
kohl113911712kohl
kohls12437802kohls
kois85129392kois
kophs145010932kophs
kops107031292kops
kors85933012kors
kos76944822kos
koss85224812koss
las37281472las
les35663072les
lis37162272lis
lobs66441082lobs
lochs106715512lochs
logs57343112logs
loos49051122loos
lops66043352lops
loss45337962loss
lots47652092lots
lows75843012lows
mas58175812mas
mho86624622mho
mhos95517772mhos
mis58162612mis
moas65545342moas
mobs85737362mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
moms86539482moms
mons68152252mons
moos66051302moos
mops85940132mops
mors65950062mors
mos57067122mos
mosh95227602mosh
moss67641032moss
moths106021552moths
mots66853162mots
mows96340832mows
mus55946752mus
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
noh66640642noh_
noms65636402noms
nos38859322nos
nosh76223542nosh
nous46136982nous
nows75738232nows
nus37939392nus
oaf65952882oaf
oafs76425262oafs
oak76238652oak
oaks86527902oaks
oar37057952oar
oars46846032oars
oast47156322oast
oat39888262oat
oaths86117312oaths
oats46554212oats
oba57531552oba
obas65730932obas
obe56638642obe
obes66036832obes
obi57127722obi
obis66226832obis
oca56731732oca
ocas66729632ocas
od39255242o_d
oda48133042oda
odahs95610082odahs
odas57230262odas
odd57725452odd
odds68919922odds
ode47446582ode
odes57243242odes
oe28473062o_e
of58247772o_f
off96331632off
offs107117012offs
oft67744062oft
ohed87825182ohed
ohia75719362ohia
ohias84415562ohias
oi29061482o_i
oil37452052oil
oils46337972oils
oka76926802oka
okas85225392okas
oke75839482oke
okehs12477462okehs
okes84936342okes
old47033462old
olds55926572olds
ole37155212ole
oles46453472oles
om48553002o_m
on28057182o_n
one37050912one
ones46146532ones
ono36838032ono
onos46229002onos
onus45826812onus
ooh67637092ooh
oops65232672oops
oot311274692oot
oots46446442oots
op45850162o_p
opahs105411982opahs
ope56845242ope
opes65942612opes
opt57545542opt
opts68124742opts
opus66420592opus
or27354732o_r
ora37250832ora
orb55736862orb
orbs66626252orbs
orc57034922orc
orcs67025432orcs
ore36661832ore
ores46056682ores
ort39465232ort
orts46538332orts
ose38147342ose
oses46641512oses
ossa43714162ossa
oud47439072oud
ouds56430102ouds
ouphs104311272ouphs
our36042892our
ours47237562ours
oust46747442oust
out38072152out
outs45746962outs
ova66823792ova
ow58950172o_w
owe67041032owe
owes75137102owes
owl66228972owl
owls76022932owls
own66429702own
owns76819582owns
owse76321622owse
ox98242382o_x
oxes116530722oxes
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
oyes74940132oyes
pas58775742pas
pehs95625762pehs
pes57259782pes
phi86524202phi
phis95724902phis
pht86030522pht
pis56362032pis
pods76540152pods
poh86740532poh_
pois66539042pois
pols66044562pols
poms87037742poms
pons65850602pons
poohs103915712poohs
poos65949112poos
pops86340952pops
posh95427322posh
pots66452362pots
pows95537662pows
pus55547842pus
qis126934382qis
qophs19507812qophs
ras37575392ras
res35565042res
rho65924832rho
rhos76319062rhos
rhus75114052rhus
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954132roes
roms67038962roms
rots46454092rots
rows75941752rows
sh56828522sh_
sha69837782sha
she66837692she
shes75734352shes
shh97121072shh
shy96728192shy
sis37360542sis
sobs64941752sobs
sods54940212sods
sols45448162sols
soms66239372soms
sons46049552sons
sophs104916022sophs
sops65244562sops
sos37761602sos
soths86218622soths
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
tas38477102tas
the67436052the
this76027382this
tho67433962tho
thus76721472thus
thy97022912thy
tis37056642tis
tods56141842tods
toes46956442toes
togs57242432togs
toms68343492toms
tons46553052tons
tophs105220052tophs
tops66248122tops
tors46157382tors
tosh74826812tosh
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
ughs85410972ughs
uh57429852uh_
uns35936752uns
ups55629052ups
us26937432_us
uts35534372uts
vas67755772vas
vis66747612vis
voes75432822voes
vows106626942vows
was68767562was
wha96422072wha
who95526772who
why126920012why
whys137011662whys
wis66552332wis
woes76440662woes
wogs86531402wogs
woks116224902woks
wons74942042wons
woos76238802woos
wops96634152wops
wos66953532wos
wots76342892wots
wows104633492wows
xis106935332xis
yes66250612yes
yobs96028082yobs
yodhs12669012yodhs
yods86531182yods
yoghs125410592yoghs
yoks116223742yoks
yous76230652yous
yows106433122yows
zas126946832zas
zoos135828802zoos

Search took 1 second 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 Filter178691140840.0602978183.3
2DLD Change Limit140844360.42333295.5
3Display Results4364360.0765736.8
 (SQL Overall)1786914360.559319661.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.