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

100 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
thugs9561199(None) 
chugs115511941chugs
hugs86129751_hugs
thuds95110131thuds
thug86415481thug_
thus76721471thu_s
trugs65516801trugs
tugs56231671t_ugs
bhuts105812952bhuts
bugs76035912_bugs
chubs125412622chubs
chug105914112chug_
chums125015832chums
drugs75214652drugs
dugs614832282_dugs
frugs96114282frugs
fugs85730692_fugs
glugs75214282glugs
hags86740842_hags
hogs87139662_hogs
hubs96027142_hubs
hues75235232_hues
hug76037362_hug_
huge86321652_huge
hums96831422_hums
huns76136932_huns
huts76737442_huts
jugs125525602_jugs
lugs55233522_lugs
mugs76232042_mugs
phuts104613502phuts
plugs85213492plugs
pugs76332772_pugs
rhus75114052rhu_s
rugs56033682_rugs
shags95123862shags
shogs95319712shogs
shrugs10469162shrugs
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
slugs64618562slugs
snugs64913022snugs
tags55545232t_ags
tangs65028342tangs
taus46342732tau_s
tauts56125512tauts
teggs74710742teggs
tegs56031492t_egs
teugh95511612teugh
thaws116515462thaws
thegn95810902thegn
thegns10547432thegns
thens85921832thens
thews117416192thews
thigh12410122thigh
thighs1346632thighs
things104914302things
thins85826332thins
this76027382th_is
thongs104611192thongs
though139410782though
thous86017262thous
thrums11429122thrums
thud85613912thu_d
thuja1535212thuja
thujas1634432thujas
thumb124511282thumb
thumbs13377442thumbs
thump126211572thump
thumps13449352thumps
thunk124911852thunk
thunks13459032thunks
thurl84912682thurl
thurls9418712thurls
thuya1135582thuya
thuyas1234772thuyas
tings65329202tings
togs57242432t_ogs
tongs65928462tongs
tough97321992tough
toughs105414992toughs
tours55325892tours
touts54830392touts
trigs65423062trigs
trogs67022602trogs
trues54925322trues
trug55720042trug_
truss54916922truss
tubs65430062t_ubs
tug45937402t_ug_
tuis44829642t_uis
tungs65520622tungs
tuns45138662t_uns
tups65628762t_ups
tuts45838452t_uts
twigs96911172twigs
vugs87022872_vugs
whigs125612642whigs
whups134210002whups

Search took 4 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.500357382.0
2DLD Change Limit538001003.31316239.1
3Display Results1001000.0166250.0
 (SQL Overall)1786911003.82946667.8
 
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.