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

138 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
adherers129692(None) 
adherer1137571adherer_
adheres11310161adhere_s
adhere10310332adhere__
adhered1239232adhere_d
adherend1343862adherend
adherends1443262adherends
adherent1247782adherent
adherents1345552adherents
adjurers1634372adjurers
admirers1134712admirers
adorers84411732ad_orers
alterers82512502alterers
coherers132310732coherers
gatherers13156892gatherers
latherers12158852latherers
abhorrers1442983abhorrers
abjurers1733943abjurers
acceders1334803acceders
achenes12313493achene_s
achievers1743433achievers
adapters1136103adapters
adders84315703ad__ders
address956103ad_dress
adducers1283443adducers
adeems946333ad_e_ems
adherence1564893adherence
adherences1664883adherences
adhering1338883adhering
adjurer1534823adjurer_
adjures1536233adjure_s
adjurors1642863adjurors
admirer1035523admirer_
admires1038663admire_s
adopters1136693adopters
adorer74713453ad_orer_
adores74420723ad_ore_s
adorners9196623adorners
adsorbers1243263adsorbers
adulterers1143173adulterers
adverbs13254273adver_bs
adverts11308513adver_ts
advisers12135003advisers
airers64922313a__irers
alieners889823alieners
allegers9378233allegers
allurers8286773allurers
alterer72714013alterer_
ambeers11428923ambe_ers
ameers84015573a_me_ers
amercers1256133a_mercers
ammeters1237693ammeters
amperes11313983ampere_s
answerers1243743answerers
aphereses1466423aphereses
apheresis1475333apheresis
apheses12610703aphese_s
armorers10288973armorers
ashlers10319583ash_lers
aspersers11377243aspersers
aspirers1066493aspirers
asserters956403asserters
assurers866313assurers
augurers9114813augurers
averters11249513a_verters
banterers112410013banterers
barterers11269643barterers
batterers113110723batterers
blatherers15175343blatherers
caperers122611723caperers
careerers1137243careerers
caterers102814413caterers
catheters1437023catheters
cheders134512393_cheders
cheerers13319543cheerers
cheers114518913_che_ers
chewers154111143_chewers
cipherers1644893cipherers
coherer122912783coherer_
coheres122917693cohere_s
coverers132712123coverers
darers75921873_d_arers
deers64930523_d_e_ers
defers105116943_d_efers
deters74724683_d_eters
dieters83216433_dieters
ditherers13196683ditherers
dodderers1243803dodderers
duelers83412053_duelers
enterers82214153enterers
falterers12238043falterers
fuehrers1442613fuehrers
fuhrers1334813fuh_rers
gatherer12147913gatherer_
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
hearers104319783__hearers
heders104119763__heders
herders113914123__herders
heres86245903__here_s
hewers123715273__hewers
hexers165612753__hexers
hirers94518063__hirers
hoverers14289023hoverers
inheres10315173inhere_s
jabberers2043553jabberers
jeerers14328923_jeerers
latherer111310453latherer_
miterers10219683miterers
offerers1434933offerers
orderers9116563orderers
palterers11249543palterers
pamperers15236863pamperers
panderers12229153panderers
paperers122410453paperers
patterers112410133patterers
reverers113113153reverers
schemers1576713schemers
sharers104720623_sharers
shearers113911323_shearers
sheers94322403_she_ers
shewers134312053_shewers
sneerers8309803sneerers
spheres123114353sphere_s
steerers82511353steerers
tamperers13227313tamperers
taperers10269773taperers
theres96525473_there_s
utterers8218653utterers
wagerers12247613wagerers
wanderers13228483wanderers
waterers112312793waterers
waverers14318613waverers
whereas13448903_whereas
wheres125917443_where_s
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 Limit1461621387.57619292.8
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.06222164.6
 
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.