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

376 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
adhere1031033(None) 
adhered1239231adhered
adherer1137571adherer
adheres11310161adheres
achene11313812achene
adder75419592adder_
adders84315702adders
adherend1343862adherend
adherent1247782adherent
adherers1296922adherers
adjure1435842adjure
admire949932admire
adore65723672ad_ore
adverb12265412adverb
adverse1145952adverse
advert103215782advert
ampere10514412ampere
ashore9414612ashore
cohere112716992cohere
dere56845902_d_ere
here76447102__here
inhere9313712inhere
sphere113313662sphere
there87527392_there
where117019422_where
aahed917816443aahe_d
abele76323253a_bele
abhenry1543333abhenry
abhor10411063abhor_
abhors11410623abhors
abjure1536743abjure
abler75624313abler_
accede1138303accede
acerb9312763a_cerb
ache96829823ach__e
ached119227833ache_d
achenes12313493achenes
aches106132293ache_s
achier113914263achier_
achieve1545023achieve
ackee115825373acke_e
acre67330773a__cre
adage7414053ad_age
added84918433adde_d
addend9458453addend
addle74318353ad_dle
adduce1076453adduce
adeem8311803ad_eem
adeemed1145393adeemed
adeems946333adeems
adept81219643ad_ept
adherable1545003adherable
adherence1564893adherence
adherends1443263adherends
adherents1345553adherents
adhering1338883adhering
adhesive1543803adhesive
adieu6417423adie_u
adieus739633adieus
adieux1444283adieux
adjured1634883adjured
adjurer1534823adjurer
adjures1536233adjures
admen84516183adme_n
admired1135703admired
admirer1035523admirer
admires1038663admires
adnate72913483adnate
adnexa1433673adnexa
adobe84814713ad_obe
adored84714243adored
adorer74713453adorer
adorers84411733adorers
adores74420723adores
adorn64917093ad_orn
adoze155713833ad_oze
adsorb946953adsorb
advect12309123advect
advent102613753advent
adverbs13254273adverbs
adverted1336103adverted
adverts11308513adverts
advice12107883advice
advise10139223advise
adze1412820573ad__ze
adzed166012543adze_d
adzes155913803adze_s
aerie54634603a__erie
aero45435343a__ero
aery77231683a__ery
aether94213673aether_
aethers103614943aethers
afire86215913a_fire
afore85818603a_fore
after85719793after_
afters94717073afters
agee56241493a_ge_e
agene65621583a_gene
ager55935843a_ger_
agers65027853a_gers
agger76420893agger_
aggers85817793aggers
aglare7312423aglare
aglee65728493agle_e
agree65226033agre_e
ahead96817053a_head
ahed89536253a_he_d
ahem97225363a_he_m
ahorse9311513a_horse
aider65431133aider_
aiders74524633aiders
aimer75926823aimer_
aimers84621913aimers
airer54927893airer_
airers64922313airers
aiver85725163aiver_
aivers94822323aivers
ajee115928233a_je_e
akee85936813a_ke_e
akene95818663a_kene
alder65421913alder_
alders74218423alders
alee46652323a_le_e
alert54740653a_lert
alkene104114003alkene
allee54932123alle_e
allege74314653allege
allele64514563allele
allure63012943allure
alter54828503alter_
altered83215733altered
alterer72713993alterer
alters64924223alters
ambeer104511603ambeer
amber94523213amber_
ambers104519583ambers
ambery133811133ambery
ameer75618983ameer_
ameers84015573ameers
amerce10310513a_merce
amperes11313983amperes
anele55628833a_nele
anger66225873anger_
angered93013473angered
angers75222543angers
annexe1337813annexe
anther93715063anther_
anthers103715203anthers
antre55224523a_ntre
anywhere1742563anywhere
aper66336233a_per_
apers76629133a_pers
apery106517903a_pery
apheses12610703apheses
apiece10510083apiece
apter76120203apter_
archer115016243archer_
archers124414573archers
archery15478063archery
are37874573a___re
areae55229743a_reae
arene55329413a_rene
arete56031353a_rete
armer76924443armer_
armers85520273armers
armure8710133armure
artery9911453artery
ashed97829773ashe_d
ashen87818673ashe_n
ashes86230613ashe_s
ashier94714833ashier_
ashler9459973ashler_
ashlered1244623ashlered
ashlers10319583ashlers
asker96418783asker_
askers105915403askers
asper75520433asper_
aspers86220313aspers
asperse94210663asperse
aspire8612123aspire
assert64922583assert
assure6610773assure
aster55434893aster_
astern64815813astern
asters65631603asters
athlete1068083athlete
attire62412383attire
auberge1045633auberge
auger64922473auger_
augers73818703augers
austere7312993austere
aver75931883a_ver_
avers85127313a_vers
averse95811183a_verse
avert86029493a_vert
aware86420023a_ware
awee76336643a_we_e
awhile1257793awhile
awhirl1264673awhirl
azure14911483a_zure
badder103817513badder_
badger105415083badger_
badgered1336213badgered
badgers114812653badgers
basher115123813basher_
bashers124820833bashers
bather115322513bather_
bathers124720363bathers
cadger105013913cadger_
cadgers114712003cadgers
cadre85419023cad__re
cashmere1564323cashmere
cere66741473__cere
chare105231983_chare
cheer105420383_cheer
chert105232103_chert
chevre14318313_chevre
chore105126763_chore
cohered133514693cohered
coherer122912783coherer
coheres122917693coheres
dare55848863_d_are
darer65230793darer_
darers75921873darers
dasher104318983dasher_
dashers115016863dashers
dater65332313dater_
daters74827373daters
dee47665823_d_e_e
deer56739023_deer_
deers64930523_deers
deke95228763_d_eke
dele56843083_d_ele
deme76536283_d_eme
dene56643413_d_ene
derm76031893_d_erm
dhole95215363_dhole
diene65720133_diene
dire56644143_d_ire
doer57734703_doer_
doers65225713_doers
dore56353303_d_ore
dree56638323_dre_e
dure56341813_d_ure
dyer85522113_dyer_
dyers96617133_dyers
edger75215953edger_
edgers84413923edgers
ephebe1336063ephebe
ere36352773___ere
ethene93312923ethene
ether84518773ether_
ethers94518413ethers
fader94421513fad_er_
faders105117463fad_ers
father125116713father_
fathered151510433fathered
fathers133916503fathers
fere76342233__fere
frere85617723_frere
gadder93714713gadder_
gadders103611503gadders
galere73716673galere
gasher104320373gasher_
gather104115853gather_
gathered13149373gathered
gatherer12147903gatherer
gathers114315073gathers
ghee85726113_ghe_e
hachure1545723hachure
hadjee174111823hadje_e
haltere103614703haltere
hare76255733__hare
hebe96424703__hebe
heme95034413__heme
her66547813__her_
herb94730963__herb
herd84933063__herd
heres86245903__heres
herl75834553__herl
herm95636153__herm
hern76134893__hern
hero74635783__hero
hers75844873__hers
hire75538963__hire
idler65015663idler_
idlers74012813idlers
inhered11313163inhered
inheres10315173inheres
ither84617603ither_
kasher134915033kasher_
kashered1636403kashered
kashers143914023kashers
ladder84617623ladder_
laddered1136743laddered
ladders94115173ladders
lader65633723lad_er_
laders74927763lad_ers
ladler74314933ladler_
ladlers84613573ladlers
lasher94824533lasher_
lashers104121833lashers
lather95124353lather_
lathered121512323lathered
latherer111310443latherer
lathers104321883lathers
lathery133911123lathery
machete14310883machete
machree1438513machree
madder103515593madder_
madders113513213madders
madre85720173mad__re
masher114123203masher_
mashers124621053mashers
mere67244443__mere
nowhere1337213nowhere
ocher104516103ocher_
ochered132610283ochered
ochers113915303ochers
ochery14319443ochery
ochre103411593och_re
odder74515393odder_
other84219103other_
others93918003others
padder103415493padder_
padders113312873padders
padre86018163pad__re
pere66450263__pere
quaere154110673quaere
rasher95024123rasher_
rashers104020913rashers
rather94319743rather_
rehire95415863rehire
revere94621253revere
rheme106214053_rheme
sadder82916973sadder_
sadhe94815133sadh__e
sadhes104715373sadhe_s
scheme1379633scheme
sere46153473__sere
severe94016083severe
share86437083_share
sheer84726893_sheer
sherd96321153_sherd
shire84727133_shire
shore85432653_shore
sphene113412403sphene
sphered133512313sphered
spheres123114353spheres
sphery14318883sphery
stere55328543_stere
thebe107515433_thebe
thee78039063_the_e
theme105921733_theme
theres96525473_theres
therm106018023_therm
therme115814993_therme
these86519013_these
three87526913_three
tuyere9408613tuyere
udder76314283udder_
udders83911293udders
usher84517763usher_
ushered1139153ushered
ushers94415533ushers
wadder114215483wadder_
wadders123812443wadders
wader95325363wad_er_
waders109120643wad_ers
washer124720393washer_
washers134517523washers
were76238333__were
whee105429593_whe_e
wheres125917433_wheres
wherve15568113_wherve
whore116018043_whore

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 Filter1786911127160.390458182.1
2DLD Change Limit1127163765.51320445.5
3Display Results3763760.1103418.2
 (SQL Overall)1786913766.01329717.4
 
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.