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

104 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
nuggety123431(None) 
nugget8311721nugget_
nuggets936381nuggets
biggety1434432biggety
buggery14367932buggery
snuggery13253972snuggery
biggity1435013biggity
budget104618123budget_
budgets11489863budgets
bugged114318403bugge_d
bugger104418723bugge_r
buggers114315663buggers
buggy124613483bugg__y
doggery13448263doggery
drugget10337613drugget_
druggets11313913druggets
dubiety1344583dubiety
faggoty1542863faggoty
fidgety15384893fidgety
fugged124615383fugge_d
fuggily1534963fuggily
fuggy135411673fugg__y
furmety1534813furmety
gadgety13356163gadgety
gargety12388043gargety
guglet84018223guglet_
guglets9369693guglets
hogget114715763hogget_
hoggets12498323hoggets
hugely1336803hu_gely
hugged124113643hugge_d
hugger114713123hugge_r
huggers124211593huggers
jaggery19336903jaggery
jugged163813933jugge_d
jugglery20303813jugglery
loggets9378913loggets
lugged94417063lugge_d
lugger83916553lugge_r
luggers93713483luggers
maggoty1444013maggoty
mugged114113833mugge_d
muggee103612833mugge_e
muggees11338883muggees
mugger103914703mugge_r
muggers113611933muggers
muggily1435103muggily
muggy125612373mugg__y
nagged93916053nagge_d
nagger84016123nagge_r
naggers93812653naggers
naggy106612823nagg__y
naivety1344283naivety
naughty14445623naughty
nicety1138433n_icety
nidget83715643nidget_
nidgets9358143nidgets
nigger89713573nigge_r
niggers93111323niggers
niggly11418913nigg_ly
nighty135611273n_ighty
nimiety1244633nimiety
ninety9510963n_inety
nogged95716333nogge_d
nudely10299033nu_dely
nudge74616433nudge__
nudged95511843nudge_d
nudger85111643nudge_r
nudgers9479373nudgers
nudges84114743nudge_s
nudity1037993nu_dity
nullity1037363nullity
nunnery10355303nunnery
nursery10396023nursery
nutlet64220563nutlet_
nutlets74111253nutlets
nutty84816873nu__tty
piggery14266193piggery
pugged114314533pugge_d
puggry13374823pugg_ry
puggy124612323pugg__y
raggedy13334663raggedy
rugged94215383rugge_d
ruggedly14182983ruggedly
rugger84414513rugge_r
ruggers94612313ruggers
russety1034613russety
snugged10408033snugge_d
snugger9318313snugge_r
snuggest1045243snuggest
suety85318493su__ety
suggest9310863suggest
suggests1044713suggests
surety93515013su_rety
surgery11319213surgery
thuggery1642563thuggery
toggery12505923toggery
tugged93813523tugge_d
tugger84013103tugge_r
tuggers93711443tuggers
ubiety1135913_ubiety
vuggy13589483vugg__y
waggery15276903waggery
wiggery15295873wiggery

Search took 8 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 Filter1786911340270.466383457.1
2DLD Change Limit1340271046.64320175.7
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.13925030.3
 
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.