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

278 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
corers8523107(None) 
borers85122681borers
carers85133961carers
coders95426981coders
comers105328081comers
cooers84324561cooers
copers104629841copers
corders104520881corders
corer75538871corer_
cores76361851core_s
corkers134118851corkers
corners94723311corners
covers114627961covers
cowers114625531cowers
curers84923191curers
scorers94115321scorers
adorers84411732adorers
airers64922312airers
boners84825432boners
borders104317532borders
boreas85421732boreas
borer75131272borer_
bores76448252bore_s
bowers115523702bowers
boxers155013482boxers
cabers105023922cabers
cagers95624192cagers
caners84629202caners
capers105428142capers
carders104820352carders
careers95218782careers
carer74942332carer_
cares77369182care_s
caress85720262caress
carets85330772carets
carpers114521252carpers
carrs75730852car_rs
carters95327252carters
carvers124817542carvers
caters85336502caters
cavers115026842cavers
ceders93817672ceders
ceres75540012cere_s
cereus85215522cereus
cheers114518912cheers
chokers164311522chokers
cholers124215202cholers
choreas124414202choreas
chores114828022chore_s
ciders94620092ciders
cires74932912cire_s
citers85022982citers
cloners94514822cloners
closers94415322closers
clovers125114662clovers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
cobbers134114752cobbers
cockers153618332cockers
codders114114452codders
codecs115112932codecs
codens94821012codens
coder86134222coder_
codes86247292code_s
codgers115113932codgers
coeds85920162co_eds
coercers1237652coercers
coffers154112692coffers
coheirs1236752coheirs
cohere112716992cohere
coherers132310732coherers
coheres122917692coheres
coilers93619902coilers
coiners93620752coiners
coirs75221052co_irs
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
colorers10312182colorers
colors86622372colors
colters93522442colters
combers134516622combers
comer95832692comer_
comes97246992come_s
comets105823582comets
cones76457422cone_s
coneys115218422coneys
confers124120092confers
congers104223232congers
conkers133721042conkers
conners94023112conners
cooees85621892cooees
cooer74831012cooer_
cooeys114914482cooeys
cookers134619462cookers
coolers93522492coolers
coopers114019482coopers
cooters94525722cooters
copens106119962copens
coper95336092coper_
copes97747102cope_s
copiers114215962copiers
coppers133519752coppers
copters113621282copters
corals85325142corals
corbels113813592corbels
corder94322882corder_
cords86030622cor_ds
core67263112core__
cored85044222core_d
corgis9314412corgis
corker124720852corker_
corks116028272cor_ks
cormels113813372cormels
corms95626222cor_ms
corneas94717002corneas
cornels94716662cornels
corner84625622corner_
cornets94820572cornets
corns76034762cor_ns
cornus84816562cornus
coroners104016222coroners
corps95927042cor_ps
corpus106015292corpus
cors66656442co__rs
corses84433462corses
corsets94819802corsets
corulers1039772corulers
corvees124613792corvees
corves115122522corves
corvets124715022corvets
cosecs105015212cosecs
coses76949492cose_s
cosets85824402cosets
coseys115215812coseys
coshers123618182coshers
costers94128332costers
cotes76347842cote_s
cotters94323442cotters
couriers103213172couriers
coursers104412302coursers
courters103015372courters
couters93827302couters
covens114919262covens
cover105430772cover_
coverers132712122coverers
covert114925502covert
coverts124813812coverts
coves105539172cove_s
covets114819642covets
coveys145413502coveys
cower104531772cower_
coxes145430862coxe_s
coyer105222842coyer_
cozens176314922cozens
cozes166033242coze_s
cozeys204610912cozeys
creds85418772c_reds
cress75022832c_ress
crews105917502c_rews
criers83918582criers
crores86121162crore_s
crowers124614902crowers
crozers184111082crozers
cubers105318352cubers
curbers115514382curbers
curer75030752curer_
cures75645432cure_s
curets84922342curets
curlers94218072curlers
currs75624392cur_rs
cursers94317162cursers
cyders12398832cyders
darers75921872darers
doers65225712do_ers
dopers95522482dopers
dormers104313922dormers
dorpers104113172dorpers
dorrs65520592dor_rs
dorsers83516302dorsers
dosers75723632dosers
doters74423912doters
dowers104523292dowers
dozers164815422dozers
farers95924052farers
firers94922682firers
forcers124215712forcers
fores85847102fore_s
forgers115218182forgers
forkers144615782forkers
formers128217952formers
foyers125413132foyers
goers65520252go_ers
gofers104711512gofers
gomers94116882gomers
goners74420172goners
gores65740372gore_s
gorgers94813642gorgers
hirers94518062hirers
hoers85724922ho_ers
homers114821982homers
honers94324972honers
hopers114222972hopers
hosers95223972hosers
hovers124320252hovers
jokers175511192jokers
loners64225812loners
lopers84424142lopers
lores55045402lore_s
losers65123582losers
lovers94223432lovers
lowers94624922lowers
lurers64217492lurers
mopers104220372mopers
morels84820022morels
mores76249642more_s
movers115117192movers
mowers113219402mowers
noters64021002noters
ochers113915302ochers
ockers123813902ockers
omers76923192_omers
orders74315992_orders
ores46056682_ore_s
ormers84316142_ormers
overs85224792_overs
oyers87620882_oyers
parers85530742parers
pokers124617922pokers
polers84225642polers
pores75849032pore_s
porkers134314932porkers
porters93722702porters
posers84223972posers
pourers93513672pourers
powers113822322powers
roarers73812742roarers
rogers74517912rogers
ropers84325902ropers
rovers95423522rovers
rowers94924572rowers
scarers94618512scarers
scorer84818262scorer_
scores84725922score_s
scorners10228492scorners
scoters93313812scoters
scourers10348532scourers
snorers74313802snorers
soarers74118092soarers
sobers85218862sobers
sorels63921162sorels
sorer56236592sorer_
sores55454282sore_s
sorners73416872sorners
sorters74221132sorters
sowers94923442sowers
storers75018682storers
tokers104818892tokers
toners64128002toners
topers85025322topers
torero6313202torero
toreros7311342toreros
tores55352672tore_s
torrs53923562tor_rs
toters65026362toters
tourers73512742tourers
towers94423672towers
toyers95516332toyers
vomers115614942vomers
voters95017442voters
vowers124317182vowers
wirers94617892wirers
wooers93712442wooers
workers144612692workers
wormers124012572wormers
yores85031322yore_s
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 Limit825512782.31035736.4
3Display Results2782780.0803475.0
 (SQL Overall)1786912782.73365382.7
 
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.