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

77 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
tuggers9371144(None) 
buggers114315661buggers
huggers124211591huggers
luggers93713481luggers
muggers113611931muggers
ruggers94612311ruggers
taggers93514191taggers
tugger84013101tugger_
aggers85817792_aggers
augers73818702au_gers
baggers113915692baggers
budgers114314922budgers
bugger104418722bugger_
buggery14367932buggery
buglers105115322buglers
bulgers105215142bulgers
burgers103918572burgers
chuggers1554862chuggers
daggers103714912daggers
diggers104413392diggers
doggers104413432doggers
eggers84612582_eggers
foggers124112012foggers
gaggers103413662gaggers
hoggers124512482hoggers
hugger114713122hugger_
hungers114013302hungers
jaggers164012892jaggers
jiggers164010182jiggers
joggers164110692joggers
judgers16369042judgers
jugglers17366522jugglers
keggers13357042keggers
laggers94216242laggers
loggers94616132loggers
lugers74617022lu_gers
lugger83916552lugger_
lungers83817092lungers
muggars11316642muggars
muggees11338882muggees
mugger103914702mugger_
muggurs11315102muggurs
naggers93812652naggers
niggers93111322niggers
nudgers9479372nudgers
nuggets936382nuggets
pluggers12297022pluggers
purgers104714002purgers
riggers93613842riggers
rugger84414512rugger_
saggers94017082saggers
sluggers10348482sluggers
staggers10379842staggers
surgers83517482surgers
tagger84017702tagger_
thuggees1343122thuggees
thuggery1642562thuggery
tigers75616512t_igers
toggery12505922toggery
togglers10276952togglers
tongers84116012tongers
triggers10257842triggers
trudgers10256862trudgers
tubbers113411252tubbers
tubers85017032tu_bers
tuckers134014352tuckers
tufters10298352tufters
tugged93813522tugge_d
tugless837382tugless
tuners64417342tu_ners
turgors836832turgors
turners73912892turners
tuskers113710042tuskers
tussers74313562tussers
tuyers94612562tu_yers
urgers73313622_urgers
waggers124613082waggers

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 Filter1786911076710.373479064.3
2DLD Change Limit107671772.78338688.8
3Display Results77770.0164812.5
 (SQL Overall)178691773.17256333.9
 
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.