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

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

92 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
thunderstones176216(None) 
thunderstone1652231thunderstone_
thunderstorms1961592thunderstorms
thunderstrokes2271732thunderstrokes
thundershower23151493thundershower
thundershowers24171263thundershowers
thunderstorm1861743thundersto_rm
thunderstrikes2261743thunderstrikes
thunderstroke2161913thunderstroke_
undertones1148973__under_tones
cornerstones1452874corn_erstones
rhinestones1453344rhin_e_stones
thunderbolts1851534thunder_bolts
thunderclouds2071164thunderclouds
thunderous1443614thunder__o_us
thunderstrike2161894thunderstrike
thunderstruck2371384thunderstruck
underscores1445374__underscores
undersongs1245334__unders_ongs
understands1344654__understands
understates1247704__understates
understories1365564__understories
undertone10510204__under_tone_
bluestones1244645blu__e_stones
bondstones1375545_bond__stones
buhrstones1592935_bu__hrstones
burrstones12113835_bu__rrstones
burstones1187155_bu___rstones
cornerstone1352805corn_erstone_
counterstates1586645counterstates
counterstrokes2064625counterstrokes
counterstyles1854785counterstyles
grindstones1352645grind__stones
headstones1465365_head__stones
launderettes1351625launderet_tes
lodestones1145425__lode_stones
misunderstands187705misunderstands
mudstones1245035_mu_d__stones
rhinestone1353215rhin_e_stone_
rhinestoned1551875rhin_e_stoned
sandstones1145655_sand__stones
sunstones947885_sun___stones
superstores13117955_su_perstores
thunderbirds1951675thunder_birds
thunderbolt1752025thunder_bo_lt
thunderclaps2061365thunder_claps
thundercloud1961325thunderclo_ud
thundered1444575thunder____ed
thunderer1344255thunder____er
thunderers1443975thunder___ers
thunderheads2051925thunder_heads
thundering1544575thunder__in_g
thunders1236955thunder_____s
thunderstricken2581305thunderstricken
tinderboxes2151645t_inder_boxes
tinstones948495t_in___stones
toadstones1144345t_oad__stones
touchstones1652385tou__chstones
turnstones1044305t_u__rnstones
underdoes1139105__under_do_es
underdone1158215__under_done_
underdoses1247005__under_doses
undergoes1139055__under_go_es
undergone1158275__under_gone_
underlines111512115__under_lines
undermines131710665__under_mines
underscore1345805__underscore_
underscored1545145__underscored
undershoots1553455__undershoots
undershorts1543695__undershorts
undersides1248695__unders_ides
undersigned14114975__undersigned
undersigns1265835__undersign_s
undersoils1156065__unders_oils
undersong1147995__unders_on_g
underspins1346835__underspin_s
understand1246185__understan_d
understate1148865__understate_
understated1347835__understated
understeer1145815__underst_eer
understeers1253765__understeers
understood1244145__understo_od
understory1445125__understo_ry
understudies1453325__understudies
undertakes1547695__under_takes
undertaxes1847025__under_taxes
undertints1148285__under_tints
undertows1366685__under_to_ws
undervotes1456535__under_votes
unpersons1146855__unpers_on_s
whetstones1643345wh___etstones
whinstones1644235whin___stones

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790929.08013743.4
3Display Results92920.0462000.0
 (SQL Overall)178691929.51618778.0
 
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.