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

119 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
sufferer143606(None) 
suffered1536731suffered
sufferers1555101sufferers
buffered1764992buffered
buffeter1683592buffeter
offerer1335542_offerer
suffer124314512suff__er
suffers133113542suffer_s
sufficer16225822sufficer
sunderer9310522sunderer
austerer838383austerer
buffer144512683buff__er
buffers153310793buffer_s
buffeted1753733buffeted
buffeters1783143buffeters
buffier1568403buff_ier
chafferer20133923chafferer
coffered1737673coffered
cumberer14266993cumberer
differed1635523differed
duffer134711663duff__er
duffers143410093duffer_s
gauffered1741873gauffered
goffered1634523goffered
huffier1637493huff_ier
lumberer12177583lumberer
muffler15398343muff_ler
mufflered1842123mufflered
murderer1145263murderer
mutterer10218913mutterer
niffered1544143niffered
numberer12186313numberer
offered1436143_offered
offerers1434933_offerers
offeror1342943_offeror
pilferer1344923pilferer
profferer1742933profferer
puckerer1645793puckerer
puffer144610733puff__er
pufferies1745203pufferies
puffers15349203puffer_s
puffery18235113puffer_y
puffier1547973puff_ier
putterer10209913putterer
quaverer2054583quaverer
queerer16106503qu_eerer
quiverer2044463quiverer
ruffler13369723ruff_ler
rufflier1434003rufflier
saunterer945033saunterer
scuffer15328883scuff__er
scuffers16307493scuffer_s
scuffler16286693scuff_ler
seafarer1144843seafarer
serer55935503s___erer
severer103511563s_everer
sheerer103813843s_heerer
shiverer14186663shiverer
showerer1436163showerer
shuffler17306793shuff_ler
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
slaverer11196993slaverer
sliverer11237633sliverer
slumberer13194803slumberer
sneerer73512313s_neerer
snuffer13318843snuff__er
snuffers14326913snuffer_s
snuffier14276933snuff_ier
snuffler14317403snuff_ler
snufflier1543293snufflier
soberer93110353s_oberer
softener1145613softener
solderer947183solderer
sorcerer1036433sorcerer
sputterer11165263sputterer
steerer73113633s_teerer
stiffener1541963stiffener
stuffer13349793stuff__er
stuffers14277383stuffer_s
stuffier14336613stuff_ier
stutterer9164913stutterer
subsere9311443subsere_
subseres10312423subseres
subverter1445273subverter
succorer12124683succorer
suckered1537833suckered
suffari1345503suffar_i
suffaris1445083suffaris
suffering1637293suffering
suffice15197573suffice_
sufficed17205663sufficed
sufficers17204533sufficers
suffices16208173suffices
suffixed22214343suffixed
suffixes21196343suffixes
suffuse1335443suffuse_
suffused1544023suffused
suffuses1435823suffuses
sugarer837323su_garer
sulfured1236113sulfured
sulfuret1149273sulfuret
sullener857243sullener
summered1338143summered
summerier1346423summerier
sundered10312153sundered
sunderers1039073sunderers
superber1239693su_perber
supered10316123su_pered
supremer1246483supremer
surer54833093su___rer
surfacer1345663surfacer
surfeiter1244713surfeiter
surfer93515883surf__er
surfers103614133surfer_s
surfier102613543surf_ier
tafferel1443123tafferel
utterer71910463_utterer

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.1701051123.5
2DLD Change Limit1461621197.72018932.9
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.95322468.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.