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

379 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
potable11211536(None) 
notable92114901notable
pokable15209501pokable
portable12313201portable
posable112212781posable
potables12179701potables
totable92313361totable
votable122111371votable
actable11313472actable
bitable11312202bitable
boatable121610262boatable
bootable12179222bootable
citable11313462citable
codable12311662codable
datable101714232datable
doable93115242do_able
dowable13189452dowable
eatable91717602eatable
getable101712552getable
hatable121713962hatable
losable91910952losable
lovable12179552lovable
movable14189432movable
mutable11312302mutable
notables10178242notables
notably12199992notably
parable111819782parable
payable141711322payable
pettable121710712pettable
pitiable1238292pitiable
pivotable1644562pivotable
pliable111610322pliable
plowable1535912plowable
pointable1337342pointable
portables1337872portables
portably1539312portably
potage92715902pota_ge
pothole12312172pothole
pottle84416102pot_tle
pourable1239132pourable
probable1439052probable
provable1539092provable
quotable1936492quotable
ratable91717552ratable
retable91820402retable
ropable111611332ropable
rowable121510302rowable
sortable10312482sortable
sowable121610752sowable
spottable1345342spottable
stable83921642_stable
table75429602__table
toteable1048352toteable
towable121910112towable
vocable14189672vocable
voteable1347212voteable
abatable1238023abatable
able66340533___able
addable11218843addable
adoptable1444753adoptable
adorable1138773adorable
affable15117403affable
agitable1138583agitable
amiable11312033amiable
apposable1545603apposable
arable81821003_arable
atonable1038793atonable
avowable1635453avowable
beatable121612243beatable
biteable1237933biteable
bobble94115143bo_bble
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
bottle84916073bot_tle
buyable1437493buyable
cable95329913__cable
capable13313363capable
cartable121314093cartable
castable121613973castable
citeable1238413citeable
closable12168003closable
cobble123615263co_bble
coble94823173co__ble
cogitable1446943cogitable
coinable12311583coinable
constable13311003constable
cookable16147973cookable
copyable1736623copyable
coracle112011723coracle
countable1348853countable
covetable1648163covetable
curable112414513curable
cuttable1247953cuttable
dateable1149443dateable
denotable1238373denotable
deportable1545653deportable
deposable1446833deposable
deputable1487043deputable
disable10516433disable
dotage82711613dota_ge
dotal64919623dota_l_
dottle74212503dot_tle
double94013993do_uble
doubtable1445163doubtable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dutiable1137373dutiable
dyable12308983_dyable
dyeable1337303dyeable
eatables10169793eatables
editable11310423editable
effable15106673effable
enable83318483_enable
equable1849253equable
erodable1139203erodable
errable9312183errable
evitable1339323evitable
evocable1537103evocable
exorable1738933exorable
exportable2144603exportable
exposable2044793exposable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
finable122213623finable
fittable1337093fittable
fixable19218193fixable
floatable1444983floatable
flyable15307123flyable
foamable1537043foamable
foible11410383fo_ible
foilable1338063foilable
foldable1437133foldable
fordable1439593fordable
formable1539503formable
friable122612563friable
fryable15277463fryable
gable85325523__gable
gelable101710733gelable
gettable11178133gettable
giftable1465893giftable
gobble113512983go_bble
growable1435623growable
gustable11138203gustable
hateable1339373hateable
heatable131612043heatable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
hittable1336853hittable
hobble133913433ho_bble
holdable1437073holdable
huntable1338093huntable
imitable1239123imitable
importable1646553importable
imposable1546443imposable
imputable1546683imputable
instable10313203instable
isolable1038793isolable
joinable1737283joinable
knowable1745043knowable
liable81415813_liable
liftable1376863liftable
likable13219413likable
linable92214343linable
listable10810313listable
livable122010323livable
loanable1037613loanable
locale83915653loca_le
locatable1345573locatable
lockable1636953lockable
lovably15187063lovably
loveable13187903loveable
makable15510203makable
meltable12310473meltable
minable112315073minable
mixable18259173mixable
mockable1846643mockable
moldable1337103moldable
morale85220553mora_le
motile83818343mot_ile
mottle84116053mot_tle
mountable1346303mountable
movables15175573movables
movably17167043movably
moveable15168013moveable
mutably1438613mutably
namable11312343namable
nestable101613673nestable
nettable101610243nettable
nobble103814313no_bble
noble74420993no__ble
notal55221353nota_l_
notate63217863nota_te
openable1247013openable
operable12410323operable
opposable1544063opposable
oracle84313293_oracle
outfable1378813outfable
ownable1237283ownable
packable1838633packable
padle84522343p__adle
paintable1337243paintable
palatable1346383palatable
pale66055013p__a_le
palpable1448033palpable
parables121613573parables
parle75836163p__arle
parolable1347113parolable
parsable12311693parsable
partible1238073partible
passable12310633passable
patchable1845633patchable
pawnable1535983pawnable
payables15166493payables
payably17177093payably
pebble1238003p_ebble
peccable1648123peccable
peelable1238563peelable
pentacle1239383pentacle
petabyte1542783petabyte
petal76526893peta_l_
petaled103614153peta_led
petalled1138713petalled
petals84719813peta_ls
petiole9311303petiole
petrale9312623petrale
pettle84116053pet_tle
pitiably1545843pitiably
placable14169243placable
plantable1337273plantable
playable15137923playable
pliably14147383pliably
poachable1846243poachable
pocketable2043593pocketable
pole65951303po___le
pomace123111913poma_ce
pomade113611333poma_de
poodle93112043po_odle
popple92710983po_pple
portage103013643porta_ge
portal84218463porta_l_
portaled11239203porta_led
portals94015563porta_ls
portance12310123portance
porthole1349523porthole
posole8314223po_sole
possible1245813possible
postage103214853posta_ge
postal84317533posta_l_
postally13310273postally
postals93716383posta_ls
postbase1246443postbase
posthole1339533posthole
potages102416423potages
potamic13310853potamic
potash1138273pota_sh
potashes1337833potashes
potato8513433pota_to
potatoes1039943potatoes
potboy1397813pot_boy
potence11711363potence
potful1138083potful_
potfuls1236293potfuls
potholed1448393potholed
potholes13312933potholes
potiche1438043potiche
potlache15114283potlache
potlike13910123potlike
potline91015233potline
potpie103412433pot_pie
potsie83916033pot_sie
pottage103310603pottage
pottles93816983pot_tles
pozole1758913po_zole
prattle9208833prattle
preamble1436383preamble
printable1338203printable
probables1545433probables
probably1746413probably
profitable1744963profitable
promotable1645033promotable
protyle12229453prot_yle
provably1846213provably
prunable1237843prunable
quotably2244153quotably
ratables10159723ratables
ratably121711513ratably
rateable10311443rateable
rentable101716333rentable
reportable1446953reportable
reputable1379123reputable
restable101618443restable
retables101712673retables
ridable101412493ridable
roble75223023ro__ble
rockable1638013rockable
rotatable1146653rotatable
rotate63320343rota_te
rouble83913313ro_uble
rulable9310533rulable
rustable101511363rustable
sable74732163__sable
salable91415463salable
satiable10310733satiable
savable121711863savable
sayable121411613sayable
seeable91113943seeable
sewable121911173sewable
showable1636583showable
sizable1839893sizable
skiable1338883skiable
smokable1636223smokable
sociable1239503sociable
soluble966103soluble
solvable1337473solvable
sorbable1239303sorbable
sortably1338803sortably
sparable121611983sparable
spoilable1345163spoilable
stabile9312063_stabile
stabled103514953_stabled
stabler94014933_stabler
stables93219073_stables
stably113314123_stably
stale55637103_sta_le
staple84415823_staple
statable10310703statable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553_suable
suitable10310893suitable
tabla73318363__tabla
tabled94020043__tabled
tables84524893__tables
tablet84227643__tablet
takable13310193takable
tale46154163__ta_le
tamable11312853tamable
tastable101511973tastable
taxable1639073taxable
tenable93214493tenable
testable101412623testable
tiltable10159013tiltable
tithable1336853tithable
titrable1038963titrable
total55321823tota_l_
totaled839693tota_led
totalled935843totalled
totally1039893totally
totals63115163tota_ls
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
unstable10313763unstable
usable84012553_usable
useable9911063useable
vaporable1645543vaporable
viable111613773_viable
violable1337543violable
vitiable1337503vitiable
vocables15145733vocables
vocably17157153vocably
voidable1466853voidable
voluble1244503voluble
wadable13310233wadable
wastable131410453wastable
waxable1937673waxable
wettable13148043wettable
wirable121610963wirable
wobble133212313wo_bble
workable1737093workable
worktable1844723worktable
writable1338753writable

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273797.08018930.4
3Display Results3793790.1402707.1
 (SQL Overall)1786913797.64023388.9
 
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.