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

194 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
mopers10422037(None) 
copers104629841copers
dopers95522481dopers
hopers114222971hopers
lopers84424141lopers
mopeds11499661mopeds
moper94925921moper_
mopery135210971mopery
mopes95134981mope_s
moppers133412451moppers
movers115117191movers
mowers113219401mowers
ropers84325901ropers
topers85025321topers
apers76629132_apers
aspers86220312aspers
boners84825432boners
boppers133911922boppers
borers85122682borers
bowers115523702bowers
boxers155013482boxers
capers105428132capers
coders95426972coders
comers105328082comers
cooers84324562cooers
coopers114019482coopers
copens106119962copens
coper95336092coper_
copes97747102cope_s
copiers114215962copiers
coppers133519752coppers
copters113621272copters
corers85231072corers
covers114627962covers
cowers114625532cowers
doers65225712do_ers
doper86128392doper_
dopes84935042dope_s
dorpers104113162dorpers
dosers75723632dosers
doters74423912doters
dowers104523292dowers
dozers164815422dozers
dupers94615602dupers
elopers95112942elopers
emoters94712872emoters
foyers125413132foyers
gapers94520462gapers
goers65520252go_ers
gofers104711512gofers
gomers94116882gomers
goners74420162goners
gophers1338982gophers
gropers104813852gropers
hoers85724922ho_ers
homers114821972homers
honers94324972honers
hoopers123616482hoopers
hoper105829142hoper_
hopes105835642hope_s
hoppers143115142hoppers
hosers95223952hosers
hovers124320252hovers
hypers144811912hypers
japers154616172japers
jokers175511192jokers
kopeks1134602kopeks
lepers84817322lepers
loners64225802loners
loopers93914032loopers
loper75129232loper_
lopes76437342lope_s
loppers113014102loppers
losers65123582losers
lovers94223432lovers
lowers94624922lowers
macers105321272macers
makers123921732makers
mappers133313772mappers
masers84623452masers
maters85032382maters
mazers173917092mazers
meters85625832meters
milers84625162milers
mimers105520182mimers
miners84126632miners
misers85025702misers
miters84328772miters
mixers154513562mixers
moaners92813552moaners
mobbers133610922mobbers
mockers153812942mockers
models94216352models
modems114610762modems
modern939522modern
moderns1037962moderns
modes85537412mode_s
mohels115011322mohels
mohurs1135932mohurs
moilers93615202moilers
moires8915632moires
mokes114631032moke_s
molars85517322molars
molders103315552molders
moles74747922mole_s
molters93816972molters
momes95134472mome_s
momsers113810842momsers
momzers20367132momzers
moneys115513622moneys
mongers104217272mongers
mooners94015342mooners
moors74923142mo_ors
mooters93818622mooters
mope86838042mope__
moped105424732mope_d
moperies12313872moperies
mopey124821822mope_y
mopier103914782mopier_
mopper126215002mopper_
moppets13307162moppets
mops85940132mop__s
morels84820012morels
mores76249642more_s
mors65950062mo__rs
moseys114711702moseys
moshers124017842moshers
mossers94116192mossers
motels83616892motels
motes75944002mote_s
motets84216192motets
mothers123717622mothers
motors84616592motors
moues75732842moue_s
mousers95216442mousers
mover104220862mover_
moves106128422move_s
mower104523452mower_
mumpers133311362mumpers
musers84719092musers
myopes13419962myope_s
noters64020992noters
ombers104214392ombers
omers76923192_omers
opens76118552_opens
opera7313572_opera
operas8312452_operas
opes65942612_ope_s
overs85224792_overs
oyers87620882_oyers
papers105125322papers
pipers104318662pipers
pokers124617922pokers
polers84225642polers
popery134511702popery
popes95933812pope_s
poppers103414862poppers
posers84223972posers
powers113822322powers
propers113619032propers
rapers84327182rapers
rogers74517912rogers
rompers113412242rompers
roper75431912roper_
ropery114313872ropery
ropes75940062rope_s
rovers95423522rovers
rowers94924572rowers
slopers94213092slopers
smokers13389322smokers
soapers93715922soapers
sobers85218852sobers
sopors85215192sopors
sowers94923432sowers
stopers94217362stopers
supers84622402supers
tapers84025812tapers
tokers104818892tokers
toners64128002toners
topees85519702topees
toper75231022toper_
topes76941762tope_s
toppers113914602toppers
toters65026362toters
towers94423672towers
toyers95516332toyers
uppers102912282uppers
vipers114914532vipers
vomers115614942vomers
voters95017442voters
vowers124317182vowers
wipers115416082wipers
wooers93712442wooers
zoners155115992zoners

Search took 5 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 Filter178691825510.1701051123.5
2DLD Change Limit825511943.42324116.6
3Display Results1941940.1231577.2
 (SQL Overall)1786911943.71648086.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.