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

56 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
swaggering1623362(None) 
saggering12197791s_aggering
staggering13194581staggering
daggering13246112_daggering
saggaring12236242s_aggaring
sniggering1343762sniggering
swaggeringly2151192swaggeringly
swagging14328092swagg__ing
wagering13219522_wa_gering
angering102113803__angering
badgering1436963_badgering
buggering1435193_buggering
dangering12239303_dangering
jiggering1934303_jiggering
laagering1136833_laagering
lagering102212313_la_gering
leaguering1243813leaguering
sabering112113743s_a_bering
sagging103116103s_agg__ing
scampering1745323scampering
scarpering1545413scarpering
scattering1398013scattering
shagging14349053shagg__ing
shattering1498283shattering
slabbering15104973slabbering
slagging113711583slagg__ing
slandering1237243slandering
slathering14108283slathering
slavering1338723sla_vering
smattering1397583smattering
snagging11319373snagg__ing
spattering13107793spattering
staggeringly1851363staggeringly
stagging113310513stagg__ing
stammering1544523stammering
strangering1345183strangering
swagger12389333swagger___
swaggered1543193swagger_ed
swaggerer1442943swagger_er
swaggerers1542233swaggerers
swaggers13407223swagger__s
swaging124210633swa_g__ing
sweltering1445233sweltering
swigging14337223swigg__ing
swingeing14144693swinge_ing
swithering17105213swithering
triggering1343883triggering
wafering15208893_wa_fering
waggeries14127463_waggeries
wagging133313353_wagg__ing
waggling14197063_wagg_ling
waggoning1543593_waggoning
waitering13310713_waitering
wandering143310983_wandering
watering122316313_wa_tering
wavering152410543_wa_vering

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 Filter1786911406030.406440125.6
2DLD Change Limit140603566.56321423.6
3Display Results56560.0301866.7
 (SQL Overall)178691566.99925530.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.