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

399 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
ceres7554001(None) 
cares77369181cares
cedes84927321cedes
cees65941591ce_es
cepes94424461cepes
cere66741471cere_
cered85227441cered
cereus85215521cereus
ceros74726071ceros
certes84623081certes
cetes75731101cetes
cires74932911cires
cores76361851cores
cures75645431cures
feres86038181feres
heres86245901heres
meres75143571meres
peres76246641peres
seres55448891seres
acres76327762acres
aedes64625142aedes
aeries64737782aeries
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
beers75628392beers
bees65453382be_es
benes75536232benes
beret74946362beret
berets85822522berets
bergs84718042bergs
berks115423122berks
bermes106023002bermes
berms95323662berms
beses75830722beses
bores76448252bores
brees75632552brees
byres104421382byres
cades85440732cades
cadres94017932cadres
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
carbs96031462carbs
cards85137932cards
care66968372care_
cared86050092cared
carer74942332carer
carers85133962carers
caress85720262caress
caret75360562caret
carets85330772carets
carex144822302carex
caries85147622caries
carks115534212carks
carles85435082carles
carls77037422carls
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762car_s
carse74934332carse
carses85233652carses
cartes86239472cartes
carts78946292carts
carves115128452carves
cases75048382cases
cates75951892cates
caves105639702caves
cease75227652cease
ceases84427072ceases
cede74928762cede_
ceded96118552ceded
ceder85322232ceder
ceders93817672ceders
cedis84317082cedis
cee55952702ce_e_
ceils75019402ceils
celeb9314872celeb
celebs1037882celebs
cells75428062cells
cels65534972ce_ls
celts75325782celts
cense75121402cense
censes83721802censes
centres93817122centres
cents74730332cents
ceorls848162ceorls
cepe84926652cepe_
ceps86125952ce_ps
cerates95428252cerates
cerci93716392cerci
cercis104614492cercis
cercus105013152cercus
cereal8315832cereal
cereals9313172cereals
ceria75125352ceria
cerias83321982cerias
ceric94023092ceric
cerise84822042cerise
cerises94722252cerises
cerites94823432cerites
cermet10321152cermet
cermets1139712cermets
cero66329452cer_o
cerous85821202cerous
ceruse83914522ceruse
ceruses93716232ceruses
cess65326052ce_ss
cesses84221362cesses
cete64934782cete_
chares115631802chares
cheers114518912cheers
cherts115617232cherts
chevres15379792chevres
chores114828022chores
cines75239682cines
cire65836372cire_
cites74435592cites
clepes104214622clepes
clerks12458842clerks
clues74623032clues
codes86247292codes
coerces11311942coerces
coheres122917692coheres
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cords86030622cords
core67263112core_
cored85044222cored
corer75538872corer
corers85231072corers
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
corse75036182corse
corses84433462corses
corves115122522corves
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
cred76530882c_red
creds85418772creds
creed85727392creed
creeds94714772creeds
creek114917392creek
creeks124812922creeks
creel75121482creel
creels84416942creels
creep95218102creep
creeps104213622creeps
creese84014332creese
creesh11328332creesh
cremes104517992cremes
crepes105419342crepes
cress75022832cress
crest74632692c_rest
crew96122672c_rew
crews105917492crews
cries75438402cries
cris66233432c_ris
crores86121162crores
crus65828482c_rus
cubes95028162cubes
cues65438982c_ues
cukes115422092cukes
curbs94821652curbs
curds85725612curds
cure66149122cure_
cured85932132cured
curer75030752curer
curers84923192curers
curet75447642curet
curets84922342curets
curfs105122142curfs
curies84934022curies
curls74927102curls
curns74924272curns
currs75624392currs
curs65645542cur_s
curse75829142curse
curses85328272curses
curves114619282curves
cutes79438322cutes
cyeses11510122cyeses
cymes1210118922cymes
cypres1338522cypres
dares66146702dares
deers64930522deers
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dere56845902dere_
derms85022892derms
dexes135224512dexes
drees65628522drees
dures65635922dures
eches106322162eches
ecrus75113862ecrus
ekes86726602_ekes
emes65434662_emes
eras45441502_eras
ere36352772_ere_
ergs55523812_ergs
ernes55224812_ernes
erns45428222_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
erses55826802_erses
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
eyres84921772eyres
fares85852872fares
feces105625362feces
fees76450602fe_es
femes105626222femes
fere76342232fere_
ferns85220082ferns
fetes85630142fetes
fezes175220022fezes
fires85740752fires
fores85847102fores
frees86131392frees
freres94716172freres
gees55647882ge_es
genes65133092genes
genres75515622genres
germs85118872germs
gores65740372gores
grees65132472grees
gyres94820322gyres
haeres94017032haeres
hares86255542hares
hebes105521672hebes
hemes105031082hemes
herbs105520502herbs
herds96424682herds
here76447102here_
heresy125011232heresy
herls85226432herls
herms105626432herms
herns84825582herns
heroes94923822heroes
heros84930862heros
herpes115517322herpes
hers75844872her_s
hexes155123042hexes
hires86134342hires
ires45639282_ires
jeers124818132jeers
jees115938542je_es
jefes155613672jefes
jerks166514892jerks
jetes124922842jetes
kerbs115013672kerbs
kerfs125413572kerfs
kermes124616122kermes
kernes104717522kernes
kerns94719562kerns
kexes166216812kexes
lares54852632lares
leers54828982leers
lees45455882le_es
leges64427282leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
lores55045402lores
lures56138532lures
lyres85019962lyres
mares76457632mares
memes94927702memes
merces105720742merces
mercs96020452mercs
merdes94518602merdes
mere67244442mere_
merer75126232merer
merest84725112merest
merges94122482merges
merks114722402merks
merles85322762merles
merls77423902merls
metes74736212metes
metres85121562metres
mezes167719262mezes
mires75640882mires
mores76249642mores
mures75937212mures
nares55544152nares
nenes55329672nenes
nerds65719252nerds
nereis6315342nereis
nerts55924982nerts
nerves94216192nerves
neves87021872neves
ochres113510832ochres
ogres65818632ogres
ores46056682_ores
pares77164482pares
pedes85327282pedes
peers75130272peers
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
pere66450262pere_
perea75026442perea
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
pervs105117372pervs
pores75849032pores
prees75937172prees
pyres105523882pyres
rares55247442rares
redes65139122redes
rees45364192re_es
reges65628782reges
res35565042__res
rexes124526952rexes
scares85033002scares
scenes84520352scenes
scores84725922scores
screes85023962screes
seers55136382seers
sees45361052se_es
semes75731582semes
sere46153472sere_
sered65737292sered
serer55935502serer
serest64831612serest
serfs84922012serfs
serges74225962serges
series64540972series
sers45746652ser_s
serves94423652serves
sexes126126222sexes
sires55945372sires
sores55454282sores
steres63929532steres
tares57456562tares
tees45353582te_es
teles54536002teles
terces83921412terces
terms75523472terms
ternes65422902ternes
terns55226872terns
terse55026822terse
theres96525472theres
tires55437492tires
tores55352672tores
trees55835762trees
tres46542902_tres
tyres84725232tyres
veers84521362veers
vees75439432ve_es
veges94118862veges
verbs104614392verbs
verges104320172verges
vermes115019142vermes
verse84723582verse
verses94223762verses
verts85724732verts
verves124617882verves
vexes155719122vexes
vires84529682vires
wares88250582wares
wees76249122we_es
were76238332were_
wheres125917432wheres
wires86034912wires
xerus12313332xerus
yerks125416562yerks
yeses85119322yeses
yores85031322yores
zees136331892ze_es
zerks185113822zerks
zeroes154314342zeroes
zeros144918112zeros

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 Filter178691538000.0931921408.6
2DLD Change Limit538003991.65632487.9
3Display Results3993990.2161847.2
 (SQL Overall)1786913991.96590936.9
 
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.