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

102 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
snuggery1325397(None) 
snugger9318311snugger_
buggery14367932_buggery
nuggety1234312_nuggety
slugger93610682slugger_
sluggers10348482sluggers
smugger11327052smugger_
snigger9328372snigger_
sniggers10317092sniggers
snugged10408032snugge_d
snuggerie1192802snuggerie
snuggest1045242snuggest
staggery13346242staggery
surgery11319212s_urgery
thuggery1642562thuggery
bugger104418723_bugger_
buggers114315663_buggers
chugger1445373chugger_
chuggers1554863chuggers
doggery13448263_doggery
drudgery14273633drudgery
groggery1433513groggery
hugger114713123_hugger_
huggers124211593_huggers
jaggery19336903_jaggery
jugglery20303813_jugglery
lugger83916553_lugger_
luggers93713483_luggers
mugger103914703_mugger_
muggers113611933_muggers
nagger84016123_nagger_
naggers93812653_naggers
nigger89713573_nigger_
niggers93111323_niggers
nudger85111643_nudger_
nudgers9479373_nudgers
nugget8311723_nugge_t
nuggets936383_nuggets
nunnery10355303_nunnery
nursery10396023_nursery
piggery14266193_piggery
plugger11378433plugger_
pluggers12297023pluggers
priggery1543993priggery
puggry13374823_pugg_ry
rugger84414513_rugger_
ruggers94612313_ruggers
sagger84321073s_agger_
saggers94017083s_aggers
sauger74316253sau_ger_
saugers83914053sau_gers
savagery1543223savagery
scullery13296333scullery
shuddery16263413shuddery
slogger94310483slogger_
sloggers10418783sloggers
sluggard1142613sluggard
slugged104410383slugge_d
slumbery15296043slumbery
smuggest1244373smuggest
smuggler12244523smuggler_
smugglers13263433smugglers
snagged104010673snagge_d
snaggier10136303snaggier_
snaggy11488053snagg__y
sneery93610413sn__eery
snickery17295543snickery
sniggered1243443sniggered
sniggerer1142723sniggerer
sniggler10396113sniggler_
snigglers11314593snigglers
snobbery15514293snobbery
snogged10417973snogge_d
snubber11277733snubber_
snubbers12326673snubbers
snuffer13318853snuffer_
snuffers14326923snuffers
snuggeries1293843snuggeries
snuggies10246363snuggies
snugging11286933snugging
snuggle9275713snugg_le
snuggled11234953snuggled
snuggles10306143snuggles
snugly1055663snu_g_ly
snugness934323snugness
sputtery13366473sputtery
stagger94212393stagger_
staggers10379843staggers
sugary1039013s_u_gary
suggest9310863s_uggest
summery14329413s_ummery
surger74320093s_urger_
surgers83517483s_urgers
swagger12389333swagger_
swaggers13407223swaggers
swigger12338453swigger_
swiggers13337123swiggers
toggery12505923_toggery
tugger84013103_tugger_
tuggers93711443_tuggers
waggery15276903_waggery
wiggery15295873_wiggery

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621027.18620339.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.65523343.0
 
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.