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
alterers8251250(None) 
alterer72714011alterer_
falterers12238041falterers
palterers11249541palterers
adherers1296922adherers
adulterers1143172adulterers
alieners889822alieners
allegers9378232allegers
allurers8286772allurers
altered83215752altere_d
alters64924222alt__ers
banterers112410012banterers
barterers11269642barterers
batterers113110722batterers
caterers102814412caterers
enterers82214152enterers
falterer11239872falterer_
filterers12206972filterers
halteres113414602haltere_s
latherers12158852latherers
miterers10219682miterers
palterer102411292palterer_
patterers112410132patterers
utterers8218652utterers
waterers112312792waterers
abetters1057173abetters
abjurers1733943abjurers
acceders1334803acceders
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
altering91917123altering
alterity1149853alterity
althaeas1144213althaeas
altheas1038233alt_heas
altimeters1246363altimeters
ambeers11428923ambe_ers
ameers84015573a_me_ers
amercers1256133a_mercers
ammeters1237693ammeters
amperes11313983ampere_s
answerers1243743answerers
anteaters939353anteaters
antevert1148993antevert
anteverts1244743anteverts
anthers103715203ant_hers
antlers74014743ant_lers
antres65021003ant_re_s
apterous10410483apterous
armorers10288973armorers
arteries8321513arteries
aspersers11377243aspersers
aspirers1066493aspirers
asserters956403asserters
assurers866313assurers
asterias8317043asterias
asters65631603ast__ers
ateliers837903a_teliers
atoners75013963a_toners
attempers13103503attempers
attenders1045283attenders
attesters935813attesters
attires72312953attire_s
augurers9114813augurers
austerer838383austerer_
auteurs7137513aute_urs
averters11249513a_verters
axletrees1642893axletrees
banterer102811783banterer_
barterer102711653barterer_
batteners11238183batteners
batterer102713223batterer_
blatherers15175343blatherers
bleeders11448453bleeders
bleepers12377493bleepers
blethers13429613blethers
blusterers12174993blusterers
bolsterers1244683bolsterers
caperers122611723caperers
capturers1344633capturers
careerers1137243careerers
caterer92815953caterer_
cateress102311613cateress
charterers15146053charterers
chatterers15205463chatterers
cheerers13319543cheerers
clatterers12155423clatterers
clearers10349303clearers
coherers132310733coherers
coverers132712123coverers
detergers11147183detergers
deterrers10116593deterrers
ditherers13196683ditherers
easterners1044843easterners
enterer72015633enterer_
faltered122811003faltere_d
falters103916473falt__ers
fasteners12237063fasteners
fatteners12236883fatteners
fetterers12267043fetterers
filterer11258143filterer_
flatterers13175913flatterers
fleecers13325933fleecers
fleers96015793fl_e_ers
floorers11227573floorers
flowerers1544503flowerers
flutterers13184593flutterers
fosterers12238023fosterers
galeres83514343gal_ere_s
gatherers13156893gatherers
haltere103614713haltere__
haltered123112573haltere_d
halters104619803halt__ers
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
hasteners12267823hasteners
hoverers14289023hoverers
integers937783integers
jabberers2043553jabberers
jeerers14328923_jeerers
labelers10249413labelers
laborers10208383laborers
lateeners945573lateeners
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
paltered113012503paltere_d
palters94021683palt__ers
pamperers15236863pamperers
panderers12229153panderers
paperers122410453paperers
parterres1148083parterres
pasturers1136393pasturers
patterer103112183patterer_
pesterers112510463pesterers
pewterers14216043pewterers
pilferers1444583pilferers
plasterers1286123plasterers
potterers11218663potterers
poulterers1244563poulterers
putterers11238363putterers
quarterers19124833quarterers
ratteners9237273ratteners
retirers84311533retirers
reverers113113153reverers
salterns8388903salter_ns
salters73622253salt__ers
saltiers83411953salt_iers
saltires83112433saltire_s
saltpeters1253103saltpeters
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
waterer103314083waterer_
waverers14318613waverers
winterers12209723winterers
witherers15146843witherers
yammerers16214453yammerers

Search took 9 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 Limit1461622397.59319249.6
3Display Results2392390.0932569.9
 (SQL Overall)1786912398.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.