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

114 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
remated10352247(None) 
cremated133412961cremated
rebated103619701rebated
redated93120921redated
related83327571related
remate84428681remate_
remates93827111remates
aerated85322372aerated
belated103520012belated
berated104422132berated
bromated1339172bromated
cerated103922472cerated
created104323452cre_ated
cremate113816182cremate_
cremates124216002cremates
crenated113013912crenated
debated113916082debated
delated93722872delated
demasted1238762demasted
demoted114313542demoted
derated93623502derated
elated74725822_elated
emoted94614922_emoted
gelated93615632gelated
gemmated14336292gemmated
heated104525592he_ated
legated92513982legated
mated85537782__mated
meated94222402me_ated
negated93413232negated
predated12513272predated
ramate83921682ramate_
rated65441382r__ated
reacted103015712reacted
reamed94326122re_amed
reaped94122452re_aped
reared75930012re_ared
reaved104523922re_aved
rebaited11410542rebaited
rebate84424112rebate_
rebater93517912rebater
rebates95123182rebates
recaned102817202recaned
recanted112513512recanted
recited104319102recited
recoated113416782recoated
recrated112918602recrated
redacted12410242redacted
redate74124682redate_
redates83423872redates
reested82916232reested
refaced133713572refaced
reflated123514292reflated
refuted114313802refuted
regaled93615962regaled
regrated102816332regrated
reheated122415002reheated
reimaged1246172reimaged
relaced103517212relaced
relate64033632relate_
relater73723142relater
relates73731432relates
relaxed153312532relaxed
relayed113212752relayed
remade94316982remade_
remailed112411402remailed
remained112412892remained
remake124016112remake_
remaker133813172remaker
remakes134116172remakes
remand95618962rema_nd
remanded123011322remanded
remanned11319352remanned
remapped1534912remapped
remarked15209242remarked
remaster10311472remaster
rematch1436192rematch
rematched1745222rematched
remelted11310152remelted
reminted113615082reminted
remised103516842remised
remitted113312072remitted
remixed173510742remixed
remote84222602remote_
remoter94815972remoter
remotes94521612remotes
removed134611312removed
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
sedated93714352sedated
teated74924022te_ated
tempted12317282tempted
treated83618702tre_ated
unmated103317022unmated

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.373479064.3
2DLD Change Limit1076711143.29632667.2
3Display Results1141140.0462478.3
 (SQL Overall)1786911143.71548099.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.