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

252 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
serer5593550(None) 
merer75126231merer
searer65432021searer
seder64826751seder
seer45547041se_er
sere46153471sere_
sered65737291sered
seres55448891seres
serger73819731serger
server94917711server
sever85426051sever
sewer84426211sewer
sorer56236571sorer
surer54833091surer
aerier64823152aerier
airer54927892airer
barer74535802barer
bearer85323912bearer
beer65635992be_er
beret74946362beret
borer75131272borer
carer74942332carer
ceder85322232ceder
cere66741472cere_
cered85227442cered
ceres75540012ceres
corer75538872corer
curer75030752curer
darer65230792darer
dearer74822802dearer
deer56739022de_er
defer94619752defer
dere56845902dere_
deter65028042deter
direr64927072direr
eerier64320022eerier
eger55923562_eger
ere36352772_ere_
err35626532_er_r
esker94412982esker
ester54727712ester
ever77027692_ever
ewer77523982_ewer
eyer76127282_eyer
farer86733142farer
fearer94820182fearer
fere76342232fere_
feres86038182feres
fever115617952fever
fewer115216122fewer
feyer115014522feyer
firer811229252firer
freer86021242freer
hearer94323642hearer
heder95623632heder
herder104516462herder
here76447102here_
heres86245902heres
hewer115719932hewer
hexer155116682hexer
hirer85423122hirer
jeer115426462je_er
jeerer13389932jeerer
jerker17369042jerker
leer46239352le_er
leger65721502leger
leper74820742leper
lever85125162lever
lurer54625312lurer
mercer105214202mercer
mere67244442mere_
meres75143572meres
merger95016472merger
meter75130322meter
nearer64618892nearer
never86218642never
newer85717462newer
parer75839902parer
peer66238352pe_er
pere66450262pere_
perea75026442perea
peres76246642peres
perter84422282perter
peter74427592peter
purer75127902purer
rarer54731702rarer
rearer64928912rearer
refer84822142refer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
saree55044662saree
saver84831252saver
sawer85026212sawer
sayer84926552sayer
scarer84524602scarer
scorer84818252scorer
scree720031702scree
screw109318532screw
sealer63928962sealer
seamer84223612seamer
sear47353842se_ar
seared75232842seared
seater64534152seater
secern81010222secern
secret8325062secret
securer958252securer
seders74420282seders
see35772262se_e_
seed55549482se_ed
seeder74320772seeder
seek85935482se_ek
seeker103615362seeker
seel45042982se_el
seem65438562se_em
seemer84418042seemer
seen46943122se_en
seep66540342se_ep
seers55136382seers
sees45361052se_es
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
seller63824592seller
seme65836652seme_
semen75724102semen
semes75731582semes
sender73824412sender
sene46848052sene_
senor53822792senor
ser36752402s__er
sera46141392ser_a
serac75925202serac
serai56830162serai
seral56336382seral
serein63318462serein
serene63522352serene
serener73415752serener
serest64831612serest
serf76340112ser_f
serfs84922012serfs
serge64727462serge
serged84118762serged
sergers83815632sergers
serges74225962serges
series64540972series
serif84132122serif
serin55434442serin
serow86720442serow
serry84824122serry
sers45746652ser_s
serum75223472serum
serve85425962serve
served104616812served
servers103214832servers
serves94423652serves
servo84516682servo
setter64023722setter
seven84118312seven
severe94016082severe
severer103511562severer
severs94121122severs
sewar85421092sewar
sewed95325162sewed
sewers94719712sewers
sexed136618542sexed
sexes126126222sexes
sexier13310682sexier
sharer95025482sharer
shearer104414682shearer
sheer84726892sheer
sheerer103813842sheerer
shewer124515102shewer
shier85428942shier
shoer84722152shoer
shred98125612shred
shrew119720162shrew
shyer114714782shyer
siker95326032siker
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
siver85728612siver
sizer145521812sizer
skewer13519602skewer
skier95119592skier
slier54827242slier
slyer85515122slyer
smearer94110402smearer
snarer64620842snarer
sneer54919952sneer
sneerer73512312sneerer
snorer64316762snorer
soarer64522242soarer
sober74822402sober
soberer93110352soberer
soever94412092soever
sore47059532sore_
sored66141782sored
sorel56231442sorel
sores55454282sores
sorner64720382sorner
sorter64425082sorter
sourer63620212sourer
sower85229312sower
sparer84524962sparer
spearer93913662spearer
speer74623902speer
spewer115112142spewer
spier75728032spier
spree74830862spree
sprier84119062sprier
spryer11418532spryer
starer64027362starer
steer55423862steer
steerer73113632steerer
stere55328542stere_
stereo65317912stereo
steres63929532steres
sterner7411912sterner
storer64721672storer
strep77120852strep
strew89220652strew
suber74924502suber
suer45334032s_uer
super74924482super
sure45447412sure_
surfer93515882surfer
surger74320092surger
swearer10349952swearer
sweer84918572sweer
swerver1365732swerver
syren85216742syren
tearer64822902tearer
termer85717252termer
terser67317822terser
usurer638102usurer
veer76229572ve_er
verger104315692verger
verier94620962verier
verser94516962verser
vexer155513522vexer
wearer94319402wearer
weber10313522weber
weer75535092we_er
were76238332were_
wirer85124952wirer
yarer84321572yarer

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 Limit538002521.98327130.6
3Display Results2522520.0803150.0
 (SQL Overall)1786912522.15682880.8
 
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.