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

364 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
hope9663967(None) 
cope86847381cope
dope76038891dope
hoe67562721ho_e
hoke115935931hoke
hole77553391hole
home98042441home
hone77549321hone
hop87554591hop_
hoped115628181hoped
hoper105829141hoper
hopes105835641hopes
hops97942631hops
hose76547241hose
hove107132221hove
howe106734101howe
hype125519811hype
lope65941921lope
mope86838041mope
nope65934191nope
ope56845241_ope
pope85535611pope
rope65542911rope
tope65946381tope
ape57251182_ape
bode75838752bode
bole66448692bole
bone65949322bone
bop77549482bop_
bops86037982bops
bore66051332bore
cape87242782cape
cepe84926652cepe
chape125221142chape
choke145118022choke
chop116024922chop_
chops125019872chops
chore105126762chore
chose105925402chose
code77347732code
coke107038382coke
cole66956112cole
come87547702come
cone67256962cone
cop711162372cop_
coped105036842coped
copen94826432copen
coper95336092coper
copes97747102copes
cops86751372cops
copse95623922copse
copy116229802copy
core67263112core
cote66648732cote
coupe96023482coupe
cove95837072cove
dhole95215362dhole
doe47361952do_e
doge66233802doge
dole56550002dole
dome77240732dome
done55747912done
dopa77220902dopa
doped95326712doped
doper86128392doper
dopes84935042dopes
dopey116020352dopey
dopy106224152dopy
dore56353302dore
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
dupe76630602dupe
elope75219342elope
foe66350812fo_e
fop86743702fop_
fops96532682fops
fore78351472fore
gape75134512gape
gone55639042gone
gore55744962gore
grope84821612grope
hade85440192hade
hae67364002h_ae
hake115637842hake
hale76052832hale
hame97043132hame
haole84820082haole
hap87360052hap_
haps96443462haps
hare76255732hare
hate78450172hate
have106137072have
haze164833392haze
he58151952h__e
hebe96424702hebe
heme95034412heme
hep86644142hep_
here76447102here
hide85134622hide
hie67652702h_ie
hike116830392hike
hip86750432hip_
hips96433702hips
hire75538962hire
hive106029672hive
ho510258272ho__
hoar76729162hoar
hoax147718292hoax
hob87550922ho_b
hobo97026082hobo
hobs97038982hobs
hock136031302hock
hod76852462ho_d
hods87239862hods
hoed87837982hoed
hoer76533982hoer
hoes75755732hoes
hog78049062ho_g
hogg96617532hogg
hogs87139662hogs
hoise85224772hoise
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hold86235062hold
holed95634132holed
holes84748652holes
holey115626902holey
holk116027942holk
holm95628102holm
holp95727552holp
holpen11299412holpen
hols76946292hols
holt77852582holt
holy106333432holy
homed115425422homed
homer105828452homer
homes106938812homes
homey135924842homey
homie104622522homie
homo96126472homo
homy126623222homy
hon67759382ho_n
honed95332262honed
honer85332092honer
hones88144492hones
honey115629912honey
hong85833952hong
honk116931192honk
hons77350782hons
hood85132332hood
hooey114926602hooey
hoof106036582hoof
hook116133282hook
hoop96129982hoop
hooped125518182hooped
hooper114518312hooper
hoopoe11911232hoopoe
hoops105621072hoops
hoot75752092hoot
hopers114222972hopers
hopped144318112hopped
hopper134218482hopper
hopple132910482hopple
hoppy154912352hoppy
hora76136552hora
horde94623052horde
horn76735612horn
horse86132652horse
hos68364192ho_s
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hoser811529762hoser
hoses85443172hoses
hosey116127022hosey
host77852832host
hot67776052ho_t
hotel85520742hotel
hots78349322hots
hour75827312hour
house89131422house
hovel115017682hovel
hover115524132hover
how97252432ho_w
howes114730262howes
howf136127202howf
howk145221962howk
howl107625692howl
hows106345602hows
hoy97447912ho_y
hoya107418372hoya
hoyle11314412hoyle
hoys107733932hoys
hue66642302h_ue
huge86321652huge
hup86437812hup_
hyp117822462hyp_
hyped145313332hyped
hyper135213902hyper
hypes135818672hypes
hypo127516352hypo
hyps125418412hyps
hyte109018942hyte
jape134923422jape
joe106642352jo_e
joke155926162joke
jole117233822jole
jupe134921002jupe
kop97440202kop_
kopek1037812kopek
koph135816542koph
kopje1835272kopje
kops107031292kops
kore85834162kore
lipe66839732lipe
lobe65535362lobe
lode56240112lode
loge56837192loge
lone45849132lone
lop58255312lop_
loped85128332loped
loper75129232loper
lopes76437342lopes
lops66043352lops
lore45850352lore
lose45144582lose
loupe75319512loupe
love75234762love
lowe75435312lowe
mode75840302mode
moke106234222moke
mole66251832mole
mome85239352mome
mop76950822mop_
moped105424732moped
moper94925922moper
mopes95134982mopes
mopey124821822mopey
mops85940132mops
mopy115721972mopy
more67154522more
mote67048082mote
moue65835572moue
move96630722move
myope124010972myope
nape65230802nape
node513036882node
nome66038422nome
none45743172none
nose46739362nose
note46239962note
obe56638642_obe
ode47446582_ode
oe28473062_o_e
oke75839482_oke
ole37155212_ole
one37050912_one
oops65232672oops
ooze136420602ooze
op45850162_op_
oped76230152_oped
open66427002_open
opes65942612_opes
ops56641252_ops
opt57545542_opt
ore36661832_ore
ose38147342_ose
owe67041032_owe
pe47649032__pe
phone105621932phone
pipe86434432pipe
poke105335362poke
pole65951302pole
pome85636692pome
pone65747532pone
pop76252252pop_
popes95933812popes
pops86340952pops
pore66451262pore
pose66441732pose
qoph185911942qoph
rape65041632rape
ripe66038922ripe
robe65335642robe
rode55844302rode
roe36861072ro_e
role45851822role
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
ropy96323412ropy
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
scope94821482scope
shape105125112shape
shoe75933432sho_e
shone83725972shone
shop95629832shop_
shoppe133110312shoppe
shops104222892shops
shore85432642shore
shote85526082shote
shove114421032shove
sipe67341042sipe
slope75823562slope
soke85436262soke
sole46053672sole
some66040382some
sone46649982sone
sop57557862sop_
soph97024202soph
sops65244562sops
sore47059532sore
stope74727242stope
supe65932762supe
tape64538142tape
thole85620842thole
thorpe113610092thorpe
those85218142those
toe310166852to_e
toke86738492toke
tole46052902tole
tome67543192tome
tone46953742tone
top510560682top_
toped85631312toped
topee76029952topee
toper75231022toper
topes76941762topes
toph96326872toph
tophe106718972tophe
topi67830392topi
topo66932402topo
tops66248122tops
tore47359322tore
tote46643672tote
trope75725802trope
type96223742type
voe67739052vo_e
vole75236982vole
vote74728622vote
whole114418092whole
whop125520922whop_
whops135013932whops
whore116018042whore
whose114914532whose
wipe94830282wipe
woe66651242wo_e
woke115527962woke
wop87145132wop_
wops96634152wops
wore77144672wore
wove105624312wove
yipe96722172yipe
yoke115626392yoke
yore76335942yore
yowe106728742yowe
zone135231082zone

Search took 2 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.1561145455.1
2DLD Change Limit298723641.08027659.3
3Display Results3643640.0933914.0
 (SQL Overall)1786913641.329134455.2
 
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.