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 “dressage” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
dressage104425(None) 
dressages1144151dressages
brassage1145282brassage
message1037832_message
presage10312292pre_sage
restage83316192_restage
brassages1245263brassages
breakage1544183breakage
brewage1347183bre_wage
creepage1344343creepage
degage92711383d_e_gage
dissave1139413d_issave
dosage82810003d__osage
drainage1045783drainage
drayage1234433dr_ayage
dredge9308563dre__dge
dress65319833dress___
dressed93511873dress_ed
dresser83611953dress_er
dressers9359863dressers
dresses83716173dress_es
dressier956863dressier
dressily1246443dressily
dressing102810423dressing
dressings11265373dressings
dressmaker1751923dressmaker
dressy10518143dress__y
driftage1342933driftage
expressage2052393expressage
forestage1346973forestage
massage1039893_massage
messaged1235543_messaged
messages1138233_messages
messuage1144523_messuage
passage1039803_passage
plussage1143223plussage
presaged1238803pre_saged
presager1138443pre_sager
presages11312203pre_sages
presale9416353pre_sale
preshape1537533preshape
pressure1039773pressure
prestige11310733prestige
reimage1037913_reimage
repassage1243123_repassage
resale64025543_re_sale
rescale93215473_rescale
reshape1249043_reshape
reshave1338603_reshave
reslate73520593_reslate
respace11310913_respace
respade1039573_respade
restaged103011863_restaged
restages92815773_restages
restate73824883_restate
resurge839073_resurge
tressure846483tressure
wreckage1842763wreckage

Search took 8 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 Filter1786911461620.440406115.9
2DLD Change Limit146162587.26320124.2
3Display Results58580.0331757.6
 (SQL Overall)178691587.73623098.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.