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 “mhos” 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.

222 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
mhos9551777(None) 
hos68364191_hos
mho86624621mho_
moos66051301moos
mos57067121m_os
rhos76319061rhos
abmhos1334972abmhos
abos67734412abos
ados57633512ados
ahis76135382ahis
ahoy101919182ahoy
ahs68644822ah_s
ambos95321252ambos
ammos94815822ammos
apos65433822apos
avos77227012avos
bios66335322bios
bohos105618252bohos
boos67955032boos
bos57966812_bos
bros65635662bros
chaos105622862chaos
chis95933312chis
chon96627792chon
chop116024922chop
chops125019872chops
chose105925402chose
chow125820992chow
chows135618202chows
cohos105921852cohos
coos67456492coos
cos510270392_cos
dhow116614002dhow
dhows125911222dhows
dos48062312_dos
duos56728132duos
echos105216462echos
egos55821652egos
epos66723732epos
eros45238452eros
ethos85514192ethos
ghis85020162ghis
ghost96318762ghost
goos57644912goos
gos47155132_gos
has67372652_has
hes66654202_hes
his66359502_his
ho510258272_ho_
hob87550922_hob
hobs97038982_hobs
hod76852462_hod
hods87239862_hods
hoe67562722_hoe
hoes75755732_hoes
hog78049062_hog
hogs87139662_hogs
hols76946292_hols
hon67759382_hon
hons77350782_hons
hop87554592_hop
hops97942632_hops
hose76547242_hose
host77852832_host
hot67776062_hot
hots78349332_hots
how97252432_how
hows106345602_hows
hoy97447912_hoy
hoys107733932_hoys
khis117017982khis
kos76944822_kos
loos49051122loos
machos135217492machos
macs86742512macs
mads76845372mads
maes66948402maes
mags75444532mags
mahoe10315572mahoe
mahoes11313102mahoes
makos116518362makos
manos74933622manos
mans66354552mans
maps86141052maps
mars66261872mars
mas58175822m_as
mass66044942mass
mats65460292mats
maws96437142maws
mayos105521932mayos
mays96940032mays
meds75735362meds
megs75530632megs
mels65941532mels
memos95719112memos
mems85931502mems
meou65325862meou
meous76120062meous
meow95117882meow
meows104612682meows
mess65932432mess
mews96629332mews
mibs85330482mibs
mics87435152mics
mids76541782mids
migs76935322migs
milos75428012milos
mils66045332mils
mips85534082mips
mirs66940572mirs
mis58162622m_is
miso67229902miso
misos76523292misos
miss65339422miss
mo49158482m_o_
moa57249182m_oa
moas65545342moas
mob78651922m_ob
mobs85737372mobs
moc77845082m_oc
mocs85834902mocs
mod69054402m_od
mods77945052mods
mog66949672m_og
mogs75439332mogs
mojos145314462mojos
mol56654592m_ol
mols65948572mols
mom78853162m_om
moms86539482moms
mon57561582m_on
monos75930862monos
mons68152262mons
moo58460512m_oo
mood76332062mood
moods85224622moods
mool67533862mool
mools76027172mools
moon67140812moon
moons75331002moons
moor66628552moor
moors74923142moors
moose76327192moose
moot67653622moot
moots75831662moots
mop76950822m_op
mops85940132mops
mor56855002m_or
mors65950062mors
mosh95227602m_osh
mosk105622442m_osk
moss67641032moss
most66554202m_ost
mot57279422m_ot
mots66853162mots
mow86650352m_ow
mows96340832mows
mozos165516332mozos
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535922muns
muon65722732muon
muons75816172muons
mus55946752m_us
muss64933762muss
muts64839982muts
mycs115314292mycs
mythos14398462mythos
naos47429732naos
nos38859322_nos
ohms95514032ohms
oho66534382oho_
ohs66232312oh_s
onos46229002onos
oohs75220692oohs
os211359882__os
phis95724902phis
phon95925382phon
phons105221142phons
phot95534362phot
phots105418502phots
poos65949112poos
pros65742782pros
rho65924832rho_
rhus75114052rhus
shes75734352shes
shod86225062shod
shoe75933442shoe
shoes85429662shoes
shog86025142shog
shogs95319712shogs
shoo75929892shoo
shoos84226362shoos
shop95629842shop
shops104222902shops
shot76150262shot
shots84730852shots
show106229192show
shows115324582shows
sos37761602_sos
taos45541002taos
this76027382this
tho67433962tho_
those85218142those
thou76722212thou
thous86017262thous
thus76721472thus
twos76718022twos
udos56619902udos
umbos94613072umbos
who95526772who_
whoa106615202whoa
whom127018182whom
whop125520922whop
whops135013932whops
whose114914532whose
whoso11509222whoso
whys137011662whys
woos76238802woos
wos66953532_wos
zoos135828802zoos

Search took 7 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 Filter178691298720.563317390.8
2DLD Change Limit298722223.8607738.9
3Display Results2222220.530418.9
 (SQL Overall)1786912224.95336077.3
 
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.