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

137 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
endearing113932(None) 
anearing9413972an_earing
endearingly1653222endearingly
endeavoring1652282endeavoring
enduring10310012end_uring
ensnaring1046382ensnaring
entering91920052ente_ring
gendering12249752gende_ring
nearing83020332_n_earing
rendering112213182rende_ring
tendering112210812tende_ring
unbearing1239352unbearing
undaring10412752und_aring
unendearing1343042unendearing
unfearing1338882unfearing
angering102113803ange_ring
annealing1047453annealing
appearing1436893appearing
bearing103624773__bearing
bendaying1634953bend_aying
besmearing1544323besmearing
blearing113111943_blearing
centering122915143cente_ring
cindering13311223cinde_ring
clearing113014883_clearing
dandering122511063dande_ring
daring84928683__d_aring
deairing10311893__deairing
dealing94323233__dealing
deaning94020473__deaning
deaving123814753__deaving
dogearing1235763dogearing
earing75235483___earing
enamoring1247033enamoring
encaging1258733en_caging
encasing11610823en_casing
enchasing1567733enchasing
enclaving1546313enclaving
encoring11312173en_coring
endamaging1543093endamaging
endbrain1144183endbrain_
endbrains1244063endbrains
endear74110013endear___
endeared1038053endear_ed
endearment13106963endearment
endears83710053endear__s
endeavouring1751453endeavouring
endexine1646083ende_xine
ending83220253end___ing
enditing10311073end_iting
endocrine1246183endocrine
endorsing1147303endorsing
endowing13178173end_owing
endplaying1742763endplaying
endrin7312403end__rin_
endrins8312163end__rins
enduing9249723end__uing
enfacing1467293en_facing
enfevering1743863enfevering
enflaming1545633enflaming
enframing1546113enframing
engaging1147373en_gaging
engraving1446013engraving
enlacing1148773en_lacing
enlarging1135803en_larging
enmeshing15114873enmeshing
enplaning1246803enplaning
enquiring19175443enquiring
enraging1049573en_raging
enserfing1345893enserfing
enslaving1345383enslaving
ensnarling1143223ensnarling
ensuring9310173en_suring
entreating11811553entreating
enuring8813883en__uring
fearing113520033__fearing
gandering122111293gande_ring
gearing92818843__gearing
hearing113324163__hearing
hindering14310273hinde_ring
ideating10311703_ideating
indenting11911263indenting
indexing1737123inde_xing
inferring1338613inferring
inhering12913713inhe_ring
insnaring1046313insnaring
interring10315423interring
inweaving1644773inweaving
kneading1436373kn_eading
meandering1446983meande_ring
nidering10510483nide_ring
nonbearing1346453nonbearing
ordering1039353orde_ring
pandering133211963pande_ring
pondering132411333ponde_ring
rearing83128783__rearing
regearing112211413regearing
rehearing132211763rehearing
renderings12256093rende_rings
retearing102214253retearing
rewearing132310703rewearing
searing83330923__searing
shearing123915903_shearing
smearing113511753_smearing
snaring83920953sn__aring
sneaking133211093sn_eaking
sneaping11349493sn_eaping
sneering93414503sn_eering
spearing113216103_spearing
sundering11312323sunde_ring
swearing123711443_swearing
tearing84021493__tearing
teddering12256303tedde_ring
tentering102313213tente_ring
uncaring11312843un_caring
unceasing1239653unceasing
underling111514613underling
underwing141410883underwing
undraping1337333undraping
undrawing1436903undrawing
unerring9311273un_erring
unleading1138673unleading
unlearning1144713unlearning
unmeaning1237953unmeaning
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unsparing1237713unsparing
unswearing1444413unswearing
unweaving1636133unweaving
upbearing1435033upbearing
uprearing1238373uprearing
uptearing1236103uptearing
veneering1337663ven_eering
wandering143310983wande_ring
wearing113318863__wearing
wondering142110463wonde_ring

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411377.09320956.0
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.57623586.5
 
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.