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

151 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
puffily183484(None) 
huffily1934691huffily
daffily1735132daffily
fluffily1652922fluffily
gruffily1863082gruffily
pudgily1434902pudgily
puffery18235112puffery
puffier1547972puffier
puffin141149002puffi_n
puffing162910942puffing
puffins15278912puffins
puffy164410752puff__y
pulpily1436102pulpily
punily11311772pu_nily
pursily1238212pursily
pushily15247982pushily
ruffly15336672ruff_ly
snuffily17124322snuffily
spiffily19153482spiffily
stuffily17124162stuffily
tuftily1335572tuftily
beefily1535613beefily
bluffly1833433bluff_ly
buffalo1553723buffalo
buffi136112203buffi__
buffier1568403buffier
buffing163411393buffing
buffy165013373buff__y
bulkily16227123bulkily
bumpily1665653bumpily
burlily1237713burlily
bushily15268893bushily
busily112211503bu_sily
cuffing163210253cuffing
curlily1238383curlily
cushily15257923cushily
duffel13407753duffel_
duffels14296453duffels
duffle13368533duff_le
dumpily1566233dumpily
duskily15236743duskily
dustily113211523dustily
effigy1642213_effigy
fuggily1534963fuggily
fulfil1246423fulfil_
fulfill1345023fulfill
fulfils1345723fulfils
funkily1736513funkily
funnily1336373funnily
furrily1337613furrily
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
goofily14105353goofily
gruffly17413893gruff_ly
gushily14257823gushily
gustily113010903gustily
gutsily11267223gutsily
heftily1635763heftily
huffier1637493huffier
huffing17278833huffing
huffish1935713huffish
huffishly2442613huffishly
huffy174810233huff__y
huskily17236333huskily
juicily1935493juicily
jumpily2174983jumpily
loftily1336353loftily
luckily16297083luckily
luffing143310103luffing
lumpily1476563lumpily
lustily103611243lustily
muckily18277743muckily
muddily1435963muddily
muffin14298873muffi_n
muffing163210403muffing
muffins15308343muffins
muffle14339643muff_le
muggily1435103muggily
murkily16287113murkily
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
niftily1335753niftily
nuttily10308633nuttily
outfly1238273outf_ly
pawkily1934203pawkily
peppily1335133peppily
perfidy1635273perfidy
perkily1637813perkily
peskily1635083peskily
pettily1238173pettily
phonily1537103phonily
piffle14418233piff_le
pily96132733p___ily
pithily1567033pithily
pluckily1963413pluckily
plushily1664423plushily
pockily1846233pockily
podgily1435213podgily
pokily15309063p_okily
pouffy17395883pouff__y
prefile123413183prefile
pricily142710283pricily
privily15207623privily
profile123211153profile
prosily12611633prosily
publicly1743313publicly
puddly13438133pu_ddly
puerile9310093puerile
puff125525433puff___
puffball1841983puffball
puffed153510603puff_ed
puffer144610733puff_er
puffers15349203puffers
puffiest1647323puffiest
puffs134114933puff__s
punchily1844863punchily
pupfish1735533pupfish
pupil94712983pu_pil_
pupils10389913pu_pils
purely114013633pu_rely
purfle112511183purf_le
purify14399153pu_rify
purity114114913pu_rity
purply13369053pu_rply
pussly11407373pu_ssly
putridly1443493putridly
quakily2336693quakily
ruddily1236303ruddily
ruffian1344133ruffian
ruffianly1851623ruffianly
ruffing143210843ruffing
ruffle124111673ruff_le
rustily103112993rustily
ruttily10338613ruttily
scruffily2041883scruffily
sniffily17154033sniffily
snuffly16305203snuff_ly
spunkily1733773spunkily
subfile122010503subfile
suffice15197573suffice
suffix1935233suffi_x
sulkily14218113sulkily
sunnily1037833sunnily
surlily10310003surlily
uglily1036193_uglily
unfitly1335573_unfitly
waffly18305433waff_ly

Search took 7 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.423422437.4
2DLD Change Limit1340271516.45320769.7
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.93925751.7
 
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.