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

112 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
redated9312092(None) 
predated12513271predated
rebated103619701rebated
redacted12410241redacted
redate74124681redate_
redates83423871redates
related83327571related
remated103522471remated
sedated93714351sedated
aerated85322372aerated
belated103520012belated
berated104422132berated
cerated103922472cerated
created104323452cre_ated
credited1238252credited
cremated133412962cremated
crenated113013912crenated
dated75530992__dated
debated113916082debated
delated93722872delated
derated93623502derated
edited83913672_edited
elated74725822_elated
foredated1447682foredated
gelated93615632gelated
gradated1157432gradated
heated104525592he_ated
ideated9310972ideated
iodated9310022iodated
legated92513982legated
meated94222402me_ated
medaled113411612medaled
mediated123011872mediated
negated93413232negated
nidated939862nidated
pedaled113711892pedaled
pedate93117762pedate_
predate10616892predate_
predates11615812predates
radiated102512592radiated
rated65441382r__ated
reacted103015712reacted
readapted1344802readapted
readded103310732readded
readied93316622readied
reamed94326122re_amed
reaped94122452re_aped
reared75930012re_ared
reaved104523922re_aved
rebaited11410542rebaited
rebate84424112rebate_
rebater93517912rebater
rebates95123182rebates
recaned102817202recaned
recanted112513512recanted
recited104319102recited
recoated113416782recoated
recrated112918602recrated
redbaited1344712redbaited
redded94019552red_ded
reddled102912322reddled
reded74829122red__ed
redialed10310792redialed
redrafted1435142redrafted
redried93714892redried
reduced11610322reduced
redyed114611242red_yed
reedited10310082reedited
reested82916232reested
refaced133713572refaced
reflated123514292reflated
refuted114313802refuted
regaled93615962regaled
regrated102816332regrated
reheated122415002reheated
relaced103517212relaced
relate64033632relate_
relater73723142relater
relates73731432relates
relaxed153312532relaxed
relayed113212752relayed
remate84428682remate_
remates93827112remates
renamed103114522renamed
rented74426592re_nted
repasted112611532repasted
repaved133311132repaved
repeated113117442repeated
replated112817522replated
reputed104613482reputed
resawed113111182resawed
reseated93220262reseated
resited85122422resited
reslated93517522reslated
restated93120182restated
rested74430782re_sted
retaped103814282retaped
retasted92412112retasted
retaxed153512232retaxed
retted74826312re_tted
revoted114314152revoted
rewaked153811902rewaked
rewaxed18409342rewaxed
rotated82715292rotated
seated75131062se_ated
sedate73019812sedate_
sedater83713632sedater
sedates83418042sedates
teated74924022te_ated
treated83618702tre_ated
undated93118462undated
updated11369422updated

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.390458182.1
2DLD Change Limit1076711123.18633795.0
3Display Results1121120.0333393.9
 (SQL Overall)1786911123.60949512.6
 
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.