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

188 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
bootable1217922(None) 
boatable121610261boatable
bookable16127001bookable
beatable121612242beatable
bitable11312202b_itable
boilable1237792boilable
bombable1336262bombable
bondable13169272bondable
cookable16147972cookable
notable92114902_notable
portable12313202portable
potable112115362_potable
quotable1936492quotable
sortable10312482sortable
totable92313362_totable
votable122111372_votable
abatable1238023abatable
abrogable1444573abrogable
actable11313473_actable
adoptable1444753adoptable
adorable1138773adorable
agitable1138583agitable
atonable1038793atonable
avowable1635453avowable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bearable121512363bearable
beddable14166923beddable
bendable131510853bendable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
blamable1436693blamable
blockable1944303blockable
boardable1444893boardable
bobble94115143b_o_bble
bobtail1146553bobtail_
bobtailed1443193bobtailed
bobtails1245193bobtails
bolthole1345463bolthole
boobie104015293boo__bie
boodle93215033boo__dle
bootee84323023boot__ee
bootie85421163boot__ie
bootlace1245403bootlace
bootleg10276633boot__leg
bottle84916073b_ot_tle
boundable1444843boundable
bribable1137223bribable
browsable1643863browsable
buffable1844393buffable
burnable1237263burnable
buyable1437493b_uyable
cartable121314093cartable
castable121613973castable
citable11313463_citable
closable12168003closable
codable12311663_codable
cogitable1446943cogitable
coinable12311583coinable
colorable1348243colorable
constable13311003constable
copyable1736623copyable
countable1348853countable
covetable1648163covetable
cuttable1247953cuttable
datable101714233_datable
denotable1238373denotable
doable93115243_do_able
doubtable1445163doubtable
dowable13189453_dowable
eatable91717603_eatable
editable11310423editable
erodable1139203erodable
evitable1339323evitable
evocable1537103evocable
exorable1738933exorable
fittable1337093fittable
floatable1444983floatable
floodable1544013floodable
foamable1537043foamable
foilable1338063foilable
foldable1437133foldable
footage1148843foota_ge
football1345613football
footle93914383foot__le
fordable1439593fordable
formable1539503formable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
growable1435623growable
gustable11138203gustable
hatable121713963_hatable
heatable131612043heatable
hittable1336853hittable
holdable1437073holdable
honorable1446953honorable
huntable1338093huntable
imitable1239123imitable
instable10313203instable
isolable1038793isolable
joinable1737283joinable
knowable1745043knowable
liftable1376863liftable
listable10810313listable
loanable1037613loanable
locatable1345573locatable
lockable1636953lockable
losable91910953_losable
lovable12179553_lovable
loveable13187903loveable
meltable12310473meltable
mockable1846643mockable
moldable1337103moldable
mountable1346303mountable
movable14189433_movable
moveable15168013moveable
mutable11312303_mutable
nestable101613673nestable
nettable101610243nettable
notables10178243_notables
notably12199993_notably
obeyable1544113obeyable
obstacle1243593obstacle
obviable1543863obviable
outfable1378813_outfable
ownable1237283_ownable
pettable121710713pettable
pivotable1644563pivotable
plowable1535913plowable
pointable1337343pointable
pokable15209503_pokable
portables1337873portables
portably1539313portably
posable112212783_posable
potables12179703_potables
pourable1239133pourable
probable1439053probable
promotable1645033promotable
provable1539093provable
quotably2244153quotably
ratable91717553_ratable
rentable101716333rentable
restable101618443restable
retable91820403_retable
rockable1638013rockable
rootage839053roota_ge
rootle63214453root__le
ropable111611333_ropable
rotatable1146653rotatable
rowable121510303_rowable
rustable101511363rustable
scoopable1544863scoopable
showable1636583showable
smokable1636223smokable
sociable1239503sociable
solvable1337473solvable
sorbable1239303sorbable
sortably1338803sortably
sowable121610753_sowable
spottable1345343spottable
stable83921643__stable
statable10310703statable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suitable10310893suitable
table75429603___table
tastable101511973tastable
testable101412623testable
tiltable10159013tiltable
tootle62613813toot__le
toteable1048353toteable
towable121910113_towable
unstable10313763unstable
violable1337543violable
vocable14189673_vocable
voidable1466853voidable
voteable1347213voteable
wastable131410453wastable
wettable13148043wettable
workable1737093workable
worktable1844723worktable
writable1338753writable

Search took 7 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.420425454.8
2DLD Change Limit1461621886.28023274.2
3Display Results1881880.0802350.0
 (SQL Overall)1786911886.78026355.6
 
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.