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

510 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
lops6604335(None) 
bops86037981bops
clops95924851clops
cops86751371cops
flops105920141flops
fops96532681fops
glops85619551glops
hops97942631hops
kops107031291kops
laps66848871laps
lips67141441lips
lobs66441081lobs
logs57343111logs
loops75723961loops
loos49051121loos
lop58255311lop_
lope65941921lope
lopes76437341lopes
loss45337961loss
lots47652091lots
loups75319621loups
lows75843011lows
mops85940131mops
oops65232671oops
ops56641251_ops
plops95920331plops
pops86340951pops
slops75026011slops
sops65244561sops
tops66248121tops
wops96634151wops
aloes54933672aloes
alps65529242alps
amps86230342amps
apos65433822apos
apps86319692apps
asps65622092asps
baps86040842baps
blips95615782blips
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
bloops106611342bloops
blots75626172blots
blows105423832blows
boas66150832boas
bobs86340642bobs
bods76244712bods
bogs75742752bogs
boos67955032boos
bop77549482bop_
bos57966812bo_s
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
caps87147892caps
ceps86125952ceps
chops125019872chops
claps95626182claps
clips96018302clips
clods85320862clods
clogs85519552clogs
clomps125212232clomps
clons75228132clons
clop86929892clop_
clots75627642clots
cloys104916942cloys
cobs87043142cobs
cods76848102cods
cogs77340032cogs
cols66553082cols
comps115526052comps
cons66057692cons
coops96229642coops
coos67456492coos
cop711162372cop_
cope86847382cope
copes97747102copes
copse95623922copse
copy116229802copy
corps95927042corps
cors66656442cors
cos510270392co_s
coss66143492coss
cots68054842cots
coups95522472coups
cows97046642cows
coys97537242coys
crops96125232crops
cups85430822cups
daps77239162daps
dips75536912dips
docs75631152docs
does56554472does
dogs66440152dogs
dols56943052dols
doms76239572doms
dons56048702dons
dopa77220902dopa
dopas85019062dopas
dope76038892dope
dopes84935042dopes
dopy106224152dopy
dorps85419222dorps
dors56747602dors
dos48062312do_s
doss56235042doss
dots55647662dots
dows85941052dows
drops85719502drops
dups75929512dups
elope75219342elope
elopes85918162elopes
eons46638712eons
epos66723732epos
flaps105621382flaps
flips105117742flips
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flop96925452flop_
floss85118262floss
flows115822362flows
fobs96034272fobs
foes76543442foes
fogs87035002fogs
fons76943892fons
fop86743702fop_
foss76431642foss
foys105628292foys
galops94712612galops
gaps76042972gaps
gips75632922gips
globs85616402globs
gloms85219782gloms
glop76724632glop_
gloss64319622gloss
glows95518032glows
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
goops86620962goops
goos57644912goos
gorps85316992gorps
gos47155132go_s
goys86328412goys
gyps105115022gyps
haps96443462haps
hips96433702hips
hobs97038982hobs
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hols76946292hols
hons77350782hons
hoops105621072hoops
hop87554592hop_
hope96639672hope
hopes105835642hopes
hos68364192ho_s
hots78349322hots
hows106345602hows
hoys107733932hoys
hyps125418412hyps
imps86221112imps
ions46737852ions
jalops15329592jalops
jobs136529432jobs
joes116635892joes
jogs127129332jogs
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
keps106027302keps
kips106430512kips
knops115911812knops
koas85635092koas
kobs105831082kobs
kois85129392kois
kop97440202kop_
koph135816542koph
kophs145010932kophs
kors85933012kors
kos76944822ko_s
koss85224812koss
labs67145122labs
lacs66942482lacs
lads56549132lads
lags56546222lags
lamps95624832lamps
lams66552262lams
lap58565272lap_
lapis76223152lapis
lapse74917682lapse
lars46956572lars
las37281472l_as
lass47444542lass
lats45962702lats
lavs76734152lavs
laws76441682laws
lays76043252lays
leaps75522932leaps
leas45954182leas
lees45455882lees
legs56133692legs
leis45739602leis
leks85427602leks
lens46146492lens
lept66440882lept
les35663072l_es
less45635102less
lets47147942lets
leys76430182leys
libs66732752libs
lids56336452lids
lies46454192lies
limps95522672limps
lins47059052lins
lions55923212lions
lip514755802lip_
lipa68425922lipa
lipe66839732lipe
lis37162272l_is
lisp68926872lisp
lisps76913902lisps
lits46252492lits
lo28053442lo__
load56730602load
loads65323372loads
loaf76734902loaf
loafs85616992loafs
loam65630482loam
loams75619862loams
loan47436452loan
loans56026462loans
lob57154462lo_b
lobe65535362lobe
lobes75331002lobes
lobo67229862lobo
lobos75921842lobos
loca65527682loca
loch95527132loch
lochs106715512lochs
loci66126282loci
lock106134362lock
locks115126922locks
loco67030742loco
locos75822602locos
locus74819992locus
lode56240112lode
lodes66436912lodes
loess55714702loess
loft76539142loft
lofts85518362lofts
log46252682lo_g
loge56837192loge
loges66534202loges
logo57931762logo
logos67225332logos
logy87025782logy
loid55531482loid
loids66220702loids
loin46838722loin
loins56728422loins
loll46128382loll
lolls512121732lolls
lone45849132lone
long56933342long
longs65527062longs
loo38359822lo_o
loof78141052loof
loofs85623782loofs
look87333472look
looks95124862looks
loom67035052loom
looms75124642looms
loon47344792loon
loons55731722loons
loop67835012loop
loopy105316642loopy
loose56627682loose
loot46955822loot
loots55431422loots
loped85128332loped
loper75129232loper
lopers84424142lopers
loppy125911662loppy
lord55032082lord
lords64923502lords
lore45850352lore
lores55045402lores
loris55329152loris
lorn46435252lorn
lory75931712lory
lose45144582lose
loses56742012loses
lossy85214642lossy
lost47951492lost
lot38179262lo_t
lota47233502lota
lotas55926302lotas
loth76132132loth
loti46431832loti
lotos54724632lotos
lotus55718062lotus
loud55228042loud
louis57322322louis
loup66028432loup
loupe75319512loupe
loupes84918052loupes
lour45430682lour
lours55125292lours
louse56131012louse
lousy84617082lousy
lout45952142lout
louts56330272louts
love75234762love
loves85332012loves
low66051872lo_w
lowe75435312lowe
lowes85732462lowes
lown76929292lown
lowse87219902lowse
lox108240962lo_x
loxes125227472loxes
lues45943552lues
lugs55233522lugs
lumps95624982lumps
lums65734242lums
lupus74512522lupus
luvs75818502luvs
lyes75530832lyes
maps86141042maps
mips85534072mips
moas65545342moas
mobs85737362mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
moms86539482moms
mons68152252mons
moos66051302moos
mop76950822mop_
mope86838042mope
mopes95134982mopes
mopy115721972mopy
mors65950062mors
mos57067122mo_s
moss67641032moss
mots66853162mots
mows96340832mows
naps66238582naps
nips65830922nips
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
noms65636402noms
nope65934192nope
nos38859322no_s
nous46136982nous
nows75738232nows
ods47546212_ods
oes35866192_oes
ohs66232312_ohs
olds55926572olds
oles46453472oles
oms56337512_oms
ons36148512_ons
oohs75220692oohs
oots46446442oots
op45850162_op_
ope56845242_ope
opes65942612_opes
opt57545542_opt
opts68124742_opts
opus66420592_opus
orlops847302orlops
ors35750112_ors
os211359882_o_s
paps86443452paps
peps85134512peps
pips85837132pips
plods85719292plods
plop86625742plop_
plots75025672plots
plows105419902plows
ploys105816592ploys
pods76540152pods
pois66539042pois
pols66044562pols
pomps115316192pomps
poms87037742poms
pons65850602pons
poops94422412poops
poos65949112poos
pop76252252pop_
pope85535612pope
popes95933812popes
popsy125713402popsy
pots66452362pots
pows95537662pows
props95726882props
pups86032232pups
qoph185911942qoph
qophs19507812qophs
raps66247732raps
reps65937952reps
rips66237432rips
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954132roes
romps94617542romps
roms67038962roms
rope65542912rope
ropes75940062ropes
ropy96323412ropy
rots46454092rots
roups75118902roups
rows75941752rows
saps65346372saps
scops95820192scops
shops104222892shops
sips65740102sips
slaps76025712slaps
slips76023722slips
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
sloops85513622sloops
slop66533872slop_
slope75823562slope
slopes84820452slopes
slots54830522slots
slows85323462slows
soaps75120712soaps
sobs64941752sobs
sods54940212sods
sols45448162sols
soms66239372soms
sons46049552sons
sop57557862sop_
soph97024202soph
sophs104916022sophs
sos37761602so_s
sots45552442sots
soups75322942soups
sous46947212sous
sows75342492sows
soys75233932soys
stops74827282stops
sups64834432sups
swops105913972swops
taps66050672taps
tips66436762tips
tods56141842tods
toes46956442toes
togs57242432togs
toms68343492toms
tons46553052tons
top510560682top_
tope65946382tope
topes76941762topes
toph96326872toph
tophs105220052tophs
topi67830392topi
topis76025832topis
topo66932402topo
topos75726392topos
tors46157382tors
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
tups65628762tups
umps85721942umps
ups55629052_ups
urps66920472urps
voes75432822voes
vows106626942vows
waps96642082waps
whops135013932whops
woes76440662woes
wogs86531402wogs
woks116224902woks
wons74942042wons
woops104917522woops
woos76238802woos
wop87145132wop_
wos66953532wo_s
wots76342892wots
wows104633492wows
yaps95933522yaps
yeps95924402yeps
yips95226692yips
yobs96028082yobs
yods86531182yods
yoks116223742yoks
yous76230652yous
yows106433122yows
yups96121602yups
zaps156826892zaps
zeps156019342zeps
zips155723792zips
zoos135828802zoos

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.0762351197.4
2DLD Change Limit298725100.81336742.9
3Display Results5105100.1104636.4
 (SQL Overall)1786915100.999178869.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.