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

392 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
kops10703129(None) 
bops86037981bops
cops86751371cops
fops96532681fops
hops97942631hops
keps106027301keps
kips106430511kips
knops115911811knops
koas85635091koas
kobs105831081kobs
kois85129391kois
kop97440201kop_
koph135816541koph
kophs145010931kophs
kors85933011kors
kos76944821ko_s
koss85224811koss
lops66043351lops
mops85940131mops
oops65232671oops
ops56641251_ops
pops86340951pops
sops65244561sops
tops66248121tops
wops96634151wops
alps65529242alps
amps86230342amps
apos65433822apos
apps86319692apps
asps65622092asps
baps86040842baps
boas66150832boas
bobs86340642bobs
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
hots78349322hots
hows106345602hows
hoys107733932hoys
hyps125418412hyps
ikons96311012ikons
imps86221112imps
ions46737852ions
jobs136529432jobs
joes116635892joes
jogs127129332jogs
joss115925592joss
jots116336142jots
jows146632092jows
joys146624662joys
kaas86531842kaas
kabs107130842kabs
kaes85734062kaes
kafs116423742kafs
kaons95014852kaons
kapa106021292kapa
kapas116021732kapas
kaph135815752kaph
kaphs144911502kaphs
kas77058582k_as
kats85944332kats
kays116032192kays
keas86337092keas
keeps116020282keeps
kefs115922742kefs
kegs95824012kegs
kelps115116422kelps
kemps135012522kemps
kens85435232kens
kep96437202kep_
kepi105315632kepi
kepis115313362kepis
kept106232942kept
keys116322162keys
khis117017982khis
kids96029632kids
kifs116023502kifs
kins85747902kins
kip97042132kip_
kirs85831732kirs
kis78051472k_is
kiss85227392kiss
kits86441762kits
knaps115511172knaps
knobs11519712knobs
knop107116592knop_
knosp11576822knosp
knosps12405012knosps
knots95614722knots
knows124912412knows
koa76737772ko_a
koan85425032koan
koans95818622koans
kob99442382ko_b
kobo107422102kobo
kobos115616892kobos
koel84519942koel
koels94613902koels
kohl113911712kohl
kohls12437802kohls
koi77534742ko_i
koji155611112koji
kojis16468432kojis
kola85124962kola
kolas94822232kolas
kolo87026222kolo
kolos94921212kolos
konk79320612konk
konks84917112konks
kook75822602kook
kooks85217262kooks
kopek1037812kopek
kopeks1134602kopeks
kopje1835272kopje
kopjes1935362kopjes
koppa13397292koppa
koppas14407602koppas
kor76538892ko_r
kora86431552kora
koras95927112koras
kore85834162kore
koto86323462koto
kotos95717692kotos
kris86423602kris
kues86426772kues
kvas117015942kvas
kyes115124932kyes
laps66848872laps
lips67141442lips
lobs66441082lobs
logs57343112logs
loops75723962loops
loos49051122loos
lop58255312lop_
lope65941922lope
lopes76437342lopes
loss45337962loss
lots47652092lots
loups75319622loups
lows75843012lows
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
okas85225392okas
okes84936342okes
oms56337512_oms
ons36148512_ons
oohs75220692oohs
oots46446442oots
op45850162_op_
ope56845242_ope
opes65942612_opes
opt57545542_opt
opts68124742_opts
opus66420592_opus
ors35750112_ors
os211359882_o_s
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
shops104222892shops
sips65740102sips
skeps115614252skeps
skips115616602skips
slops75026012slops
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.0602978183.3
2DLD Change Limit298723920.87634100.5
3Display Results3923920.0934215.1
 (SQL Overall)1786913921.029173655.0
 
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.