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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
updiving153422(None) 
diving113717952__diving
ungiving1346332ungiving
unliving1248192unliving
updating1236592updating
updrying1534012updrying
uppiling1335852uppiling
uprising1138952uprising
upsizing2035412upsizing
arriving1237363arriving
auditing1039033auditing
codriving1645213codriving
depriving1636403depriving
deriving132510743deriving
dicing105718763__dicing
dieing84018653__dieing
diking124320243__diking
dining84525133__dining
divine103514463__divine
driving123910713_driving
editing9313133_editing
enditing10311073enditing
giving114313883__giving
hiving134115523__hiving
inditing10312113inditing
iodising1037563iodising
iodizing1936673iodizing
jiving173711603__jiving
living104318323__living
midwiving1942623midwiving
motiving1437163motiving
opining10311743op_ining
outdriving1545583outdriving
outgiving1436213outgiving
outliving1337793outliving
paiking143814813_paiking
paining103920243_paining
pairing103716733_pairing
paving124519743_p_aving
peeving135112243_peeving
peining104619153_peining
peising103416763_peising
pieing93917653_p_ieing
piing85218833_p_i_ing
piking133719643_p_iking
piling95025593_p_iling
pining93726533_p_ining
piping114017453_p_iping
poising103617103_poising
pricing123417343_pricing
priding113317543_priding
priming123417373_priming
prising103321453_prising
prizing193514683_prizing
proving134214073_proving
pudding124010803pud_ding
puddling13218033puddling
pumicing1535843pumicing
radioing1039383radioing
redriving1437603redriving
regiving13269713regiving
reiving113316843_reiving
reliving122713343reliving
reviving152910503reviving
riving104521423__riving
scriving14258763scriving
shriving15268453shriving
skiving15298373_skiving
skydiving2161703skydiving
speiling113612973speiling
speiring113711263speiring
spicing123914533sp_icing
spiking144312883sp_iking
spiling102919703sp_iling
spiring103918183sp_iring
spiting103917623sp_iting
splicing1338963splicing
splining11310773splining
spoiling112911553spoiling
striving122611393striving
surviving1644163surviving
swiving14358953_swiving
thriving15246353thriving
umpiring1336093umpiring
undaring10412753undaring
undoing9312243und_oing
undying1238503und_ying
unfixing1935683unfixing
uniting8315823u_niting
unloving1277483unloving
unmixing1835543unmixing
unmoving1436253unmoving
unpiling1139753unpiling
untieing938863untieing
untiring9312003untiring
upbinding1544303upbinding
upboiling1444633upboiling
upcoiling1444793upcoiling
upcoming1535173upcoming
upcurving1742563upcurving
updarting1334333updarting
updive1234903updiv__e
updived1434093updiv_ed
updives1334713updiv_es
upending12258133upending
upfling1337093up_fling
upgazing2133313upgazing
upgirding1442373upgirding
upgoing1135353up_going
upheaving1843803upheaving
uplifting1534963uplifting
uplinking1634623uplinking
upping114013703up__ping
upraising1237263upraising
uprating11311113uprating
uprisings1243343uprisings
upspring1335703upspring
upswing1335593up_swing
uptilting1234713uptilting
waiving14329633_waiving
wiving133316603__wiving

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.420425454.8
2DLD Change Limit1461621216.95621012.4
3Display Results1211210.0432814.0
 (SQL Overall)1786911217.41924085.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.