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 “unendearing” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
unendearing134304(None) 
endearing1139322__endearing
engendering1453083engende_ring
gendering12249753_gende_ring
nonbearing1346453_nonbearing
rendering112213183_rende_ring
tendering112210813_tende_ring
unbearing1239353u__nbearing
undaring10412753u__nd_aring
unending10239943unend___ing
unfearing1338883u__nfearing
unswearing1444413un_swearing
anearing9413974__an_earing
annealing1047454an_n_ealing
bendaying1634954_bend_aying
besmearing1544324_besmearing
blundering1444824blunde_ring
calendaring1553004calend_aring
calendering1543474calende_ring
centering122915144_cente_ring
cindering13311224_cinde_ring
coenduring1444234coend_uring
dandering122511064_dande_ring
daundering1364464daunde_ring
degendering1543634degende_ring
emendating1444614emend_ating
endearingly1653224__endearingly
endeavoring1652284__endeavoring
enduring10310014__end_uring
ensnaring1046384__ensnaring
entering91920054__ente_ring
foundering1545354founde_ring
gandering122111294_gande_ring
hindering14310274_hinde_ring
insnaring1046314insn__aring
inundating1244544inund_ating
laundering1245184launde_ring
lavendering1642134lavende_ring
maundering1455354maunde_ring
meandering1446984meande_ring
nearing83020334___n_earing
neutering1038964_neute_ring
niddering1255324_nidde_ring
nidering10510484_n_ide_ring
nonearning1145184_non_earning
nonreading1246884_nonreading
overbearing1748424overbearing
overdaring1539504overd_aring
overfearing1847554overfearing
overhearing1847844overhearing
overwearing1847714overwearing
pandering133211964_pande_ring
plundering1444174plunde_ring
pondering132411334_ponde_ring
preclearing1645104preclearing
reentering1149984reente_ring
regearing112211414_re_gearing
rehearing132211764_re_hearing
renderings12256084_rende_rings
retearing102214254_re_tearing
rewearing132310704_re_wearing
slandering1237244slande_ring
sneering93414504sne__e_ring
sundering11312324_sunde_ring
surrendering1452034surrende_ring
teddering12256304_tedde_ring
tentering102313204_tente_ring
thundering1544574thunde_ring
unanchoring1752184unanchoring
unappealing1652194unappealing
unbandaging1651254unband_aging
unbending1337464unbend___ing
uncaring11312844u__n_caring
unceasing1239654u__nceasing
uncovering1645294uncove_ring
uncreating13310474un_creating
undereating1369554undereating
underheating1785134underheating
underling111514614u__nderling
underwing141410884u__nderwing
undraping1337334u__ndraping
undrawing1436904u__ndrawing
unedifying1843724une_difying
unerring9311274u__n_erring
unfettering1543704unfette_ring
uninspiring1451954uninspiring
unkenneling1651624unkenne_ling
unkennelling1751144unkennelling
unleading1138674u__nleading
unlearning1144714u__nlearning
unmeaning1237954u__nmeaning
unmitering1345004unmite_ring
unnerving1336634un_n_erving
unpleasing1344774un_pleasing
unsealing10711044u__nsealing
unseaming1278114u__nseaming
unseating10713204u__nseating
unsnarling1143914unsn__arling
unsoldering1342674unsolde_ring
unsparing1237714u__nsparing
unspeaking1744424un_speaking
unsphering1644284unsphe_ring
untethering1543684untethe_ring
unthreading1644154unthreading
untreading1247564un_treading
unwavering1743224unwave_ring
unweaving1636134u__nweaving
upbearing1435034u__pbearing
upending12258134upend___ing
uprearing1238374u__prearing
uptearing1236104u__ptearing
veneering1337664_ven_eering
wandering143310984_wande_ring
wondering142110464_wonde_ring

Search took 10 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 Filter1786911488190.440406115.9
2DLD Change Limit1488191149.21616147.9
3Display Results1141140.0631809.5
 (SQL Overall)1786911149.71918385.7
 
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.