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

88 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
upgrading144490(None) 
aggrading1344842aggrading
degrading13137372degrading
grading103918712__grading
parading12313862_parading
regrading121210202regrading
upbraiding1643232upbraiding
upgazing2133312upg_azing
upgirding1442372upgirding
upgrowing1643122upgrowing
uploading1334662uploading
uprating11311112up_rating
abrading1239503_abrading
corrading1338203corrading
engraving1446013engraving
goading103112853__goading
gracing113216443__gracing
gradin83517483__gradin_
gradine93317033__gradine
gradins93416233__gradins
grating93923183__grating
graving123114563__graving
graying124115883__graying
grazing183514553__grazing
griding103014973__griding
hagriding1544733hagriding
migrating13910533migrating
misgrading1546823misgrading
operating12313723operating
outtrading1247153outtrading
parawing14310583_parawing
pervading1636303_pervading
phrasing1438013_phrasing
pirating11314513_pirating
pleading123011443_pleading
pomading1437423_pomading
prating103424453_p_rating
praying133717323_p_raying
priding113317543_p_riding
regarding12149153regarding
regrating111316213regrating
spading113114383sp__ading
spiraling1237953spiraling
spraying14299883sp_raying
spreading1339653spreading
superadding1644393superadding
trading93517973__trading
unbracing1437023unbracing
unbraiding1445123unbraiding
unbraking1636933unbraking
uncrating12813183uncrating
undraping1337333undraping
undrawing1436903undrawing
unfading1347693u_nfading
ungazing1936033ung_azing
ungirding1245153ungirding
ungrudging1452453ungrudging
unguarding1343533unguarding
unlading1058863u_nlading
unleading1138673unleading
unloading1137193unloading
untreading1247563untreading
upbearing1435033upbearing
upbinding1544303upbinding
updarting1334333updarting
updating1236593up_dating
updrying1534013updr_ying
upending12258133up_ending
upfolding1642943upfolding
upgoing1135353upg__oing
upgrade11215823upgrad__e
upgraded13215683upgrad_ed
upgrades12216063upgrad_es
upheaping1743853upheaping
upheaving1843803upheaving
uphoarding1742723uphoarding
upholding1643373upholding
upleaping1434363upleaping
upraising1237263up_raising
uprearing1238373uprearing
uprising1138953up_rising
upscaling1444653upscaling
upsending1334903upsending
upsoaring1244513upsoaring
upstaging1344113upstaging
upstanding1443713upstanding
upstaring1235963upstaring
uptearing1236103uptearing

Search took 7 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.406440125.6
2DLD Change Limit148641885.98624831.4
3Display Results88880.0461913.0
 (SQL Overall)178691886.43827755.7
 
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.