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

404 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
wops9663415(None) 
bops86037981bops
cops86751371cops
fops96532681fops
hops97942631hops
kops107031291kops
lops66043351lops
mops85940131mops
oops65232671oops
ops56641251_ops
pops86340951pops
sops65244561sops
swops105913971swops
tops66248121tops
waps96642081waps
whops135013931whops
woes76440661woes
wogs86531401wogs
woks116224901woks
wons74942041wons
woops104917521woops
woos76238801woos
wop87145131wop_
wos66953531wo_s
wots76342891wots
wows104633491wows
alps65529242alps
amps86230342amps
apos65433822apos
apps86319692apps
asps65622092asps
awols84713522awols
baps86040842baps
boas66150832boas
bobs86340652bobs
bods76244712bods
bogs75742752bogs
boos67955032boos
bop77549482bop_
bos57966812bo_s
boss65938342boss
bots66453952bots
bows96242862bows
boys96737332boys
caps87147892caps
ceps86125952ceps
chops125019872chops
clops95924852clops
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
eons46638712eons
epos66723732epos
flops105920142flops
fobs96034272fobs
foes76543442foes
fogs87035002fogs
fons76943892fons
fop86743702fop_
foss76431642foss
foys105628292foys
gaps76042972gaps
gips75632922gips
glops85619552glops
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
hots78349332hots
hows106345602hows
hoys107733932hoys
hyps125418412hyps
imps86221122imps
ions46737852ions
jobs136529432jobs
joes116635892joes
jogs127129332jogs
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
keps106027302keps
kips106430512kips
knops115911812knops
koas85635092koas
kobs105831082kobs
kois85129402kois
kop97440202kop_
koph135816542koph
kophs145010932kophs
kors85933012kors
kos76944822ko_s
koss85224812koss
laps66848872laps
lips67141442lips
lobs66441082lobs
logs57343112logs
loops75723962loops
loos49051122loos
lop58255312lop_
lope65941922lope
lopes76437342lopes
loss45337962loss
lots47652092lots
loups75319622loups
lows75843012lows
maps86141052maps
mips85534082mips
moas65545342moas
mobs85737372mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
moms86539482moms
mons68152262mons
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
oms56337512_oms
ons36148512_ons
oohs75220692oohs
oots46446442oots
op45850162_op_
ope56845242_ope
opes65942612_opes
opt57545542_opt
opts68124742_opts
opus66420592_opus
ors35750112_ors
os211359882_o_s
owes75137102owes
owls76022932owls
owns76819582owns
paps86443452paps
peps85134512peps
pips85837132pips
plops95920332plops
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
shops104222902shops
sips65740102sips
slops75026012slops
soaps75120712soaps
sobs64941752sobs
sods54940212sods
sols45448162sols
soms66239372soms
sons46049552sons
sop57557862sop_
soph97024202soph
sophs104916022sophs
sos37761602so_s
sots45552452sots
soups75322942soups
sous46947212sous
sows75342492sows
soys75233932soys
stops74827282stops
sups64834432sups
swaps104819202swaps
swobs104910892swobs
swoops114910922swoops
swop95120502swop_
swots85518432swots
taps66050672taps
tips66436762tips
tods56141842tods
toes46956442toes
togs57242432togs
toms68343492toms
tons46553052tons
top510560682top_
tope65946382tope
topes76941762topes
toph96326872toph
tophs105220052tophs
topi67830392topi
topis76025832topis
topo66932402topo
topos75726392topos
tors46157382tors
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
tups65628762tups
twos76718022two_s
umps85721942umps
ups55629052_ups
urps66920472urps
voes75432822voes
vows106626942vows
wabs97337232wabs
wads87343142wads
waes76048602waes
wags86140552wags
wans76452272wans
wap86553372wap_
warps107126422warps
wars78659802wars
was68767562w_as
wasp95626852wasp
wasps106714692wasps
wats77555882wats
waws106834902waws
ways107737952ways
webs96622122webs
weds86628932weds
weeps104120562weeps
wees76249122wees
wens76337932wens
wept95635052wept
wets75940292wets
whaps135115162whaps
whips134917082whips
whomps16457602whomps
whoops14487862whoops
whop125520922whop_
whups134210002whups
whys137011662whys
wigs84931252wigs
wimps125213802wimps
wins75949172wins
wipe94830282wipe
wipes104827082wipes
wis66552332w_is
wisp97124072wisp
wisps105214182wisps
wiss75630542wiss
wits76044872wits
wo510447762wo__
woad85523942woad
woads94818442woads
woe66651242wo_e
wog76242732wo_g
wok106334172wo_k
woke115527962woke
wold85429072wold
wolds95420182wolds
wolf105729562wolf
wolfs116214162wolfs
womb117022232womb
wombs125813342wombs
won66252062wo_n
wonk116125302wonk
wonks124818342wonks
wont75842502wont
wonts87621542wonts
woo66949802wo_o
wood85329382wood
woods95723032woods
woof106532422woof
woofs114918002woofs
wool76427372wool
wools84421462wools
woosh113710732woosh
word89832002word
words95425072words
wore77144672wore
work115528842work
works125621902works
worm96129482worm
worms105320762worms
worn75631752worn
worse86525262worse
worst86330132worst
wort76654752wort
worts88631182worts
wost76544362wost
wot610467482wo_t
wove105624312wove
wow96643472wo_w
wraps105617152wraps
wuss75219332wuss
wyes105727502wyes
wyns105717032wyns
yaps95933522yaps
yeps95924402yeps
yips95226702yips
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.1401276364.3
2DLD Change Limit298724041.11026911.7
3Display Results4044040.0934344.1
 (SQL Overall)1786914041.343133053.6
 
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.