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

108 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
pugging12291254(None) 
bugging123515181bugging
fugging133912911fugging
hugging132710631hugging
jugging172910721jugging
lugging104114351lugging
mugging122711791mugging
pegging122811131pegging
pigging123614671pigging
plugging13306891plugging
purging113314181purging
rugging102512761rugging
tugging102611231tugging
bagging123316982bagging
begging123012652begging
bigging122815882bigging
bogging123615752bogging
budging124313022budging
bugling113615342bugling
bulging113514212bulging
bunging113616502bunging
chugging1634912chugging
cogging123513712cogging
digging113513702digging
dogging113312692dogging
drugging12326442drugging
dunging103012622dunging
egging93210982_egging
fagging133714762fagging
figging133313562figging
fogging133513732fogging
frugging14317052frugging
fudging133310012fudging
fugling124212512fugling
fuguing12337482fuguing
gagging93013522gagging
gigging93311772gigging
glugging10316352glugging
guggling10236352guggling
gurging102910112gurging
hagging133114682hagging
hogging133112802hogging
igging93212072_igging
jagging173311992jagging
jigging173011552jigging
jogging173211232jogging
judging17337932judging
juggling18225602juggling
kegging14328292kegging
lagging103316732lagging
legging103912642legging
logging103316802logging
lugeing9359112lugeing
luging83915292lu_ging
lunging93714212lunging
mogging123311492mogging
muggings13244592muggings
muggins11248072muggins
nagging102613042nagging
nogging103612722nogging
nudging10328692nudging
paging104020402p_aging
panging113319112panging
parging113318602parging
piggin103111092piggin_
piggins113010472piggins
pinging113419552pinging
plunging12357672plunging
ponging113416152ponging
prigging13299092prigging
progging132610382progging
pudding124010802pudding
puffing162910942puffing
puggier11309382puggier
puggish14265992puggish
puking133913062pu_king
puling93621402pu_ling
pulling103821072pulling
pulping123612322pulping
pulsing103712862pulsing
pumping144213552pumping
pungling12228662pungling
punning103414992punning
punting103318442punting
pupping114412502pupping
purgings12347292purgings
purling103620292purling
purring104515822purring
pursing103715552pursing
pushing133615452pushing
putting103218572putting
putzing19359122putzing
ragging103516682ragging
rigging103016332rigging
sagging103116102sagging
slugging11339422slugging
snugging11286932snugging
sughing12359712sughing
surging93115432surging
tagging103014912tagging
togging103512742togging
upgoing1135352upgoing
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.1431249587.4
2DLD Change Limit1076711083.20333615.7
3Display Results1081080.0303600.0
 (SQL Overall)1786911083.37652929.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.