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

155 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
related8332757(None) 
belated103520011belated
delated93722871delated
elated74725821_elated
gelated93615631gelated
rebated103619701rebated
redated93120921redated
reflated123514291reflated
relaced103517211relaced
relate64033631relate_
relater73723141relater
relates73731431relates
relaxed153312521relaxed
relayed113212751relayed
remated103522471remated
replated112817511replated
reslated93517521reslated
ablated102513442ablated
aerated85322372aerated
alated75625142_alated
areolated1089712areolated
belaced124112152belaced
belayed133610082belayed
belted94020632bel_ted
berated104422132berated
bleated104015972bleated
cerated103922472cerated
chelated142610482chelated
cleated103417842cleated
corelated12411822corelated
created104323452cre_ated
cremated133412962cremated
crenated113013912crenated
dealated103213602dealated
debated113916082debated
deflated133412302deflated
delate73827752delate_
delates83526282delates
delayed123310762delayed
deleted93314902deleted
derated93623502derated
dilated93115822dilated
elate55335882_elate_
elater64724202_elater
elates65032362_elates
eluted74915262_eluted
fellated1239562fellated
felted103714652fel_ted
gelate73421252gelate_
gelates83219582gelates
heated104525592he_ated
lated65240672__lated
legated92513982legated
meated94222402me_ated
melamed1249632melamed
melted94219062mel_ted
negated93413232negated
pelted94617752pel_ted
plated95225772_plated
pleated103816632pleated
predated12513272predated
prelate9519692prelate_
prelates10418572prelates
rated65441382r__ated
reacted103015712reacted
realter73716312realter
reamed94326122re_amed
reaped94122452re_aped
reared75930012re_ared
reaved104523922re_aved
rebaited11410542rebaited
rebate84424112rebate_
rebater93517912rebater
rebates95123182rebates
recaned102817202recaned
recanted112513512recanted
recited104319102recited
recoated113416782recoated
recrated112918602recrated
redacted12410242redacted
redate74124682redate_
redates83423872redates
reested82916232reested
refaced133713572refaced
reflate103516262reflate_
reflates113115662reflates
refloated1347012refloated
refuted114313802refuted
regaled93615962regaled
regelated1139722regelated
reglazed1935742reglazed
regrated102816332regrated
regulated11310462regulated
reheated122415002reheated
relabel938162relabel
relace83122152relace_
relaces93420882relaces
relaid75518442rela_id
reland75920432rela_nd
relanded102410462relanded
relapsed1136522relapsed
relatedly1344172relatedly
relaters83218152relaters
relator74016362relator
relaxer143410222relaxer
relaxes143215322relaxes
released9310242released
relegated1139762relegated
relented92614942relented
relied74926232rel_ied
relined85321932relined
relisted9312622relisted
relived115114682relived
reloaded1059102reloaded
reloaned939722reloaned
relocated12710812relocated
relucted1138652relucted
relumed1069812relumed
remate84428682remate_
remates93827112remates
renamed103114522renamed
rented74426592re_nted
repasted112611532repasted
repaved133311132repaved
repeated113117442repeated
replaced133211392replaced
replanted1248062replanted
replate93420052replate_
replates102919272replates
replayed14248622replayed
reputed104613482reputed
resawed113111182resawed
reseated93220262reseated
resited85122422resited
reslate73520592reslate_
reslates83619502reslates
restated93120182restated
rested74430782re_sted
retaped103814282retaped
retasted92412112retasted
retaxed153512232retaxed
retted74826312re_tted
revoted114314152revoted
rewaked153811902rewaked
rewaxed18409342rewaxed
rotated82715292rotated
seated75131052se_ated
sedated93714342sedated
slated75028312_slated
solated83618022solated
teated74924022te_ated
treated83618702tre_ated
unrelated10310432unrelated
velate93720142velate_
welted103715822wel_ted

Search took 4 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 Filter1786911076710.1431249587.4
2DLD Change Limit1076711553.17033965.6
3Display Results1551550.0463369.6
 (SQL Overall)1786911553.35953197.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.