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

263 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
copers10462984(None) 
capers105428141capers
coders95426981coders
comers105328081comers
cooers84324561cooers
coopers114019481coopers
copens106119961copens
coper95336091coper_
copes97747101cope_s
copiers114215961copiers
coppers133519751coppers
copters113621281copters
corers85231071corers
covers114627961covers
cowers114625531cowers
dopers95522481dopers
hopers114222971hopers
lopers84424141lopers
mopers104220371mopers
ropers84325901ropers
topers85025321topers
apers76629132_apers
aspers86220312aspers
boners84825432boners
boppers133911922boppers
borers85122682borers
bowers115523702bowers
boxers155013482boxers
cabers105023922cabers
cagers95624192cagers
campers134220292campers
caners84629202caners
caper94831622caper_
capes95441922cape_s
cappers134419402cappers
carers85133962carers
carpers114521252carpers
caters85336502caters
cavers115026842cavers
ceders93817672ceders
cepes94424462cepe_s
cheers114518912cheers
chokers164311522chokers
cholers124215202cholers
chompers17369592chompers
choppers174110462choppers
ciders94620092ciders
ciphers14379992ciphers
citers85022982citers
cloners94514822cloners
closers94415322closers
clovers125114662clovers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
cobbers134114752cobbers
cockers153618332cockers
codders114114452codders
codecs115112932codecs
codens94821012codens
coder86134222coder_
codes86247292code_s
codgers115113932codgers
coeds85920162co_eds
coffers154112692coffers
coheirs1236752coheirs
cohere112716992cohere
coheres122917692coheres
coilers93619902coilers
coiners93620752coiners
coirs75221052co_irs
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
colors86622372colors
colters93522442colters
combers134516622combers
comer95832692comer_
comes97246992come_s
comets105823582comets
compeers143410012compeers
compels133210882compels
compere134616622compere
comperes143217972comperes
cones76457422cone_s
coneys115218422coneys
confers124120092confers
congers104223232congers
conkers133721042conkers
conners94023112conners
cooees85621892cooees
cooer74831012cooer_
cooeys114914482cooeys
cookers134619462cookers
coolers93522492coolers
cooper104221122cooper_
coopery143910272coopery
cooters94525722cooters
copals105018942copals
copays134911272copays
cope86847382cope__
copeck1636942copeck
copecks1745872copecks
coped105036842cope_d
copen94826432cope_n
copier103722892copier_
copies104130302copies
copper124321892copper_
copperas14308572copperas
coppery16409392coppery
coppra12306832coppra
coppras13327832coppras
copra98115462cop_ra
copras103517152copras
cops86751372cop__s
copses104922472copses
copter109822012copter_
corders104520882corders
corer75538872corer_
cores76361852core_s
corkers134118852corkers
corners94723312corners
cors66656442co__rs
cosecs105015212cosecs
coses76949492cose_s
cosets85824402cosets
coseys115215812coseys
coshers123618182coshers
costers94128332costers
cotes76347842cote_s
cotters94323442cotters
coupes105022522coupe_s
couplers123311322couplers
couters93827302couters
covens114919262covens
cover105430772cover_
covert114925502covert
coverts124813812coverts
coves105539172cove_s
covets114819642covets
coveys145413502coveys
cower104531772cower_
cowpeas1437272cowpeas
coxes145430862coxe_s
coyer105222842coyer_
cozens176314922cozens
cozes166033242coze_s
cozeys204610912cozeys
criers83918582criers
croppers143311482croppers
crowers124614902crowers
crozers184111082crozers
cubers105318352cubers
cupels10310202cupels
cuppers133712212cuppers
curers84923192curers
cyders12398832cyders
cyphers17316752cyphers
cypres1338522cypres
doers65225712do_ers
doper86128392doper_
dopes84935042dope_s
dorpers104113172dorpers
dosers75723632dosers
doters74423912doters
dowers104523292dowers
dozers164815422dozers
dupers94615602dupers
elopers95112942elopers
foyers125413132foyers
gapers94520472gapers
goers65520252go_ers
gofers104711512gofers
gomers94116882gomers
goners74420172goners
gophers1338982gophers
gropers104813852gropers
hoers85724922ho_ers
homers114821972homers
honers94324972honers
hoopers123616482hoopers
hoper105829142hoper_
hopes105835642hope_s
hoppers143115142hoppers
hosers95223962hosers
hovers124320252hovers
hypers144811912hypers
japers154616172japers
jokers175511192jokers
kopeks1134602kopeks
lepers84817322lepers
loners64225812loners
loopers93914032loopers
loper75129232loper_
lopes76437342lope_s
loppers113014102loppers
losers65123582losers
lovers94223432lovers
lowers94624922lowers
mopeds11499662mopeds
moper94925922moper_
mopery135210972mopery
mopes95134982mope_s
moppers133412462moppers
movers115117192movers
mowers113219402mowers
noters64021002noters
ochers113915302ochers
ockers123813902ockers
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
scoopers124210192scoopers
scopes104719592scope_s
scorers94115322scorers
scoters93313812scoters
slopers94213092slopers
soapers93715922soapers
sobers85218862sobers
sopors85215202sopors
sowers94923442sowers
stopers94217372stopers
supers84622402supers
tapers84025812tapers
tokers104818892tokers
toners64128002toners
topees85519702topees
toper75231022toper_
topes76941762tope_s
toppers113914602toppers
toters65026362toters
towers94423672towers
toyers95516332toyers
uppers102912292uppers
vipers114914532vipers
vomers115614942vomers
voters95017442voters
vowers124317182vowers
wipers115416082wipers
wooers93712442wooers
zoners155115992zoners

Search took 3 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.343520965.0
2DLD Change Limit825512632.31335690.0
3Display Results2632630.0803287.5
 (SQL Overall)1786912632.73665311.0
 
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.