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

35 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
bethumps174199(None) 
bethump1642821bethump_
bethumped1941492bethumped
metumps1334132met_umps
thumps13449352__thumps
bedlamps1543663bedlamps
bedumbs1433633be_dumbs
begums11429493be_gum_s
benumbs1333543be_numbs
berhymes1843803berhymes
beshames1537203beshames
bethanks1765313bethanks
bethels1238533beth_els
bethinks1765043bethinks
bethorns1337323bethorns
beths105519223beth___s
bethumping2042023bethumping
betimes115114413bet_imes
bumps115921143b___umps
chumps154313823__chumps
exhumes1934323_exhumes
getups9346853get_u_ps
humps126322803___humps
ketchups1941893ketchu_ps
letups8317683let_u_ps
metump1235713met_ump_
outjumps1942603outjumps
repumps1334403re_pumps
setups83910463set_u_ps
stumps104912283_st_umps
thumbs13377443__thumbs
thump126211573__thump_
trumps104611883__trumps
tumps95420793__t_umps
whumps16427093__whumps

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 Filter1786911461620.190940478.9
2DLD Change Limit146162359.25015801.3
3Display Results35350.0162187.5
 (SQL Overall)178691359.45618897.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.