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

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

149 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
ended7442126(None) 
bended105521231bended
ender64325861ender
endued83910371endued
fended114216911fended
mended104418681mended
pended103819011pended
rended84524101rended
sended85121231sended
tended83819481tended
vended114416351vended
wended113616151wended
added84918432added
aided75828932aided
amended11328312amended
anted66328242anted
banded105223172banded
beaded104922422beaded
bedded115114072bedded
bendee94121022bendee
bender95223302bender
bided95424962bided
blended114710712blended
boded95124962boded
bonded104719952bonded
ceded96118562ceded
censed94016322censed
coded95433182coded
deeded94615542deeded
denied84318632denied
denned84215632denned
dented84120512dented
denuded10167662denuded
duded84417132duded
eared65139502eared
eased65430402eased
eaved95924502eaved
ebbed104111002ebbed
eched116919222eched
eddied9248322eddied
edged85514532edged
egged85114392egged
eide55832232eide_
eider64624742eider
eked96718022e_ked
elder64020022elder
elided84814672elided
eluded84612772eluded
embed105014302embed
emended11329602emended
encoded1139032encoded
end46834352en__d
endear74110012endear
enders74324052enders
endited93512912endited
endow94510982endow
endowed1248172endowed
ends56528522end_s
endue64215352endue
endues73813902endues
endured93611212endured
ennead736252ennead
ensued73610482ensued
enter54726382enter
enured73315332enured
envied1038832envied
eroded84313582eroded
erred65915672erred
evaded1137062evaded
exed125420592e_xed
exuded15317682exuded
eyed86623232e_yed
faded105025242faded
fenced124412712fenced
fender103718722fender
feuded114010002feuded
fonded115717042fonded
funded114413892funded
gelded94512112gelded
gender83517932gender
haded105227622haded
handed114919982handed
headed114020472headed
heeded114215762heeded
hented104218752hented
herded114215642herded
hided105222442hided
indeed83913562indeed
index13310982index
indued83411652indued
inked104218522inked
inned64118422inned
jaded144417032jaded
kenned114411272kenned
kneed104612052kneed
laded74232612laded
landed84619242landed
leaded84221542leaded
lender73921272lender
lensed74015472lensed
melded104714712melded
mender93520792mender
mensed93916542mensed
minded103817832minded
need54934152_need
needed84114442needed
nided75920872nided
penned94217612penned
ponded105218772ponded
redded94019552redded
reded74829122reded
reeded84022562reeded
render74024142render
rented74426592rented
rinded84418982rinded
sanded84920612sanded
scended11329872scended
seeded84520462seeded
sender73824412sender
sensed73918162sensed
sided74825952sided
sned56026052sn_ed
tedded93810902tedded
tender74121842tender
tensed74817832tensed
tented74221002tented
tided76322512tided
trended94011762trended
unde55825482unde_
undead82711902undead
undee65327272undee
under64624212under
undid72415362undid
undyed1138142undyed
unended92811822unended
unfed94614222unfed
unled64021072unled
unwed94114872unwed
upended11267322upended
vendee105617262vendee
vender103418422vender
venged114011992venged
vented104617922vented
waded106024752waded
wedded123811842wedded
weeded113914872weeded
welded114013382welded
winded114918212winded
yenned10409382yenned

Search took 2 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 Filter178691538000.300595636.7
2DLD Change Limit538001491.60633499.4
3Display Results1491490.0334515.2
 (SQL Overall)1786911491.93992156.3
 
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.