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

145 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
offerer133554(None) 
offered1436141offered
offerers1434931offerers
offeror1342941offeror
coffered1737672coffered
goffered1634522goffered
offender1543722offender
offer114311382off__er
offerors1443532offerors
offers12349962offer_s
officer1534212officer
oftener1035922oftener
orderer8127942orderer
profferer1742932profferer
sufferer1436062sufferer
adherer1137573adherer
affecter1644523affecter
afferent1447983afferent
affirmer1643083affirmer
affixer2033913affixer
alterer72714003alterer
borderer1168103borderer
buffered1764993buffered
buffeter1683593buffeter
caperer113013403caperer
caterer92815943caterer
chafferer20133923chafferer
cheerer123511753cheerer
coffee144113743coffe_e_
coffees15329573coffe_es
coffer144112863coff__er
coffers154112693coffer_s
coffret15310073coff_ret
coherer122912783coherer
conferee13613733conferee
conferrer1447063conferrer
coverer123113523coverer
deferrer12135593deferrer
differed1635523differed
dodderer1144203dodderer
doffer133911353doff__er
doffers14359853doffer_s
eagerer8248823eagerer
effacer15255413effacer
effecter1664773effecter
efferent1447203efferent
effete1235183effete_
enfever1344643enfever
enterer72015633enterer
fairer95212063_fairer
farer86733143__farer
fearer94820183_fearer
feeder103513843_feeder
feeler93215173_feeler
fere76342233__fere_
feres86038183__feres
fever115617953__fever
fewer115216123__fewer
feyer115014523__feyer
fiercer12356953_fiercer
fierier103511193_fierier
firer811229253__firer
fleer86020773_fle_er
forever1338953forever
fosterer11239523fosterer
freer86021243_fre_er
frere85617723_frere_
freres94716173_freres
fuehrer1332973_fuehrer
fueler94313933_fueler
fuhrer1235033_fuhrer
goffer13409513goff__er
goffers14409213goffer_s
hoverer13319823hoverer
iffier1236763iff_ier
inferrer11217443inferrer
jeerer13389933_jeerer
loiterer837083loiterer
merer75126233__merer
miterer92511333miterer
niffered1544143niffered
obeyer1135893o_beyer
observer1344733observer
ochered132610283ochered
offed12359163off__ed
offence1545353offence
offences1645023offences
offend13365663offe_nd
offended1643653offended
offenders1643403offenders
offends14234293offends
offense1343683offense
offenses1443833offenses
offering1536393offering
offertory1852093offertory
office1435693office_
officered1841913officered
officers1643803officers
offices1536243offices
offkey1932343off_key
offset1238373off_set
ofter84116873o_f_ter
onerier7311613o_nerier
opener83910993o_pener
ordered9108533ordered
orderers9116563orderers
ornerier846043ornerier
osiered837123osiered
overed102216623o_vered
oysterer1136103oysterer
paperer113111903paperer
pilferer1344923pilferer
ponderer112410193ponderer
potterer102310263potterer
powderer14245593powderer
proffered1843433proffered
profferers1842423profferers
queerer16106503queerer
referee101615753referee
referrer11136053referrer
reoffered1643313reoffered
reverer103815833reverer
serer55935513__serer
severer103511563severer
sheerer103813843sheerer
sneerer73512313sneerer
soberer93110353soberer
softener1145613softener
solderer947183solderer
sorcerer1036433sorcerer
steerer73113633steerer
suffered1536733suffered
sufferers1555103sufferers
tafferel1443123tafferel
taperer92511793taperer
toffee123311013toffe_e_
toffees13327083toffe_es
totterer8217793totterer
unoffered1643363unoffered
utterer71910463utterer
wafered14288433wafered
wagerer11328493wagerer
waterer103314073waterer
waverer13319523waverer
wonderer12249183wonderer

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271456.29621287.6
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.74826480.6
 
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.