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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
fugging13391291(None) 
bugging123515181bugging
fagging133714761fagging
figging133313561figging
fogging133513731fogging
frugging14317051frugging
fudging133310011fudging
fugling124212511fugling
fuguing12337481fuguing
hugging132710631hugging
jugging172910721jugging
lugging104114351lugging
mugging122711791mugging
pugging122912541pugging
rugging102512761rugging
tugging102611231tugging
bagging123316982bagging
begging123012652begging
bigging122815882bigging
bogging123615752bogging
budging124313022budging
bugling113615342bugling
bulging113514212bulging
bunging113616502bunging
chugging1634912chugging
cogging123513712cogging
digging113513702digging
dogging113312692dogging
drugging12326442drugging
dunging103012622dunging
egging93210982_egging
fadging134210242fadging
fidging133910502fidging
flagging14329232flagging
flogging14329172flogging
forging124114722forging
fragging14329422fragging
frigging14268952frigging
frogging14358732frogging
fubbing15409572fubbing
fucking173212282fucking
fueling113615132fueling
fuggier12348962fuggier
fuggily1534962fuggily
fulling114019702fulling
fuming124013292fu_ming
funding124113662funding
funking154013022funking
funning113813612funning
furling114016562furling
furring114013142furring
fusing104415952fu_sing
fussing113611682fussing
futzing20307902futzing
fuzing194110642fu_zing
fuzzing19336182fuzzing
gagging93013532gagging
gigging93311772gigging
glugging10316352glugging
guggling10236352guggling
gurging102910112gurging
hagging133114682hagging
hogging133112802hogging
igging93212072_igging
jagging173311992jagging
jigging173011552jigging
jogging173211232jogging
judging17337932judging
juggling18225602juggling
kegging14328292kegging
lagging103316742lagging
legging103912642legging
logging103316812logging
lugeing9359112lugeing
luging83915292lu_ging
lunging93714212lunging
mogging123311492mogging
muggings13244592muggings
muggins11248072muggins
nagging102613042nagging
nogging103612722nogging
nudging10328692nudging
pegging122811132pegging
pigging123614672pigging
plugging13306892plugging
purging113314182purging
ragging103516682ragging
rigging103016332rigging
sagging103116102sagging
slugging11339422slugging
snugging11286932snugging
sughing12359712sughing
surging93115432surging
tagging103014912tagging
togging103512742togging
urging83413122_urging
vegging13308872vegging
wagging133313352wagging
wigging133413832wigging
zagging193210452zagging
zigging193210532zigging

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.406440125.6
2DLD Change Limit1076711013.20333615.7
3Display Results1011010.0303366.7
 (SQL Overall)1786911013.63949104.4
 
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.