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

195 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
lendable1116946(None) 
bendable131510851bendable
mendable131510581mendable
sendable111612041sendable
vendable14159691vendable
amendable1446052amendable
beddable14166922beddable
bindable13169622bindable
bondable13169272bondable
deniable11312082deniable
emendable1446232emendable
enable83318482_en_able
feedable1437672feedable
findable14179022findable
laudable1137892laudable
leasable101510132leasable
leviable1337512leviable
lienable10188692lien_able
linable92214342lin_able
lineable101811082lineable
linkable14187262linkable
pleadable1445512pleadable
readable11313162readable
rendible11128352rendible
rentable101716332rentable
sandable111612822sandable
spendable1446462spendable
tenable93214492ten_able
vendables15165152vendables
vendible14156472vendible
weldable1436862weldable
windable14159152windable
addable11218843_addable
alienable1146933alien_able
amenable1238863amen_able
ascendable1543983ascendable
bankable1677913bankable
bannable1278353bannable
bearable121512363bearable
beatable121612243beatable
bedabble1243703be_dabble
biddable14165673biddable
boundable1444843boundable
cenacle1139123cen_acle
cleanable1345203cleanable
clearable1346013clearable
cleavable1644473cleavable
codable12311663_codable
decidable1547223decidable
defendable1754983defendable
demandable1644343demandable
deniably1448553deniably
denotable1238373denotable
dependable1645793dependable
eatable91717603_eatable
edible969353_e_dible
effable15106673_effable
electable13149623electable
elidible1164573elidible
enabled102510633_en_abled
enabler9299363_en_abler
enables92813123_en_ables
encodable1446273_encodable
endurable1247733_endurable
ennoble935633_ennoble
enviable1337853_enviable
equable1849253_equable
erodable1139203erodable
errable9312183_errable
evadable1436363evadable
expendable2243873expendable
extendable2043833extendable
eyeable1239063_eyeable
fadable13310463_fadable
fellable13179133fellable
fenagle11197153fen_agle
fencible1545603fencible
finable122213623fin_able
fineable131810333fineable
floodable1544013floodable
foldable1437133foldable
fordable1439593fordable
gelable101710733ge_lable
gendarme1243523gendarme
generable1238663generable
getable101712553ge_table
gettable11178133gettable
gleanable1244083gleanable
gradable1238823gradable
guidable1236203guidable
hangable1438213hangable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
helpable1536603helpable
hewable15177823he_wable
hidable1399403_hidable
holdable1437073holdable
huntable1338093huntable
inedible1147473inedible
keepable1635323keepable
kneadable1645673kneadable
lamentable1444203lamentable
landaulet1045323landaulet
lapsable12117383lapsable
laudably1445123laudably
leachable16136443leachable
learnable1145563learnable
legible1035833le_gible
liable81415813l__iable
licensable1443073licensable
liftable1376863liftable
likable13219413l_ikable
likeable14166473likeable
lindane839033linda_ne
listable10810313listable
livable122010323l_ivable
liveable13177663liveable
loanable1037613loanable
lockable1636953lockable
losable91910953l_osable
lovable12179553l_ovable
loveable13187903loveable
mandible1337543mandible
meltable12310473meltable
minable112315073min_able
mineable121611053mineable
moldable1337103moldable
nestable101613673nestable
nettable101610243nettable
openable1247013open_able
ownable1237283own_able
oxidable1865123oxidable
peccable1648123peccable
peelable1238553peelable
pentacle1239383pentacle
pettable121710713pettable
plantable1337273plantable
readably1438383readably
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
refundable1643803refundable
reliable10313073reliable
renderable1397153renderable
renewable1447433renewable
restable101618443restable
retable91820403re_table
reusable10811273reusable
ridable101412493_ridable
rinsable10310043rinsable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendal73314993senda_l_
sendals81912273senda_ls
sensible1037853sensible
servable13310093servable
sewable121911173se_wable
shedable1437423shedable
sheddable1643693sheddable
singable11159543singable
sinkable14178413sinkable
slidable1137953slidable
soundable1245983soundable
tannable1039383tannable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
tenably122210453ten_ably
tendance1147523tendance
tensible1037243tensible
tentacle1037693tentacle
tenurable1147423tenurable
testable101412623testable
tradable1139873tradable
tunable92511313tun_able
tuneable1038913tuneable
unable83819223_un_able
unbendable1545813unbendable
undoable1139053_undoable
unedible1146413unedible
vendace1357363venda_ce
vendibles15164583vendibles
vendibly17174473vendibly
venerable1438483venerable
voidable1466853voidable
wadable13310233_wadable
wearable131510553wearable
wettable13148043wettable
wieldable1543813wieldable
winnable13156983winnable
yieldable1543353yieldable

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621956.54622328.4
3Display Results1951950.0802437.5
 (SQL Overall)1786911957.03225411.1
 
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.