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

239 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
alterers8251249(None) 
alterer72714001alterer_
falterers12238031falterers
palterers11249531palterers
adherers1296922adherers
adulterers1143172adulterers
alieners889822alieners
allegers9378232allegers
allurers8286772allurers
altered83215742altere_d
alters64924222alt__ers
banterers112410002banterers
barterers11269632barterers
batterers113110712batterers
caterers102814402caterers
enterers82214152enterers
falterer11239862falterer_
filterers12206972filterers
halteres113414602haltere_s
latherers12158852latherers
miterers10219682miterers
palterer102411282palterer_
patterers112410122patterers
utterers8218652utterers
waterers112312782waterers
abetters1057173abetters
abjurers1733943abjurers
acceders1334793acceders
actress948533act_ress
adherer1137573adherer_
adheres11310163adhere_s
adjurers1634373adjurers
admirers1134713admirers
adorers84411733a_dorers
adulterer1043553adulterer_
adulteress1142903adulteress
aethers103614943aet_hers
afters94717073aft__ers
airers64922313a__irers
alders74218423al__ders
alegars838933al_egars
alerter72111513al_erter_
alerts64418223al_er_ts
alienees8118653alienees
aliener71011193aliener_
alienors8136733alienors
aligners9117573aligners
aliners74717723al_iners
alkenes114212753alkene_s
allayers11156633allayers
allees64521483alle_e_s
alleger8319633alleger_
alleges84212573allege_s
alleles73812033allele_s
allergens10145173allergens
allovers1137673allovers
allurer7348433allurer_
allures72913113allure_s
almemars1243523almemars
almners9399563al_mners
almoners1068133almoners
altars64518153alt__ars
alter54828503alt__er_
alterant8614963alterant
alterants979103alterants
altering91917113altering
alterity1149843alterity
althaeas1144213althaeas
altheas1038233alt_heas
altimeters1246353altimeters
ambeers11428923ambe_ers
ameers84015573a_me_ers
amercers1256133a_mercers
ammeters1237693ammeters
amperes11313983ampere_s
answerers1243743answerers
anteaters939343anteaters
antevert1148993antevert
anteverts1244723anteverts
anthers103715203ant_hers
antlers74014743ant_lers
antres65021003ant_re_s
apterous10410463apterous
armorers10288973armorers
arteries8321483arteries
aspersers11377243aspersers
aspirers1066493aspirers
asserters956393asserters
assurers866313assurers
asterias8317013asterias
asters65631603ast__ers
ateliers837883a_teliers
atoners75013953a_toners
attempers13103503attempers
attenders1045273attenders
attesters935803attesters
attires72312953attire_s
augurers9114813augurers
austerer838383austerer_
auteurs7137503aute_urs
averters11249513a_verters
axletrees1642893axletrees
banterer102811773banterer_
barterer102711633barterer_
batteners11238163batteners
batterer102713213batterer_
blatherers15175343blatherers
bleeders11448453bleeders
bleepers12377493bleepers
blethers13429613blethers
blusterers12174993blusterers
bolsterers1244683bolsterers
caperers122611723caperers
capturers1344633capturers
careerers1137243careerers
caterer92815943caterer_
cateress102311613cateress
charterers15146053charterers
chatterers15205463chatterers
cheerers13319543cheerers
clatterers12155423clatterers
clearers10349303clearers
coherers132310733coherers
coverers132712123coverers
detergers11147183detergers
deterrers10116593deterrers
ditherers13196683ditherers
easterners1044823easterners
enterer72015633enterer_
faltered122810993faltere_d
falters103916473falt__ers
fasteners12237053fasteners
fatteners12236873fatteners
fetterers12267043fetterers
filterer11258143filterer_
flatterers13175913flatterers
fleecers13325933fleecers
fleers96015793fl_e_ers
floorers11227573floorers
flowerers1544503flowerers
flutterers13184593flutterers
fosterers12238023fosterers
galeres83514343gal_ere_s
gatherers13156883gatherers
haltere103614713haltere__
haltered123112563haltere_d
halters104619803halt__ers
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
hasteners12267813hasteners
hoverers14289023hoverers
integers937783integers
jabberers2043553jabberers
jeerers14328923_jeerers
labelers10249413labelers
laborers10208383laborers
lateeners945563lateeners
lateens74210553late_ens
lateness82614073lateness
laterals8312753laterals
latexes1438313latexe_s
latherer111310453latherer_
lathers104321883lat_hers
laveers10329363lave_ers
leers54828983_l_e_ers
legers74518313_l_egers
lepers84817323_l_epers
letterers9228113letterers
letters73819853_letters
levers94621323_l_evers
litterers9228193litterers
loiterers936263loiterers
lurers64217493_l_urers
maltsters1135193maltsters
maturers1037383maturers
miterer92511333miterer_
mutterers11247373mutterers
offerers1434933offerers
orderers9116563orderers
oysterers1245573oysterers
palaverers1542713palaverers
paltered113012493paltere_d
palters94021683palt__ers
pamperers15236863pamperers
panderers12229153panderers
paperers122410453paperers
parterres1148063parterres
pasturers1136393pasturers
patterer103112173patterer_
pesterers112510463pesterers
pewterers14216043pewterers
pilferers1444583pilferers
plasterers1286123plasterers
potterers11218663potterers
poulterers1244563poulterers
putterers11238363putterers
quarterers19124823quarterers
ratteners9237263ratteners
retirers84311533retirers
reverers113113153reverers
salterns8388903salter_ns
salters73622253salt__ers
saltiers83411953salt_iers
saltires83112433saltire_s
saltpeters1253093saltpeters
saunterers1044383saunterers
scatterers12205043scatterers
shatterers13185723shatterers
shelterers1344343shelterers
silverers12215753silverers
slaverers12165993slaverers
sleekers12377993sleekers
sleepers103110113sleepers
sliverers12196363sliverers
smatterers12174873smatterers
sneerers8309803sneerers
solderers1066533solderers
starers74522313_starers
steerers82511353steerers
steers63820983_ste_ers
stereos74314973_stereos
steres63929533_stere_s
storers75018683_storers
tamperers13227313tamperers
taperers10269773taperers
tearers75218233__tearers
termers95414503__termers
titterers9236993titterers
totterers9186813totterers
utterer71910463utterer_
wagerers12247613wagerers
waltzers2034003walt_zers
wanderers13228483wanderers
waterer103314073waterer_
waverers14318613waverers
winterers12209723winterers
witherers15146843witherers
yammerers16214453yammerers

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.406440125.6
2DLD Change Limit1461622397.40619735.6
3Display Results2392390.0932569.9
 (SQL Overall)1786912397.90522604.8
 
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.