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

131 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
buffered176499(None) 
buffeted1753731buffeted
suffered1536731suffered
buffed154313142buff__ed
buffer144512682buffer__
buffers153310792buffer_s
buffeter1683592buffeter
buggered1335622buggered
bumpered1536002bumpered
bunkered15177182bunkered
buttered112712622buttered
coffered1737672coffered
differed1635522differed
gauffered1741872gauffered
goffered1634522goffered
mufflered1842122mufflered
niffered1544142niffered
offered1436142_offered
sufferer1436062sufferer
unbuffered1951762unbuffered
badgered1336213badgered
baffed154812173baff__ed
baffled16418063baff_led
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
beavered1437503beavered
befleaed1454663befleaed
bettered113011833bettered
bickered17108003bickered
biffed15449883biff__ed
bistered112913323bistered
bittered112711833bittered
blazered2035063blazered
blubbered13164113blubbered
bluffed16326433bluff__ed
bluffer15396883bluffer__
bluffers16405703bluffer_s
blundered1335193blundered
blustered12157263blustered
boffed15369483boff__ed
bordered1248933bordered
bothered142110393bothered
bouldered1344483bouldered
bowered133113043b_owered
brokered1536083brokered
bucketed1736763bucketed
bucklered1844543bucklered
budgeted1344883budgeted
buffaloed1841553buffaloed
buffering1835223buffering
buffest15298643buffe_st
buffet143113783buff__et
buffeters1783143buffeters
buffets15317593buffe_ts
buffier1568403buff_ier
bufflehead2271703bufflehead
bugseed1136173bugse_ed
bulleted1138393bulleted
burdened1236423burdened
burred95820723bu__rred
burseed1049503burse_ed
burweed1347823burwe_ed
busheled1465263busheled
butchered1744583butchered
chaffered21154483chaffered
cuffed154311213cuff__ed
cumbered15157963cumbered
duffer134711663duffer__
duffers143410093duffer_s
fullered1236383fullered
guffawed1941623guffawed
guttered10259163guttered
huffed163710153huff__ed
hungered13217053hungered
hunkered16186923hunkered
juddered1833583juddered
luffed133810823luff__ed
lumbered13188233lumbered
lustered92510603lustered
muffed154210593muff__ed
muffled16377783muff_led
murdered1236023murdered
mustered112511503mustered
muttered112610793muttered
numbered13147143numbered
offerer1335543_offerer
outfired1238083outfired
pilfered1435853pilfered
proffered1843433proffered
puckered1736103puckered
puffed153510603puff__ed
puffer144610733puffer__
pufferies1745203pufferies
puffers15349203puffer_s
puffery18235113puffer_y
puttered112611143puttered
quavered2144813quavered
queered17117213qu_eered
quivered2144823quivered
raftered1237663raftered
reoffered1643313reoffered
rubbered1335383rubbered
ruffed134312743ruff__ed
ruffled14369153ruff_led
suckered1537833suckered
suffer124314513suffer__
sufferers1555103sufferers
suffers133113543suffer_s
sufficed17205663sufficed
suffixed22214343suffixed
suffused1544023suffused
sulfured1236113sulfured
summered1338143summered
sundered10312153sundered
supered10316123su_pered
tafferel1443123tafferel
telfered1234883telfered
tuckered1535963tuckered
ulcered1037973_ulcered
umbered121510113_umbered
unfeared121511013_unfeared
unfired112212453_unfired
unfreed11510123_unfreed
unoffered1643363unoffered
ushered1139153_ushered
uttered82712433_uttered
wafered14288433_wafered
wuthered15157433wuthered

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621318.33017546.5
3Display Results1311310.0433046.5
 (SQL Overall)1786911318.79620315.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.