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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

55 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
pufferies174520(None) 
puffers15349202puffer__s
buffered1764993buffer_ed
buffering1835223buffering
buffers153310793buffer__s
buggeries1347083buggeries
butleries11710073butleries
butteries11711763butteries
cutleries1179213cutleries
duffers143410093duffer__s
duperies11312813du_peries
faeries104118993__faeries
fulleries1248723fulleries
gunneries1047043gunneries
mummeries1247243mummeries
nunneries947113nunneries
nurseries948013nurseries
panfries13149203panf_ries
pedleries1298783pedleries
peeries93623023p__eeries
piggeries13107893piggeries
pineries102419083p_ineries
plumberies1645123plumberies
poperies12316793p_operies
potteries11313593potteries
pruderies1247873pruderies
puberties1346603pu_berties
puckerier1754313puckerier
puckeriest1843823puckeriest
puffer144610733puffer___
puffery18235113puffer__y
puffier1547973puff__ier
puffiest1647323puff__iest
puffins15278913puff__ins
puggries12166383pu_ggries
pulverise1445063pulverise
pulverises1544483pulverises
pulverizes2444433pulverizes
puppetries1343883puppetries
putrefies1444663putrefies
queries16315873qu__eries
rifleries1247683rifleries
ruderies9311333ru_deries
spooferies1543703spooferies
subseries11312933subseries
suffaris1445083suffari_s
suffered1536733suffer_ed
sufferer1436063suffer_er
sufferers1555103sufferers
suffering1637293suffering
sufferings1743233sufferings
suffers133113543suffer__s
surgeries10311363surgeries
turneries948493turneries
tusheries1246893tusheries

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 Filter1786911486410.423422437.4
2DLD Change Limit148641555.98324843.9
3Display Results55550.0331666.7
 (SQL Overall)178691556.43927751.4
 
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.