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

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

85 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
thuds9511013(None) 
thud85613911thud_
thugs95611991thugs
thus76721471thu_s
bauds85821042bauds
bhuts105812952bhuts
buds75235182_buds
chads116122232chads
chubs125412622chubs
chugs115511942chugs
chums125015832chums
cruds85815852cruds
cuds76730482_cuds
duds65530152_duds
feuds95914882feuds
fuds86528572_fuds
gauds75717722gauds
hods87239872_hods
hubs96027142_hubs
hues75235232_hues
hugs86129752_hugs
hums96831422_hums
huns76136932_huns
hurds95219072_hurds
huts76737442_huts
lauds65618482lauds
leuds66214812leuds
mauds85519272mauds
muds75530662_muds
ouds56430112_ouds
phuts104613502phuts
puds75630522_puds
rhus75114052rhu_s
scuds85116242scuds
shads95124482shads
sheds96122702sheds
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
spuds85113672spuds
studs64415872studs
suds56135302_suds
tads57143952t_ads
taus46342732tau_s
tauts56125512tauts
teds54932582t_eds
tends65425582tends
thaws116515462thaws
thens85921832thens
thews117416192thews
thins85826332thins
thirds10438602thirds
this76027382th_is
thous86017262thous
thrums11429122thrums
thug86415482thu_g
thuja1535212thuja
thujas1634432thujas
thumb124511282thumb
thumbs13377442thumbs
thump126211572thump
thumps13449352thumps
thunk124911852thunk
thunks13459032thunks
thurl84912682thurl
thurls9418712thurls
thuya1135582thuya
thuyas1234772thuyas
toads65621072toads
tods56141852t_ods
tours55325892tours
touts54830392touts
trues54925322trues
trugs65516802trugs
truss54916922truss
tubs65430062t_ubs
tugs56231672t_ugs
tuis44829642t_uis
tuns45138662t_uns
tups65628762t_ups
turds65021692turds
tuts45838452t_uts
whids125413992whids
whups134210002whups
yauds95013222yauds

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit53800851.73331044.4
3Display Results85850.0165312.5
 (SQL Overall)178691852.07985950.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.