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

122 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
openable124701(None) 
operable12410321operable
amenable1238862amenable
enable83318482__enable
lienable10188692lienable
obeyable1544112obeyable
operably1557092operably
overable13513572overable
ownable1237282o_wnable
spendable1446462spendable
tenable93214492_tenable
unopenable1466072unopenable
alienable1146933alienable
amenably1546513amenably
amendable1446053amendable
atonable1038793atonable
bannable1278353bannable
bendable131510853_bendable
burnable1237263burnable
cenacle1139123_cenacle
chewable1835443chewable
cleanable1345203cleanable
coinable12311583coinable
compensable1955193compensable
copyable1736623cop_yable
coverable1649103coverable
covetable1648163covetable
damnable1347593damnable
deniable11312083_deniable
dependable1645793dependable
disenable1249673disenable
dyeable1337303dye_able
emendable1446233emendable
enabled102510633__enabled
enabler9299363__enabler
enables92813123__enables
expendable2243873expendable
eyeable1239063eye_able
feedable1437673feedable
fenagle11197153_fenagle
finable122213623_finable
fineable131810333fineable
gainable1138933gainable
gelable101710733_gelable
getable101712553_getable
gleanable1244083gleanable
governable1643633governable
hewable15177823_hewable
inoperable1448173inoperable
joinable1737283joinable
keepable1635323keepable
lendable11169463_lendable
linable92214343_linable
lineable101811083lineable
loanable1037613loanable
loveable13187903love_able
mendable131510583_mendable
minable112315073_minable
mineable121611053mineable
moveable15168013move_able
obviable1543863obviable
openly1137123open__ly
operate9615733opera_te
opercele1244593opercele
opercule1245283opercule
opposable1544063opposable
orderable1246183orderable
outfable1378813outfable
oxidable1865123oxidable
parable111819773_parable
pawnable1535983pawnable
payable141711323_payable
pebble1238003_pe_bble
peccable1648123_peccable
peelable1238553peelable
penal75228373_pena_l_
penally121111773_penally
penance11313443_penance
penile82219603_pen_ile
pensile92713543_pensile
pentacle1239383_pentacle
pettable121710713_pettable
pliable111610323_pliable
pointable1337343pointable
pokable15209503_pokable
portable12313203portable
posable112212783_posable
potable112115363_potable
pourable1239133pourable
pregnable1456693pregnable
prunable1237843prunable
reefable1339533reefable
reelable10311593reelable
rentable101716333_rentable
retable91820403_retable
ropable111611333rop__able
ruinable1039263ruinable
seeable91113943_seeable
sendable111612043_sendable
sewable121911173_sewable
shedable1437423shedable
sparable121611983sparable
speakable1745373speakable
stewable1337133stewable
stonable1039843stonable
superable13312483superable
tannable1039383tannable
tapeable1238823tape_able
tenably122210453_tenably
tolerable1147393tolerable
toteable1048353tote_able
tunable92511313_tunable
tuneable1038913tuneable
turnable1037853turnable
typeable1535233type_able
unable83819223__unable
untenable11410503untenable
useable9911063use_able
vendable14159693_vendable
viewable1635223viewable
voteable1347213vote_able
winnable13156983winnable

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 Limit1461621226.67021913.3
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.12225090.0
 
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.