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

104 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
offerers143493(None) 
offerer1335541offerer_
offerors1443531offerors
offenders1643402offenders
offered1436142offere_d
offeror1342942offeror_
offers12349962off__ers
officers1643802officers
orderers9116562orderers
profferers1842422profferers
sufferers1555102sufferers
adherers1296923adherers
affecters1763933affecters
afferent1447983afferent
afferents1546013afferents
affirmers1742563affirmers
affixers2143293affixers
alterers82512493alterers
borderers1276333borderers
buffeters1783143buffeters
caperers122611723caperers
caterers102814403caterers
chafferers21153173chafferers
cheerers13319543cheerers
coffees15329573coffe_e_s
coffered1737673coffere_d
coffers154112693coff__ers
coffrets1645363coff_rets
coherers132310733coherers
conferees14610623conferees
conferrers1546453conferrers
coverers132712123coverers
deferrers13115153deferrers
dodderers1243803dodderers
doffers14359853doff__ers
effacers16244233effacers
effecters1764323effecters
efferent1447203efferent
efferents1545333efferents
enfevers1444513enfevers
enterers82214153enterers
farers95924053__farers
fearers104815273_fearers
feeders113712863_feeders
feelers103814743_feelers
feres86038183__fere_s
fevers125414893__fevers
firers94922683__firers
fleers96015793_fle_ers
forevers1438173forevers
fosterers12238023fosterers
freers94717303_fre_ers
freres94716173_frere_s
fuehrers1442613_fuehrers
fuelers103912393_fuelers
fuhrers1334813_fuhrers
goffered1634523goffere_d
goffers14409213goff__ers
hoverers14289023hoverers
inferrers12226583inferrers
jeerers14328923_jeerers
loiterers936263loiterers
miterers10219683miterers
obeyers1234813o_beyers
observers1443973observers
offences1645023offences
offender1543723offender_
offends14234293offe_nds
offenses1443833offenses
offer114311383off__er_
offering1536393offering
offerings1643653offerings
offertory1852093offertory
officer1534213officer_
offices1536243office_s
offsets1333503off_sets
oftener1035923oftener_
openers9339493o_peners
orderer8127943orderer_
oysterers1245573oysterers
paperers122410453paperers
pilferers1444583pilferers
ponderers12248453ponderers
potterers11218663potterers
powderers15214793powderers
profferer1742933profferer_
referees111310413referees
referrers12125373referrers
reverers113113153reverers
sneerers8309803sneerers
softeners1245133softeners
solderers1066533solderers
sorcerers1145323sorcerers
steerers82511353steerers
sufferer1436063sufferer_
tafferels1542223tafferels
taperers10269773taperers
toffees13327083toffe_e_s
totterers9186813totterers
utterers8218653utterers
wagerers12247613wagerers
waterers112312783waterers
waverers14318613waverers
wonderers13217933wonderers

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.420425454.8
2DLD Change Limit1461621046.78321548.3
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.23324705.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.