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

63 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
endnote85574(None) 
endnotes945941endnotes
endite73817592end_ite
headnote1245022headnote
adnate72913483_adnate
andante8311273andante
banknote1444833banknote
cenote83715843_cenote
connote9311613connote
dendrite1048783dendrite
denote74118043_denote
dote55442883__d_ote
ebonite9310293ebonite
emanate9312473emanate
emote75421193e__mote
enate54428153e__nate
enclose999993enclose
encode9310443en_code
encore8314773en_core
endgame1145233endgame
endited93512913end_ited
endites83717063end_ites
endive103310473end_ive
endlong934823endlong
endmost1056763endmost
endogen938613end_ogen
endorse879203endorse
endosome1146803endosome
endostea944953endostea
endow94510983end_o_w
endowed1248173end_owed
endower1138483end_ower
endows104610423end_ows
endplate1147083endplate
endue64215353end__ue
endure74014143end_ure
endwise1136463endwise
ennoble935633en_noble
ennuye973753en_nuye
enrobe86610793en_robe
enroot6615993enroot_
enrooted977423enrooted
enroots738713enroots
ensnare767123ensnare
entente7412953entente
epazote1843703epazote
epidote1037393epidote
headnotes1344653headnotes
indite73520323ind_ite
indole74516053ind_ole
innate63917313in_nate
keynote1443903keynote
neonate7311333neonate
note46239963___note
pennate93314033pen_nate
undone7914253und_one
unknot1037413unknot_
unknots1144303unknots
unnoted8311363un_noted
unquote1645903unquote
venenate1147933venenate
venenose1144023venenose
woodnote1244153woodnote

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 Filter1786911340270.406440125.6
2DLD Change Limit134027637.04619021.7
3Display Results63630.0163937.5
 (SQL Overall)178691637.46823927.6
 
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.