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

108 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
endlong93482(None) 
ending83220252end_ing
enduing9249722enduing
erelong835592erelong
headlong1334122headlong
addling10229833addling
agelong934983agelong
along65419493__along
analog7159973analo_g
aneling82719503aneling
angling92816043angling
ankling122912063ankling
belong93411043_belong
bending114420893bend_ing
bundling12219703bundling
candling122313873candling
codling114418953codling
dandling112511733dandling
daylong1233973daylong
dendron947653dendron_
dendrons1047393dendrons
dindling112411163dindling
dong66031653__d_ong
eagling91113603eagling
eanling81416673eanling
eddying1335293eddying
edging93510713e_dging
eidolon844913eidolon_
eidolons944983eidolons
enabling1138603enabling
enclose9910003enclose
enclosing1257583enclosing
endings92910443end_ings
enditing10311073enditing
endleaf1145223endleaf
endless839833endless
endmost1056763endmost
endnote855743endnote
endow94510983end_o_w
endowing13178173endowing
endows104610423end_ows
endpoint1147103endpoint
endrin7312403endrin_
endrins8312163endrins
enduring10310013enduring
enhaloing1345363enhaloing
enisling949633enisling
enology11239813enology
enplane939723enplane
ensiling9410723ensiling
ensuing8239543ensuing
enuring8813883enuring
envying1435713envying
epilog976463epilo_g
etalon648973etalon_
etalons739073etalons
exiling15311083exiling
fending123717603fend_ing
flong95815683__flong
fondling13189353fondling
furlong11295413furlong
gentling1048453gentling
godling103513403godling
handling132312713handling
hondling132210013hondling
idling8912883_idling
induing91910943induing
inkling122911303inkling
kalong1177703_kalong
kindling14229623kindling
klong105310403__klong
ladling92813393ladling
lending94118533lend_ing
long56933343___long
meddling13257933meddling
mending114018683mend_ing
needling10248753needling
nylon82910513_nylon_
nylons9267973_nylons
oblong935383_oblong
oolong738073_oolong
peddling13217973peddling
pending114119773pend_ing
pindling122110983pindling
prolong10319633prolong
reddling112911813reddling
reedling102414273reedling
rending93924263rend_ing
sandling102214413sandling
seedling102610953seedling
sending94221373send_ing
sidelong10133983sidelong
sidling9915423sidling
tending94419163tend_ing
tendon7312033tend_on_
tendons8311473tend_ons
unclog956603unclo_g
undoing9312243undoing
undone7914253und_one
undying1238503undying
unsling8313643unsling
unslung844563unslung
vending124015263vend_ing
weeklong1641323weeklong
wending123816843wend_ing
windling132212263windling
yearlong12102573yearlong
yodling123610253yodling

Search took 7 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 Limit1340271086.36021073.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.81226231.8
 
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.