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

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

228 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
puggry1337482(None) 
puggy124612321pugg_y
augury10366662augury
buggery14367932buggery
buggy124613482bugg_y
fuggy135411672fugg_y
hungry1334972hungry
muggy125612372mugg_y
piggery14266192piggery
piggy124011432pigg_y
pudgy124911162pudg_y
pugged114314532pugged
puggree11176112puggree
sugary1039012sugary
vuggy13589482vugg_y
aggro738013_aggro
angary10311323angary
angry9310873_angry
auger64922473auger_
augers73818703augers
augur64311213augur_
augurs7399963augurs
baggy125615683bagg_y
beggary14316153beggary
biggy124413133bigg_y
boggy126116073bogg_y
bugged114318403bugged
bugger104418723bugger
buggers114315663buggers
bulgy115214103bulg_y
burry105221563bu_rry
bury95633593bu__ry
curry105920343cu_rry
doggery13448263doggery
doggy115214873dogg_y
druggy12344743drugg_y
dungy104713643dung_y
dupery12378743dupery
eggy96611853_egg_y
faggy136514373fagg_y
foggy136714543fogg_y
fugged124615383fugged
fuggily1534963fuggily
furry116719283fu_rry
fury107727973fu__ry
giggly12518703giggly
goggly12337053goggly
gory86129663__gory
guggle94110433guggle
gurry94515413gu_rry
hugely1336803hugely
huger94914873huger_
hugged124113643hugged
hugger114713123hugger
huggers124211593huggers
hurry114917183hu_rry
jaggary19304863jaggary
jaggery19336903jaggery
jaggy175913143jagg_y
jiggly18378713jiggly
jiggy17549143jigg_y
jugged163813933jugged
juggle154310283juggle
jugglery20303813jugglery
jungly17407693jungly
jury146719593ju__ry
leggy105210243legg_y
loggy105714193logg_y
luger65322083luger_
lugers74617023lugers
lugged94417063lugged
lugger83916553lugger
luggers93713483luggers
luggie8318903luggie
luxury1642543luxury
moggy125212163mogg_y
mugg86316013mugg__
muggar10316443muggar
muggars11316643muggars
mugged114113833mugged
muggee103612833muggee
mugger103914703mugger
muggers113611933muggers
muggily1435103muggily
muggs94912323mugg_s
muggur10325593muggur
muggurs11315103muggurs
murry105120233mu_rry
naggy106612823nagg_y
niggly11418913niggly
nugget8311723nugget
nuggety1234313nuggety
outcry1137993outcry
pager84728203pager_
pagers94423253pagers
paltry114910403paltry
panfry14456413panfry
pantry115014103pantry
papery134812743papery
parry105323753p_arry
pastry114913033pastry
paughty16294323paughty
peery105719443p_eery
pegged114811913pegged
peltry11288653peltry
penury1148103penury
perry105222713p_erry
pigged114214153pigged
piggie103210773piggie
piggin103111093piggin
pigmy13299433p_igmy
pigsty1235933pigsty
pinery115214293pinery
plaguy12386413plaguy
plugged12408043plugged
plugger11378443plugger
pluggers12297033pluggers
plugugly1541123plugugly
podgy125610773podg_y
poetry1139383poetry
pogey116017893p_ogey
pogy105623553p_og_y
popery134511703popery
porgy116916123porg_y
poultry1235383poultry
predry1237873predry
priggery1543993priggery
priory114110263priory
prudery1335253prudery
pry85728053p___ry
puberty1444783puberty
puckery18306263puckery
puddly13438133puddly
pudgily1434903pudgily
puffery18235113puffery
puffy164410753pu_ffy
pug65337183pu_g__
pugaree10208033pugaree
puggaree12174333puggaree
puggier11309383puggier
pugging122912543pugging
puggish14265993puggish
puggrees12194263puggrees
puggries12166383puggries
pugh106619233pu_g_h
pugmark1643463pugmark
pugree92112473pugree
pugs76332773pu_g_s
puler74826623puler_
pulers83820283pulers
pulley113713403pulley
pulpy124612363pu_lpy
punchy16398523punchy
pung75429633pung__
pungle94413573pungle
pungs85422223pung_s
punily11311773punily
punkey154011173punkey
punky144419393pu_nky
punny104217713pu_nny
punty106021613pu_nty
puny95526993pu__ny
puppy114912413pu_ppy
pur56840553pu__r_
pure65543333pu__re
purely114013633purely
purer75127903purer_
purge85324603purg_e
purged104918263purged
purger94717233purger
purgers104714003purgers
purges94421763purges
puri65931443pu__ri
purify14399153purify
purity114114913purity
purl65631423pu__rl
purply13369053purply
purr64925813pu__rr
purrs75320433pu_rrs
purs65641043pu__rs
pursy105016413pu_rsy
purty105019403pu_rty
purvey14559573purvey
pushy134614353pu_shy
pusley11379613pusley
pussly11407373pussly
pussy105614843pu_ssy
putty104721403pu_tty
pygmy16334223p_ygmy
quaggy2084683quaggy
quarry1837473quarry
query174212083qu_ery
raggy106116573ragg_y
rudery10419033rudery
rugby11448133ru_gby
rugged94215383rugged
rugger84414513rugger
ruggers94612313ruggers
saggy105917463sagg_y
snuggery13253973snuggery
soggy105413903sogg_y
spurry11429123spu_rry
sudary1038703sudary
sugar6312913sugar_
sugars7312423sugars
sultry938463sultry
sundry1057943sundry
surgery11319213surgery
surgy95118523surg_y
thuggery1642563thuggery
toggery12505923toggery
tugged93813523tugged
tugger84013103tugger
tuggers93711443tuggers
ugly86012383_u_gly
unary8315993_unary
updry1135483_updry
upgird10103933upgird
upgirt9117263upgirt
usury887623_usury
vagary1337333vagary
vugg95612713vugg__
vuggs10579133vugg_s
waggery15276903waggery
waggly14347293waggly
wiggery15295873wiggery
wiggly14559683wiggly
wiggy134510733wigg_y

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162285.42020796.3
3Display Results2282280.0802850.0
 (SQL Overall)1786912285.87630410.3
 
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.