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

168 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
suffered153673(None) 
buffered1764991buffered
sufferer1436061sufferer
buffeted1753732buffeted
coffered1737672coffered
differed1635522differed
gauffered1741872gauffered
goffered1634522goffered
mufflered1842122mufflered
niffered1544142niffered
offered1436142_offered
suckered1537832suckered
suffer124314512suffer__
sufferers1555102sufferers
suffers133113542suffer_s
sufficed17205662sufficed
suffixed22214342suffixed
suffused1544022suffused
sulfured1236112sulfured
summered1338142summered
sundered10312152sundered
supered10316122su_pered
buffed154313143buff__ed
buffer144512683buffer__
buffers153310793buffer_s
buffeter1683593buffeter
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
buttered112712623buttered
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
sabered103213023s_abered
saggered11237553saggered
sauntered1036283sauntered
scuffed16298243scuff__ed
scuffer15328883scuffer__
scuffers16307493scuffer_s
scuffled17256203scuff_led
scunnered1243803scunnered
scuppered1643933scuppered
scuttered12166423scuttered
sered65737293s___ered
severed113513863s_evered
sewered112911243s_ewered
sheered113515453s_heered
shivered15177103shivered
showered1537013showered
shuddered1543433shuddered
shuffled18296243shuff_led
shuttered13156333shuttered
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sintered92213903sintered
sistered92612803sistered
skewered1634213skewered
slavered12188033slavered
slivered12218103slivered
slubbered14175253slubbered
sluffed14308303sluff__ed
slumbered14215593slumbered
sneered83113973s_neered
snuffed14308073snuff__ed
snuffer13318853snuffer__
snuffers14326923snuffer_s
snuffled15277033snuff_led
sobered102912433s_obered
softened1235663softened
soldered1038153soldered
souffled15276193souff_led
souffleed16272903souffleed
speered103614813s_peered
sphered133512313s_phered
spiered104412463s_piered
sputtered12166323sputtered
steered83615253s_teered
stiffened1642133stiffened
stuffed14328973stuff__ed
stuffer13349793stuffer__
stuffers14277383stuffer_s
stuttered10145763stuttered
subbreed1345873subbreed
submerged1544603submerged
submersed1445863submersed
subsere9311443subsere_
subseres10312423subseres
subserved1545143subserved
subvened1436423subvened
subverted1545443subverted
succeed1235983succe_ed
succored13135173succored
sueded84014633su__eded
suffari1345503suffar_i
suffaris1445083suffaris
suffering1637293suffering
suffice15197573suffice_
sufficer16225823sufficer
suffices16208183suffices
suffixes21196353suffixes
sufflated1644623sufflated
suffuse1335443suffuse_
suffuses1435833suffuses
sugared938583su_gared
sulfated1238833sulfated
sulfuret1149273sulfuret
sunderer9310523sunderer
surfaced1436063surfaced
surfed103814463surf__ed
surfeited1344593surfeited
surfer93515883surfer__
surfers103614133surfer_s
surveyed1544233surveyed
suspired1135613suspired
sutured8310373su_tured
syphered1755013syphered
tafferel1443123tafferel
telfered1234883telfered
tuckered1535963tuckered
ulcered1037973_ulcered
umbered121510113_umbered
unbuffered1951763unbuffered
unfeared121511013_unfeared
unfired112212453_unfired
unfreed11510123_unfreed
unoffered1643363unoffered
ushered1139153_ushered
uttered82712433_uttered
wafered14288433_wafered
wuthered15157433wuthered

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 Limit1461621686.70321805.5
3Display Results1681680.0762210.5
 (SQL Overall)1786911687.20224811.3
 
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.