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

203 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
vendable1415969(None) 
bendable131510851bendable
lendable11169461lendable
mendable131510581mendable
sendable111612041sendable
vendables15165151vendables
vendible14156471vendible
amendable1446052amendable
beddable14166922beddable
bindable13169622bindable
bondable13169272bondable
deniable11312082deniable
emendable1446232emendable
enable83318482_en_able
evadable1436362evadable
feedable1437672feedable
findable14179022findable
readable11313162readable
rendible11128352rendible
rentable101716332rentable
sandable111612822sandable
spendable1446462spendable
tenable93214492ten_able
vendace1357362venda_ce
vendibles15164582vendibles
vendibly17174472vendibly
venerable1438482venerable
voidable1466852voidable
weldable1436862weldable
windable14159152windable
addable11218843_addable
amenable1238863amen_able
ascendable1543983ascendable
averrable14105413averrable
avertable14117343avertable
avoidable15124743avoidable
bankable1677913bankable
bannable1278353bannable
bearable121512363bearable
beatable121612243beatable
bedabble1243703be_dabble
biddable14165673biddable
boundable1444843boundable
cenacle1139123cen_acle
codable12311663_codable
decidable1547223decidable
defendable1754983defendable
demandable1644343demandable
deniably1448553deniably
denotable1238373denotable
dependable1645793dependable
eatable91717603_eatable
edible969353_e_dible
effable15106673_effable
enabled102510633_en_abled
enabler9299363_en_abler
enables92813123_en_ables
encodable1446273_encodable
endurable1247733_endurable
ennoble935633_ennoble
enviable1337853_enviable
equable1849253_equable
erodable1139203erodable
errable9312183_errable
evadible1443973evadible
evitable1339323evitable
evocable1537103evocable
expendable2243873expendable
extendable2043833extendable
eyeable1239063_eyeable
fadable13310463_fadable
fellable13179133fellable
fenagle11197153fen_agle
fencible1545603fencible
finable122213623fin_able
fineable131810333fineable
foldable1437133foldable
fordable1439593fordable
gelable101710733ge_lable
gendarme1243523gendarme
generable1238663generable
getable101712553ge_table
gettable11178133gettable
gradable1238823gradable
guidable1236203guidable
hangable1438213hangable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
helpable1536603helpable
hewable15177823he_wable
hidable1399403_hidable
holdable1437073holdable
huntable1338093huntable
inedible1147473inedible
keepable1635323keepable
kneadable1645673kneadable
laudable1137893laudable
leasable101510133leasable
leviable1337513leviable
lienable10188693lien_able
linable92214343lin_able
lineable101811083lineable
linkable14187263linkable
mandible1337543mandible
meltable12310473meltable
minable112315073min_able
mineable121611053mineable
moldable1337103moldable
nestable101613673nestable
nettable101610243nettable
openable1247013open_able
overable13513573ove_rable
ownable1237283own_able
oxidable1865123oxidable
peccable1648123peccable
peelable1238553peelable
pentacle1239383pentacle
pettable121710713pettable
pleadable1445513pleadable
readably1438383readably
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
refundable1643803refundable
reliable10313073reliable
renderable1397153renderable
renewable1447433renewable
restable101618443restable
retable91820403re_table
reusable10811273reusable
ridable101412493_ridable
rinsable10310043rinsable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendal73314993senda_l_
sendals81912263senda_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
valuable1336863valuable
vandal103713833vanda_l_
vandals113211663vanda_ls
variable13310063variable
vegetable1545683vegetable
venae85920983ven_a__e
venal85523213ven_a_l_
venally13119563ven_ally
vendaces1457183vendaces
vendee105617263vend__ee
vendeuse1243023vendeuse
vendue10419013vend__ue
venerables1544353venerables
venerably1746423venerably
venial94218283venia_l_
venially1499423venially
ventage11109623venta_ge
ventail10310453ventail_
ventails1139823ventails
venule94411763ven__ule
veritable1448743veritable
vernacle1345583vernacle
viable111613773v__iable
viewable1635223viewable
vincible1544753vincible
vindicable1843903vindicable
violable1337543violable
vitiable1337503vitiable
vocable14189673v_ocable
votable122111373v_otable
voteable1347213voteable
wadable13310233_wadable
wearable131510553wearable
wettable13148043wettable
wieldable1543813wieldable
winnable13156983winnable
yieldable1543353yieldable

Search took 9 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.453394461.4
2DLD Change Limit1461622037.64019131.2
3Display Results2032030.0932182.8
 (SQL Overall)1786912038.18621828.9
 
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.