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

140 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
butteries1171176(None) 
batteries11615111batteries
butleries11710071butleries
butterier1177451butterier
butteriest1276881butteriest
batterie10711532batterie_
booteries11312772booteries
buggeries1347082buggeries
butcheries1745072butcheries
buttered112712622butter_ed
butterflies1652652butterflies
buttering122312522buttering
butterless1244192butterless
butters94521722butter__s
butties93217952butt__ies
catteries11815522catteries
cutleries1179212cutleries
lotteries9311072lotteries
potteries11313592potteries
abutters1056993abutter__s
adulteries1145623adulteries
arteries8321483_arteries
bacterias1349283bacterias
bacterins13410643bacterins
bacterizes2347963bacterizes
bakeries14312193b_akeries
battered113315053batter_ed
batterer102713213batter_er
batterers113110713batterers
battering122715143battering
batters94626013batter__s
beaneries11310903beaneries
bettered113011833better_ed
bettering122212753bettering
betters94422093better__s
bibberies1297133bibberies
binderies12311683binderies
bitcheries1745903bitcheries
bittered112711833bitter_ed
bitterer10309773bitter_er
bitterest1147713bitter_est
bittering122511993bittering
bitterish1446133bitterish
bitterness1245553bitterness
bitterns10428953bitter_ns
bitters94920363bitter__s
bobberies12107893bobberies
boiseries11411043boiseries
botcheries1746053botcheries
bottomries1443083bottomries
boweries13312293b_oweries
braveries1439103braveries
breweries1447583breweries
briberies1348333briberies
bunters94717123bunter__s
buries84633273bu___ries
bursaries1157643bursaries
busters94724133buster__s
butenes9313033bu_te_nes
butlers94518053butler__s
butter84724233butter___
butterbur1342923butterbur
butterburs1443153butterburs
buttercup1542263buttercup
buttercups1652093buttercups
butterfat1444093butterfat
butterfats1552773butterfats
butterfish1853273butterfish
butterfishes2052083butterfishes
butterflied1752003butterflied
butterfly1742953butterfly
buttermilk1851963buttermilk
buttermilks1951473buttermilks
butternut1144743butternut
butternuts1242983butternuts
butterweed1643053butterweed
butterweeds1762203butterweeds
buttery124311193butter__y
buttes84822563butt___es
buttress1035883butt_ress
buttresses1245663buttresses
butyrins1345423bu_tyrins
cauteries11615393cauteries
coteries10422703_coteries
curtesies1147523curtesies
cutcheries1745083cutcheries
cutters94218963cutter__s
cutties93118843cutt__ies
duperies11312813du_peries
eateries8324313_eateries
flatteries1347413flatteries
fulleries1248723fulleries
gunneries1047043gunneries
guttered10259163gutter_ed
guttering112410443guttering
gutterings12224913gutterings
gutters83715513gutter__s
hatterias1258743hatterias
jitterier1644433jitterier
jitteriest1744553jitteriest
jutties143814003jutt__ies
masteries111018493masteries
mummeries1247243mummeries
muttered112610793mutter_ed
mutterer10218913mutter_er
mutterers11247373mutterers
muttering122611323muttering
mutters94117143mutter__s
mysteries141211193mysteries
niteries8318383_niteries
nunneries947113nunneries
nurseries948013nurseries
nutters74215433nutter__s
outcries10313573ou_tcries
outserves12147373outserves
outwearies1345353outwearies
pufferies1745203pufferies
putrefies1444663putrefies
puttees93612913putte__es
puttered112611143putter_ed
putterer10209913putter_er
putterers11238363putterers
puttering122611643puttering
putters94219193putter__s
putties94420023putt__ies
queries16315873qu__eries
ruderies9311333ru_deries
subseries11312933subseries
surgeries10311363surgeries
suttees74114063sutte__es
turneries948493turneries
tusheries1246893tusheries
tutties73216473tutt__ies
uttered82712433_utter_ed
utterer71910463_utter_er
utterers8218653_utterers
uttering91613083_uttering
utterness946223_utterness
utters63817123_utter__s
wasteries121115343wasteries

Search took 9 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.1561145455.1
2DLD Change Limit1486411408.04618473.9
3Display Results1401400.0632222.2
 (SQL Overall)1786911408.26521620.2
 
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.