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

379 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
popes9593381(None) 
copes97747101copes
dopes84935041dopes
hopes105835641hopes
lopes76437341lopes
mopes95134981mopes
opes65942611_opes
pipes96030141pipes
pokes116133011pokes
poles75351001poles
pomes94833931pomes
pones74547041pones
pope85535611pope_
pops86340951pop_s
pores75849031pores
poses74642761poses
poxes145325721poxes
ropes75940061ropes
topes76941761topes
apes66047432_apes
bodes84935102bodes
boles75448602boles
bones76446532bones
bops86037982bop_s
bores76448252bores
boxes145625072boxes
capes95441922capes
cepes94424462cepes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
cope86847382cope_
coped105036842coped
copen94826432copen
copens106119962copens
coper95336092coper
copers104629842copers
copies104130302copies
cops86751372cop_s
copse95623922copse
copses104922472copses
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopas85019062dopas
dope76038892dope_
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dupes86425932dupes
elopes85918162elopes
epodes94315562epodes
epopee10312502epopee
epopees1137232epopees
eposes84418782eposes
foes76543442fo_es
fops96532682fop_s
fores85847102fores
foxes156321092foxes
gapes86030822gapes
goes55644092go_es
gores65740372gores
goxes135018262goxes
gropes95220402gropes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopers114222972hopers
hops97942632hop_s
hoses85443172hoses
howes114730262howes
hypes135818672hypes
japes146322822japes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jupes145218552jupes
kopek1037812kopek
kopeks1134602kopeks
kophs145010932kophs
kopjes1935362kopjes
kops107031292kop_s
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lop_s
lores55045402lores
loses56742012loses
loupes84918052loupes
loves85332012loves
lowes85732462lowes
loxes125227472loxes
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mope86838042mope_
moped105424732moped
mopeds11499662mopeds
moper94925922moper
mopers104220372mopers
mopey124821822mopey
mops85940132mop_s
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
myopes13419962myopes
napes74828462napes
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
nope65934192nope_
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oops65232672oop_s
oozes145418712oozes
ope56845242_ope_
oped76230152_oped
open66427002_open
opens76118552_opens
ops56641252_op_s
opts68124742_opts
opus66420592_opus
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
papas94927492papas
paper95128662paper
papers105125322papers
paps86443452pap_s
pares77164482pares
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
pedes85327282pedes
peeps95822362peeps
pees65257372p_ees
pekes114623562pekes
peles75738082peles
penes75839222penes
peones83821042peones
peoples11312212peoples
pepos96620082pepos
peps85134512pep_s
peres76246642peres
pes57259782__pes
phones114121212phones
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipe86434432pipe_
piped105123162piped
piper96523192piper
pipers104318662pipers
pipet95533322pipet
pipets105714772pipets
pips85837132pip_s
pixes144323172pixes
plies74526512plies
plops95920332plop_s
pocks135022962pocks
pods76540152po_ds
poem86225772po_em
poems95715552poems
poesy105014062po_esy
poet65552902po_et
poets76024442poets
pogey116017892pogey
pogeys124110352pogeys
pogies94123542pogies
pois66539042po_is
poise75127892poise
poises84226542poises
poke105335362poke_
poked125425392poked
poker115122882poker
pokers124617922pokers
pokey145318972pokey
pokeys15529512pokeys
pokies125921332pokies
pole65951302pole_
poled84934842poled
poleis86018352poleis
poler74431792poler
polers84225642polers
polies84034582polies
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pome85636692pome_
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponces104720842ponces
ponds85323402ponds
pone65747532pone_
pongs85526342pongs
ponies84833462ponies
pons65850602po_ns
pontes83627852pontes
poods85124752poods
pooed85226242pooed
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
pooped113915942pooped
poops94422412poops
poos65949112po_os
pooves113914712pooves
pop76252252pop__
popery134511702popery
popish133812112popish
poppa8409892poppa
poppas93710712poppas
popped104117812popped
popper93615962popper
poppers103414862poppers
poppet92717322poppet
poppets10338852poppets
poppies102816192poppies
popples103011872popples
poppy114813192poppy
popsies112816462popsies
popsy125713402popsy
pore66451262pore_
pored85234512pored
porks115124142porks
porns75527342porns
ports75934592ports
pose66441732pose_
posed85828412posed
poser75128772poser
posers84223972posers
posies84431432posies
posse74722272posse
posses85128802posses
posts75228782posts
potpies113116172potpies
pots66452362po_ts
poufs105616062poufs
pours74623182pours
pouts75530322pouts
power105325952power
powers113822322powers
pows95537662po_ws
poxed154817862poxed
prees75937172prees
preps96220692preps
pries74339532pries
probes104119452probes
proles84627202proles
propel103714062propel
propels113412842propels
proper104319952proper
propers113619032propers
props95726882prop_s
proses84733472proses
proves114322252proves
ptoses83514672ptoses
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pupas95219282pupas
pups86032232pup_s
pupus94614042pupus
puses75532202puses
pyes95528992p_yes
pyoses114314302pyoses
pyres105523882pyres
pyropes142210192pyropes
pyxes175911402pyxes
qophs19507812qophs
rapes75740722rapes
ripes75435772ripes
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
rope65542912rope_
roped84630802roped
roper75431912roper
ropers84325902ropers
ropey106021872ropey
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scopes104719592scopes
sipes76036952sipes
slopes84820452slopes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
spodes94817432spodes
spokes124417212spokes
spores84726612spores
stopes84525892stopes
supes75628302supes
tapes75838602tapes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
tope65946382tope_
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
tophes115218422tophes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
tores55352672tores
totes55139682totes
tropes84824352tropes
types105721062types
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wipes104827082wipes
woes76440662wo_es
wops96634152wop_s
yipes106017842yipes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

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 Filter178691538000.1061685764.2
2DLD Change Limit538003791.70331591.3
3Display Results3793790.1103445.5
 (SQL Overall)1786913791.91993116.7
 
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.