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

315 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
sered6573729(None) 
cered85227441cered
seared75232841seared
seed55549481se_ed
sere46153471sere_
serer55935511serer
seres55448891seres
serged84118771serged
served104616811served
sewed95325161sewed
sexed136618541sexed
shred98125611shred
sired66134281sired
sored66141781sored
acred87126352acred
aeried74221862aeried
aired66032922aired
bared85144482bared
beret74946362beret
bermed115217722bermed
bored85034302bored
bred75130972_bred
breed85526692breed
cared86050092cared
ceded96118562ceded
cere66741472cere_
ceres75540012ceres
cored85044222cored
cred76530882_cred
creed85727392creed
cured85932132cured
dared75935012dared
deed65340902de_ed
deked115718532deked
deled75326542deled
dere56845902dere_
dewed105020302dewed
dreed75222842dreed
dured75025402dured
eared65139502eared
eked96718022_eked
ere36352772_ere_
erred65915672erred
exed125420592_exed
eyed86623232_eyed
fared95842342fared
feared106320432feared
feed84538902fe_ed
fere76342232fere_
feres86038182feres
feted94420932feted
feued94715662feued
fired94829742fired
freed95223542freed
geared85317742geared
geed65435502ge_ed
gored75227082gored
greed75125692greed
gyred105114092gyred
hared95742182hared
heed86437602he_ed
heired103813042heired
herbed123513452herbed
herd84933062her_d
herded114215642herded
here76447102here_
heres86245902heres
hewed125619432hewed
hexed165615762hexed
hired95226262hired
ired55131872_ired
jeed125428502je_ed
jeered143912792jeered
jereed144012072jereed
jerid132316422jerid
jerked18479592jerked
jewed165114832jewed
kerbed13339702kerbed
kerfed14358232kerfed
kerned114112932kerned
keyed1369392keyed
leered73816222leered
lured65427492lured
meed74934702me_ed
merde84320122merde
mere67244442mere_
merer75126232merer
meres75143572meres
merged104214952merged
meted85424432meted
metred95315142metred
mewed115218012mewed
mired85729222mired
mured85726702mured
neared75119802neared
need54934152ne_ed
nerd56624942ner_d
nereid7312922nereid
nerved104111682nerved
oared65030652oared
osiered837122osiered
overed102216622overed
pared86946762pared
peed76239182pe_ed
peered93819492peered
pere66450262pere_
perea75026442perea
peres76246642peres
perked134617692perked
permed115217352permed
pored85234512pored
preed85128122preed
rared65738322rared
reared75930012reared
rebred95816352rebred
red46755802__red
reded74829122reded
reed55549622re_ed
refed93921922refed
reread71715432reread
rewed95425452rewed
sabed86526812sabed
sabered103213022sabered
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scared95227292scared
scored94621132scored
scree720031712scree
screed95718932screed
screw109318542screw
scried95817302scried
scrod85115072scrod
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
searer65432022searer
seated75131062seated
secede93311992secede
secret8325062secret
secured1059722secured
seder64826762seder
see35772262se_e_
seeded84520462seeded
seeds64330062se_eds
seedy94821532se_edy
seek85935482se_ek
seel45042982se_el
seeled73922092seeled
seem65438562se_em
seemed95117612seemed
seen46943122se_en
seep66540342se_ep
seeped94317522seeped
seer45547042se_er
seers55136382seers
sees45361052se_es
segued838512segued
seined74023062seined
seised74218122seised
seized164313652seized
selfed10310912selfed
seme65836652seme_
semen75724102semen
semes75731582semes
send55237292se_nd
sended85121232sended
sene46848052sene_
sensed73918162sensed
ser36752402ser__
sera46141392ser_a
serac75925202serac
serai56830162serai
seral56336382seral
serein63318462serein
serene63522352serene
serest64831612serest
serf76340112ser_f
serfs84922012serfs
serge64727472serge
serger73819742serger
serges74225972serges
series64540972series
serif84132132serif
serifed11811462serifed
serin55434442serin
serow86720442serow
serried82513962serried
serry84824122serry
sers45746652ser_s
serum75223472serum
serve85425962serve
server94917712server
serves94423652serves
servo84516682servo
seven84118312seven
sever85426052sever
severed113513862severed
sewer84426222sewer
sewered112911242sewered
sexes126126222sexes
shared105829062shared
sheared114516002sheared
shed86536152s_hed
sheered113515452sheered
sherd96321152sher_d
shewed134716182shewed
shied96125492shied
shoed95723012shoed
shored105723652shored
shreds105613052shreds
shrew119720172shrew
shrewd136810782shrewd
sided74825952sided
sieged85212712sieged
sieved104611442sieved
siped84927682siped
sire46150412sire_
siree55238812siree
siren54525822siren
sires55945372sires
sited65130742sited
sized155519242sized
skeed105018982skeed
skewed145610232skewed
skied104417752skied
skyed13529922skyed
sled55334372s_led
slewed104815522slewed
slued64220512slued
smeared104510622smeared
smerked14327282smerked
snared74824552snared
sned56026052s_ned
sneered83113972sneered
snored74819542snored
soared74324292soared
sobered102912432sobered
soled65835172soled
sorbed94916522sorbed
sord56237202sor_d
sore47059532sore_
sorel56231442sorel
sorer56236592sorer
sores55454282sores
sorned74820042sorned
sorted74523712sorted
soured74921862soured
sowed94933862sowed
spaed85522272spaed
spared95427492spared
speared104314422speared
sped76031492s_ped
speed85526622speed
speered103614812speered
speired103811102speired
spewed125512332spewed
sphered133512312sphered
spied85427712spied
spiered104412462spiered
spired94921862spired
spored94821792spored
spread9312532spread
spree74830862spree
spued84918472spued
stared75429872stared
steed66024942steed
steered83615252steered
stere55328542stere_
stereo65317912stereo
steres63929532steres
stewed104814242stewed
stied65723032stied
stored75524212stored
strep77120852strep
strew89220662strew
styed95815482styed
sued56537932s_ued
sueded84014632sueded
supered10316122supered
surd56433812sur_d
sure45447412sure_
surer54833102surer
surfed103814462surfed
surged84118882surged
swerved1455702swerved
syren85216742syren
tared69340052tared
teared75722152teared
teed55439262te_ed
teredo7310782teredo
termed94816702termed
tewed94718532tewed
tiered73613972tiered
tired65228902tired
treed65626732treed
tyred95816432tyred
ushered1139152ushered
veered103612742veered
verged114815162verged
versed104515512versed
vexed165713112vexed
wared96339872wared
weed85637512we_ed
were76238332were_
wired95327642wired
yerked14509372yerked
zeroed16409412zeroed

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.610292936.1
2DLD Change Limit538003151.65332546.9
3Display Results3153150.0803937.5
 (SQL Overall)1786913152.34376265.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.