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

349 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
cere6674147(None) 
care66968371care
cede74928771cede
cee55952701ce_e
cepe84926651cepe
cered85227441cered
ceres75540011ceres
cero66329451cero
cete64934781cete
cire65836371cire
core67263111core
cure66149121cure
dere56845901dere
ere36352771_ere
fere76342231fere
here76447101here
mere67244441mere
pere66450261pere
sere46153471sere
were76238331were
acerb9312762acerb
acre67330772acre
aerie54634602aerie
aero45435342aero
aery77231682aery
are37874572_are
bare65460522bare
bee56262402be_e
beer65635992beer
bene66439492bene
beret74946362beret
berg75425542berg
berk105929842berk
berm86732752berm
berme96022942berme
bore66051332bore
bree67241262bree
byre95023852byre
cade76443912cade
cadre85419022cadre
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
cane66653122cane
cape87242782cape
car59165562car_
carb85143162carb
card710245872card
cared86050092cared
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
cark105539272cark
carl65144782carl
carle74535702carle
carn66245432carn
carp85139812carp
carr65434702carr
cars67364762cars
carse74934332carse
cart66570342cart
carte75940422carte
carve106227752carve
case65848082case
cate66254602cate
cave95941262cave
cease75227652cease
ceca84820782ceca
ceded96118562ceded
ceder85322242ceder
cedes84927332cedes
cedi74919272cedi
cees65941592cees
ceil65725062ceil
cel56040552ce_l
celeb9314872celeb
cell65031722cell
cels65534972cels
celt65646712celt
cense75121402cense
cent67451012cent
centre84316642centre
ceorl7410922ceorl
cep75736332ce_p
cepes94424462cepes
ceps86125952ceps
cerate84829462cerate
cerci93716392cerci
cereal8315832cereal
cereus85215522cereus
ceria75125352ceria
ceric94023092ceric
cerise84822042cerise
cerite84724872cerite
cermet10321152cermet
ceros74726072ceros
certes84623082certes
ceruse83914522ceruse
cess65326052cess
cetes75731102cetes
chare105231982chare
cheer105420382cheer
chert105232102chert
chevre14318312chevre
chore105126762chore
cine66242942cine
cires74932912cires
cite65640342cite
clepe94617382clepe
clerk115812452clerk
clue65324532clue
code77347732code
coerce10310402coerce
cohere112716992cohere
coke107038382coke
cole66956112cole
come87547702come
cone67256962cone
cope86847382cope
cor59960942cor_
cord76740922cord
cored85044222cored
corer75538872corer
cores76361852cores
corf95941482corf
cork106635692cork
corm85735382corm
corn69945812corn
cors66656442cors
corse75036182corse
cory96941512cory
cote66648732cote
cove95837072cove
cred76530882cred
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
creme94319322creme
crepe95520722crepe
crew96122682crew
crore74922872crore
cru57129562c_ru
cry89726242c_ry
cube85830212cube
cue57544182c_ue
cuke105824982cuke
cur56841982cur_
curb86732222curb
curd77634982curd
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curf97538782curf
curie74533042curie
curl66035052curl
curn66731892curn
curr65429652curr
curs65645542curs
curse75829142curse
curt67051712curt
curve104920022curve
cute66440452cute
cyme119420372cyme
dare55848862dare
dee47665822de_e
deer56739022deer
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
derm76031892derm
dire56644142dire
dore56353302dore
dree56638322dree
dure56341812dure
eche97520282eche
ecru65819532ecru
eerie55228532eerie
eery76129622eery
eke75630092_eke
eme55837182_eme
er28345142_er_
era35741502_era
erg45531072_erg
ern35738362_ern
erne46727432_erne
err35626532_err
ers36046282_ers
eve66331162_eve
ewe66630982_ewe
eye65539772_eye
eyre75525252eyre
fare76354462fare
fee66862012fe_e
feme96130542feme
fer66646122fer_
feres86038182feres
fern76129322fern
fete75734922fete
fire76245592fire
fore78351472fore
free75940182free
frere85617722frere
gee45359202ge_e
gene56237222gene
genre66016802genre
germ75428962germ
gore55744962gore
gree56641562gree
gyre84722762gyre
hare76255732hare
hebe96424702hebe
heme95034412heme
her66547812her_
herb94730962herb
herd84933062herd
heres86245902heres
herl75834552herl
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hire75538962hire
ire36943172_ire
jee106648642je_e
jeer115426462jeer
jefe146516882jefe
jerk154920132jerk
jete115927252jete
kerb104322712kerb
kerf115827462kerf
kern85326212kern
kerne94718222kerne
kore85834162kore
lee36068142le_e
leer46239352leer
leke85527402leke
lire47845292lire
lore45850352lore
lure45142462lure
lyre75623792lyre
mare64759332mare
meme85330552meme
merc87225622merc
merde84320122merde
merer75126232merer
meres75143572meres
merge84523692merge
merk106027942merk
merl65830972merl
merle75824372merle
mete64438132mete
metre74821302metre
meze154420902meze
mire66748232mire
more67154522more
mure65941332mure
nee36657782ne_e
nene45932062nene
nerd56624942nerd
nerve86617372nerve
neve76224832neve
ochre103411592ochre
ogre56320742ogre
ore36661832_ore
pare66760842pare
pee56066512pe_e
peer66238352peer
peke105926202peke
pele65539552pele
per56353092per_
perea75026442perea
peres76246642peres
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
perse75429522perse
pert66759322pert
perv97224812perv
pore66451262pore
pree67044732pree
pure65543332pure
pyre94925552pyre
rare45348432rare
re26153742__re
rede55037672rede
ree37974072re_e
rete44944132rete
scare75334462scare
scene77220572scene
score75526742score
scree720031712scree
see35772262se_e
seer45547042seer
seme65836652seme
sene46848052sene
ser36752402ser_
sera46141392sera
sered65737292sered
serer55935512serer
seres55448892seres
serf76340112serf
serge64727472serge
sers45746652sers
serve85425962serve
sire46150412sire
sore47059532sore
stere55328542stere
sure45447412sure
tare45957622tare
tee38366872te_e
tele45040872tele
terce75721842terce
term66233152term
tern46134802tern
terne56426152terne
terse55026822terse
there87527392there
tire46143352tire
tore47359322tore
tree47745812tree
tyre75428252tyre
vee65750182ve_e
veer76229572veer
vera76828842vera
verb96224872verb
verge93419842verge
verse84723582verse
vert77249372vert
verve115417722verve
very108025642very
ware76254722ware
wee66760812we_e
weer75535092weer
wert79749822wert
where117019422where
wire75839812wire
wore77144672wore
yare75636942yare
yerk116222082yerk
yore76335942yore
zee126143232ze_e
zerk175319252zerk
zero134822472zero

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 Filter178691298720.266671770.7
2DLD Change Limit298723490.92332364.0
3Display Results3493490.0764592.1
 (SQL Overall)1786913491.265141257.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.