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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
ensnaring104638(None) 
ensnarling1143221ensnarling
insnaring1046311insnaring
endearing1139322endearing
enslaving1345382enslaving
ensuring9310172ens_uring
snaring83920952__snaring
unsnarling1143912unsnarling
unsparing1237712unsparing
anearing9413973an_earing
answering1345803answering
censoring1238783cens_oring
censuring1237603cens_uring
earing75235483e___aring
emanating1239003emanating
enamoring1247033enamoring
encaging1258733en_caging
encasing11610823en_casing
enchasing1567733enchasing
enclaving1546313enclaving
encoring11312173en_coring
enduring10310013en_during
enfacing1467293en_facing
enflaming1545633enflaming
enframing1546113enframing
engaging1147373en_gaging
engraving1446013engraving
enhancing1545823enhancing
enlacing1148773en_lacing
enlarging1135803en_larging
enplaning1246803enplaning
enquiring19175443enquiring
enraging1049573en_raging
enserfing1345893enserfing
enshrine1147263ens_hrine
ensilaging1243433ensilaging
ensiling9410723ens_iling
enskying1633283ens_kying
ensnare767123ensnar__e
ensnared965293ensnar_ed
ensnarer874473ensnar_er
ensnarers983573ensnarers
ensnares856893ensnar_es
ensnarl784913ensnar__l
ensnarled1042913ensnarled
ensnarls873393ensnar_ls
ensouling1046003ensouling
ensphering1644973ensphering
ensuing8239543ens__uing
enswathing1742683enswathing
entering91920053en_tering
enuring8813883e__nuring
escaping1347063e_scaping
escarping1435203e_scarping
essaying1235033e_ssaying
estating92614993e_stating
hennaing1234993hen_na_ing
inspiring1246183inspiring
instarring1144063instarring
instating10812213instating
insuring9311153ins_uring
misnaming1447423misnaming
nearing83020333_n_earing
scaring103421973__scaring
searing83330923__searing
sensating1039253sens_ating
sharing113723243__sharing
snaking123915303__snaking
snarfing12358663__snarfing
snarling92513183__snarling
snawing113612483__snawing
snoring83917203__snoring
soaring83521893__soaring
sparing104823873__sparing
staring84527053__staring
unbearing1239353unbearing
uncaring11312843un_caring
undaring10412753un_daring
unfearing1338883unfearing
unsaying1288153uns_aying
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unsnagging1342953unsnagging
unsnapping1542933unsnapping
unstating10711213unstating
unstring9312093uns_tring
unswearing1444413unswearing
upsoaring1244513upsoaring
upstaring1235963upstaring
venenating1446013venenating

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 Filter1786911486410.423422437.4
2DLD Change Limit148641917.53019739.8
3Display Results91910.0332757.6
 (SQL Overall)178691917.98622375.5
 
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.