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

468 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
seres5544889(None) 
ceres75540011ceres
feres86038181feres
heres86245901heres
meres75143571meres
peres76246641peres
seers55136381seers
sees45361051se_es
semes75731581semes
sere46153471sere_
sered65737291sered
serer55935501serer
serest64831611serest
serfs84922011serfs
serges74225961serges
series64540971series
sers45746651ser_s
serves94423651serves
sexes126126221sexes
sires55945371sires
sores55454281sores
steres63929531steres
acres76327762acres
aedes64625142aedes
aeries64737782aeries
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
beers75628392beers
bees65453382be_es
benes75536232benes
beret74946362beret
berets85822522berets
bergs84718042bergs
berks115423122berks
bermes106023002bermes
berms95323662berms
beses75830722beses
bores76448252bores
brees75632552brees
byres104421382byres
cares77369182cares
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
cere66741472cere_
cered85227442cered
cereus85215522cereus
ceros74726072ceros
certes84623082certes
cetes75731102cetes
cires74932912cires
cores76361852cores
cures75645432cures
dares66146702dares
deers64930522deers
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dere56845902dere_
derms85022892derms
dexes135224512dexes
drees65628522drees
dures65635922dures
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
esnes54817362esnes
esses56422972esses
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
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
sabes76437462sabes
sabres85520862sabres
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sards64736182sards
saree55044662saree
sarees65329942sarees
sarges75128592sarges
saris54544952saris
sarks96632462sarks
saros55238062saros
sates54949322sates
saves85838632saves
saxes125229342saxes
scares85033002scares
scenes84520352scenes
scores84725922scores
scree720031702scree
screes85023962screes
screw109318532screw
screws115513882screws
scries85226822scries
seals54839692seals
seams75731662seams
seared75232842seared
searer65432022searer
searest73322022searest
sears54744912sears
seas45755272se_as
seats54844342seats
secret8325062secret
secrets9311772secrets
secs65033892se_cs
sects75622892sects
secures9613162secures
seder64826752seder
seders74420282seders
sedges83817792sedges
see35772262se_e_
seed55549482se_ed
seeds64330062seeds
seek85935482se_ek
seeks94724642seeks
seel45042982se_el
seels55632822seels
seem65438562se_em
seems75525022seems
seen46943122se_en
seep66540342se_ep
seeps74828752seeps
seer45547042se_er
seeress7311572seeress
segos64919482segos
segs54933882se_gs
segues7412072segues
seifs85019332seifs
seines65029902seines
seis45542392se_is
seise54727852seise
seises64026712seises
seizes154317532seizes
selfs85220242selfs
selles64426982selles
sells55134432sells
sels46345982se_ls
selves94119612selves
seme65836652seme_
semen75724102semen
semens84616962semens
semis74623532semis
sends65528242sends
sene46848052sene_
senores73218112senores
sense55526822sense
senses63923942senses
sepses84515882sepses
septs75420602septs
ser36752402ser__
sera46141392ser_a
serac75925202serac
seracs84418572seracs
serai56830162serai
serais64326132serais
seral56336382seral
serapes95218102serapes
serein63318462serein
sereins73716112sereins
serene63522352serene
serenes73222902serenes
serf76340112ser_f
serge64727462serge
serged84118762serged
serger73819732serger
sergers83815632sergers
serif84132122serif
serifs94017052serifs
serin55434442serin
serines74229542serines
serins64029672serins
serosa6313022serosa
serous65023552serous
serow86720442serow
serows96016392serows
serries73925352serries
serry84824122serry
serum75223472serum
serums83916302serums
serve85425962serve
served104616812served
server94917712server
servers103214832servers
servo84516682servo
servos93812722servos
sets45549502se_ts
setts55124322setts
seven84118312seven
sevens93813662sevens
sever85426052sever
severs94121122severs
sewed95325162sewed
sewer84426212sewer
sewers94719712sewers
sews75836022se_ws
sexed136618542sexed
sexts125118382sexts
shares95236412shares
sheers94322402sheers
sherds105614722sherds
shes75734352s_hes
shies86136552shies
shires95225572shires
shoes85429652shoes
shores94830402shores
shred98125612shred
shreds105613052shreds
shrew119720162shrew
shrews129313912shrews
shris84221442shris
sices75637272sices
sides65838362sides
sieges73816832sieges
sieves93216002sieves
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sire46150412sire_
sired66134282sired
siree55238812siree
sirees64624582sirees
siren54525822siren
sirens65318152sirens
sirs44338332sir_s
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skenes104616632skenes
skies95026832skies
sloes54728872sloes
slues54527172slues
smerks12449712smerks
snares65329032snares
sneers64016172sneers
snores64324312snores
snyes85012752snyes
sokes95031422sokes
soles55547922soles
sones55444142sones
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sore47059532sore_
sored66141782sored
sorel56231442sorel
sorels63921162sorels
sorer56236572sorer
sorest65027992sorest
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
spaes76029972spaes
spares84834552spares
speers85019952speers
sperms102512602sperms
spheres123114352spheres
spies76037622spies
spires84628112spires
spores84726612spores
spree74830862spree
sprees85620642sprees
sprues84515762sprues
spues75025382spues
sris45434152s_ris
stares66038752stares
steers63820982steers
steles63725662steles
stere55328542stere_
stereo65317912stereo
stereos74314972stereos
sterns64616752sterns
sties55132982sties
stores65533642stores
strep77120852strep
streps86218062streps
stress66616672stress
strew89220652strew
strews96817092strews
styes86316522styes
sucres84218892sucres
suedes73918112suedes
suers55128482suer_s
sues46247652s_ues
supes75628302supes
suras55336322suras
surds65624662surds
sure45447412sure_
surer54833092surer
surest65026762surest
surfs85022542surfs
surges73924592surges
swedes102711892swedes
swerves1377532swerves
syces106416462syces
sykes124816862sykes
syren85216742syren
syrens94911992syrens
tares57456562tares
tees45353582te_es
teles54536002teles
terces83921412terces
terms75523472terms
ternes65422902ternes
terns55226872terns
terse55026822terse
theres96525472theres
tires55437492tires
tores55352672tores
trees55835762trees
tres46542902_tres
tsores65113662tsores
tyres84725232tyres
users55817572user_s
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
zeros144918102zeros

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 Limit538004681.97027309.6
3Display Results4684680.1233804.9
 (SQL Overall)1786914682.18681743.4
 
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.