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

99 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
layerings1323568(None) 
lawyerings1752581lawyerings
layering122310351layering_
lacewings1543302lacewings
lagering102212312lagering_
lawyering1655212lawyering_
waterings13229252waterings
ageings9437693_age_ings
airings83913843_a_irings
algerines1069083algerines
altering91917113altering_
cagelings1335413cagelings
capering132414963capering_
catering112019903catering_
clavering1538373clavering_
coverings15217893coverings
craterings1346003craterings
darings93713653da__rings
daysprings1741573daysprings
dyeings12374643_dye_ings
earings84517713ea__rings
earrings9299633ea_rrings
elaterins9410033elaterin_s
fairings12388193fa_irings
flavorings1762973flavorings
gatherings15105293gatherings
gaywings1633193gay_wings
hankerings18244753hankerings
havering152211053havering_
hayings14379393hay__ings
kayakings1642683kayakings
laagering1136833laagering_
labeling11311643labeling_
laboring112110143laboring_
lacewing1435843lacewing_
lacings105013653la__cings
lackering1639373lackering_
laddering1237593laddering_
ladening1078823ladening_
ladings93814133la__dings
laggings11298403la_ggings
lairing83715343la_iring_
lakings124713513la__kings
landings103110073la_ndings
lappering14258843lappering_
lapwings14274973la_pwings
lashings124412253la_shings
lastings94214423la_stings
latening9711493latening_
laterites9715063laterites
laterizes18513023laterizes
lathering13912253lathering_
lathings12469853la_things
latrines8515013la_trines
laughings1443483laughings
laveering1336813laveering_
lawings113611473la__wings
layerage1244963layer_age
layerages1345303layerages
layers93921183layer___s
laying104525703lay__ing_
layins93817653lay__in_s
leavenings1472583leavenings
leering83417643l_eering_
letterings11226003letterings
levering122212503levering_
livering122012383livering_
lowering122210913lowering_
lumberings15103783lumberings
lustrings10245553lustrings
lyings10488503l_y__ings
mayings134410513may__ings
niderings1175403niderings
offerings1643653offerings
pairings11398313pa_irings
panelings12107453panelings
papering132213313papering_
parings104219213pa__rings
plasterings1444743plasterings
playgoings1792373playgoings
playthings1942363playthings
ravelings13377383ravelings
ravenings13235183ravenings
sabering112113743sabering_
sacrings11278923sa_crings
sayings113610833say__ings
slavering1338723slavering_
speerings12276843speerings
tabering112211423tabering_
tapering112112503tapering_
vaporings1544093vaporings
wafering15208893wafering_
wagering13219523wagering_
wakenings1743043wakenings
wanderings15215833wanderings
watering122316313watering_
wavering152410543wavering_
wayfarings2041783wayfarings
waygoings1742203waygoings

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit148641997.53019739.8
3Display Results99990.0501980.0
 (SQL Overall)178691998.01622291.8
 
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.