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

173 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
erodable113920(None) 
erodible1145491erodible
codable12311662_codable
encodable1446272encodable
erasable10511042erasable
erosible1046442erosible
errable9312182er_rable
evadable1436362evadable
evocable1537102evocable
exorable1738932exorable
fordable1439592fordable
gradable1238822gradable
growable1435622growable
probable1439052probable
provable1539092provable
readable11313162readable
ridable101412492_ridable
ropable111611332_ropable
rowable121510302_rowable
tradable1139872tradable
abradable1495063abradable
abrogable1444573abrogable
addable11218843_addable
adorable1138773adorable
arable81821003ar__able
arguable1135903arguable
arousable1145573arousable
atonable1038793atonable
avoidable15124743avoidable
avowable1635453avowable
beddable14166923beddable
bendable131510853bendable
biddable14165673biddable
bindable13169623bindable
bondable13169273bondable
bookable16127003bookable
bootable12179223bootable
bribable1137223bribable
browsable1643863browsable
closable12168003closable
cookable16147973cookable
credible1346023credible
crossable1347073crossable
decidable1547223decidable
degradable1543883degradable
denotable1238373denotable
deposable1446833deposable
derivable1548063derivable
detonable1247623detonable
doable93115243_do_able
dowable13189453_dowable
drapable1377573drapable
drawable1467113drawable
drivable1438023drivable
droppable1643273droppable
dryable13237433dr_yable
eatable91717603e_atable
edible969353e__dible
editable11310423editable
educable1337093educable
effable15106673e_ffable
elidible1164573elidible
emendable1446233emendable
enable83318483e__nable
enjoyable2143743enjoyable
enviable1337853enviable
equable1849253e_quable
eradicable1545633eradicable
erectable131210093erectable
erode64520993erod___e
evadible1443973evadible
evitable1339323evitable
evolvable1743383evolvable
exilable1737203exilable
expiable1946113expiable
exposable2044793exposable
extrudable2073083extrudable
eyeable1239063e_yeable
fadable13310463_fadable
feedable1437673feedable
findable14179023findable
floodable1544013floodable
foldable1437133foldable
formable1539503formable
framable1537573framable
friable122612563fr_iable
fryable15277463fr_yable
grazable2036223grazable
groupable1443643groupable
guidable1236203guidable
heritable1439453heritable
hidable1399403_hidable
holdable1437073holdable
isolable1038793isolable
knowable1745043knowable
laudable1137893laudable
lendable11169463lendable
losable91910953_losable
lovable12179553_lovable
memorable1547533memorable
mendable131510583mendable
moldable1337103moldable
movable14189433_movable
notable92114903_notable
oxidable1865123oxidable
parolable1347113parolable
permeable1556823permeable
personable1467073personable
perusable1347453perusable
plowable1535913plowable
pokable15209503_pokable
portable12313203portable
posable112212783_posable
potable112115363_potable
probables1545433probables
probably1746413probably
provably1846213provably
prunable1237843prunable
quotable1936493quotable
radiable11611303_radiable
ratable91717553_ratable
readably1438383readably
reapable12311393reapable
recordable1545553recordable
redouble1145523redouble
reefable1339533reefable
reelable10311603reelable
reliable10313073reliable
removable1646923removable
rendible11128353rendible
rentable101716333rentable
restable101618443restable
retable91820403_retable
reusable10811273reusable
revocable1647003revocable
revokable1845293revokable
rideable1158653_rideable
roble75223023_ro__ble
rockable1638013_rockable
rouble83913313_ro_uble
rulable9310533_rulable
sandable111612823sandable
sendable111612043sendable
servable13310093ser_vable
shedable1437423shedable
showable1636583showable
slidable1137953slidable
smokable1636223smokable
sorbable1239303sorbable
sortable10312483sortable
sowable121610753_sowable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
totable92313363_totable
towable121910113_towable
tradeable1247413tradeable
triable92515393tr_iable
trouble957713tro_uble
undoable1139053undoable
unridable1248293unridable
urodele845963urod_ele
vendable14159693vendable
veritable1448743veritable
violable1337543violable
vocable14189673_vocable
voidable1466853voidable
votable122111373_votable
wadable13310233_wadable
weldable1436873weldable
windable14159153windable
workable1737093workable
writable1338753writable

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.420425454.8
2DLD Change Limit1461621737.95318378.2
3Display Results1731730.0762276.3
 (SQL Overall)1786911738.44921149.4
 
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.