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

160 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
rended8452410(None) 
bended105521231bended
ended74421261_ended
fended114216911fended
mended104418681mended
pended103819011pended
redded94019551redded
reded74829121re_ded
reeded84022561reeded
render74024141render
rented74426591rented
rinded84418981rinded
sended85121231sended
tended83819481tended
trended94011761trended
vended114416351vended
wended113616151wended
amended11328312amended
banded105223172banded
beaded104922422beaded
bedded115114072bedded
bendee94121022bendee
bender95223302bender
blended114710712blended
bonded104719952bonded
branded114414102branded
breaded115014062breaded
brinded115112052brinded
ceded96118562ce_ded
censed94016322censed
deeded94615542deeded
denied84318632denied
denned84215632denned
dented84120512dented
denuded10167662denuded
dreaded103612022dreaded
emended11329602emended
ender64325862_ender
endued83910372_endued
eroded84313582eroded
fenced124412712fenced
fender103718722fender
feuded114010002feuded
fonded115717042fonded
friended1335032friended
fronded12388862fronded
funded114413892funded
gelded94512112gelded
gender83517932gender
grinded104210632grinded
handed114919982handed
headed114020472headed
heeded114215762heeded
hented104218752hented
herded114215642herded
kenned114411272kenned
landed84619242landed
leaded84221542leaded
lender73921272lender
lensed74015472lensed
melded104714712melded
mender93520792mender
mensed93916542mensed
minded103817832minded
needed84114442needed
penned94217612penned
ponded105218772ponded
radded94716492radded
raided85017702raided
ranged84824312ranged
ranked114620742ranked
ranted74324702ranted
readd74617132read_d
readded103310732readded
reader73628292reader
readied93316622readied
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
rebred95816352rebred
receded112713042receded
recked134821802recked
recoded113115032recoded
redd66323172re_d_d
redden83613622redden
redder83918142redder
reddled102912322reddled
rede55037672re_de_
redes65139132re_des
redid74922392re_did
redyed114611242redyed
reed55549622re__ed
reefed103816582reefed
reeked113717642reeked
reeled74725532reeled
reeved104118712reeved
refed93921922re_fed
refeed104717622refeed
reffed134712512reffed
refunded1336952refunded
reindex1536092reindex
reined74425522reined
reinked1239792reinked
reived104518132reived
relanded102410462relanded
relied74926232relied
remanded123011322remanded
remended123010392remended
reminded123411522reminded
renamed103114522renamed
rend56136572ren__d
rendered102512262rendered
renders83821672renders
rends65129952rend_s
reneged92010762reneged
renew83917512ren_ew
renewed11309992renewed
rennet64624852rennet
rente54733782rente_
renter64527412renter
rentes65431192rentes
repled93319782repled
repped114616722repped
reseed74823292reseed
resided95217702resided
rested74430782rested
retied75924982retied
retted74826312retted
reused75419562reused
revved13469722revved
rewed95425452re_wed
rewinded13277672rewinded
ridded93615122ridded
ringed84623842ringed
rinsed75016352rinsed
rodded93713702rodded
rondel73212642rondel
rounded93013502rounded
sanded84920612sanded
scended11329872scended
seeded84520462seeded
sender73824412sender
sensed73918162sensed
tedded93810902tedded
tender74121842tender
tensed74817832tensed
tented74221002tented
treaded95014282treaded
unended92811822unended
upended11267322upended
vendee105617262vendee
vender103418422vender
venged114011992venged
vented104617922vented
wedded123811842wedded
weeded113914872weeded
welded114013382welded
winded114918212winded
yenned10409382yenned

Search took 3 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 Filter178691825510.356501941.0
2DLD Change Limit825511602.25036689.3
3Display Results1601600.0463478.3
 (SQL Overall)1786911602.65267379.7
 
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.