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

122 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
ensnared96529(None) 
ensnare767121ensnare_
ensnarer874471ensnarer
ensnares856891ensnares
ensnarled1042911ensnarled
insnared956121insnared
endeared1038052endeared
enslaved1245062enslaved
ensnarers983572ensnarers
ensnarl784912ensnar_l
ensnarls873392ensnarls
ensured83512942ens_ured
insnare748242insnare_
insnarer865302insnarer
insnares858082insnares
snared74824552__snared
unseared91113942unseared
unshared121510702unshared
unsnarled1035742unsnarled
aneared8512743an_eared
ansated84214003ans_ated
answered1235493answered
ascared10399523_ascared
censored11197953cens_ored
censured11248913cens_ured
eared65139503e___ared
emanated1139163emanated
enamored1147033enamored
encaged113211083en_caged
encased103512313en_cased
enchased1437383enchased
enclaved1456343enclaved
encored10412103en_cored
endured93611213en_dured
enfaced13218913en_faced
enflamed1455723enflamed
enframed1466263enframed
engaged10379833en_gaged
engraved1335813engraved
enhanced1436623enhanced
enlaced102410523en_laced
enlarged1035413en_larged
enplaned1137483enplaned
enquired18255793enquired
enraged93511783en_raged
enserfed1245193enserfed
ensilaged1143363ensilaged
ensiled82611433ens_iled
enskied1234653ens_kied
enskyed1532503ens_kyed
enslave1036273enslave_
enslaver1144713enslaver
enslaves1136393enslaves
ensnaring1046383ensnaring
ensouled935833ensouled
ensphered1565283ensphered
ensued73610483ens__ued
ensure63416003ens_ure_
ensurer73011903ens_urer
ensures73315903ens_ures
enswathed1642763enswathed
entered82718883en_tered
enured73315333e__nured
escaped12388853e_scaped
escarped1355163e_scarped
essayed1134013e_ssayed
estated83715573e_stated
hennaed1135103hen_na_ed
infrared1236193infrared
insnarers954433insnarers
inspired1136273inspired
instarred1043963instarred
instated91613343instated
insured83714253ins_ured
misnamed13127593misnamed
neared75119803_n_eared
pennated11299543pen_nated
scared95227293__scared
seared75232843__seared
sensated938193sens_ated
shared105829063__shared
snaked115017593__snaked
snare54429983__snare_
snarer64620843__snarer
snares65329033__snares
snarfed11378753__snarfed
snarled83612363__snarled
snawed104813733__snawed
snored74819543__snored
soared74324293__soared
spared95427493__spared
stared75429873__stared
unbeared111611653unbeared
unfeared121511013unfeared
unnamed102410273un_named
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unscarred1235673unscarred
unsealed91513623unsealed
unseamed111210663unseamed
unseated91317683unseated
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshaved15157733unshaved
unslaked1338463unslaked
unsnagged1243123unsnagged
unsnapped1443983unsnapped
unsnarl7107153unsnar_l
unsnarls894883unsnarls
unsoaked1338853unsoaked
unsoured9310063unsoured
unsquared1944073unsquared
unstarred1036363unstarred
unstated91615813unstated
unstayed12168393unstayed
unswayed15155713unswayed
upsoared11154353upsoared
upstared11156573upstared
venenated1345903venenated

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621227.47019566.5
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.93922508.0
 
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.