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

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

41 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
threadworms205138(None) 
threadworm1951451threadworm_
headwords1745343_h_eadwords
headworks2045953_h_eadworks
threaders1365743thread_er_s
toreadors1045153toread_or_s
wheatworms2151873wh_eatworms
beadworks1945724__beadworks
earworms1346784___earworms
fireworms1745604fire__worms
headrooms1555184_h_eadrooms
headword1645524_h_eadwor_d
headwork1945794_h_eadwor_k
heartworms1842884_h_eartworms
leadworks1745124__leadworks
leadworts1344734__leadworts
leafworms1753614__leafworms
mealworms1644444__mealworms
readorns938284__read_orns
roadworks1745314__roadworks
screwworms2061624scre_wworms
strawworms1861874str_awworms
tapeworms1644244tape__worms
teamworks1844594t__eamworks
terraforms1552584terra_forms
thermoforms2152764thermoforms
thraldoms1542894thr_aldo_ms
threadbare1651364threadbar_e
threader1256734thread_er__
threadfins1741974thread_fins
threadier1354474threadier__
threadiness1543464threadiness
threadless1442474thread_less
threads11419954thread____s
threapers1444774threa_per_s
toreador945004toread_or__
treaders93311844t_read_er_s
treadlers1045894t_readler_s
tubeworms1643504tube__worms
wheatworm2042194wh_eatworm_
wireworms1745034wire__worms

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 Filter1786911488190.403443402.0
2DLD Change Limit148819418.14318275.7
3Display Results41410.0133153.8
 (SQL Overall)178691418.55920877.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.