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

222 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
erasable1051104(None) 
drapable1377572drapable
drawable1467112drawable
eatable91717602e_atable
erodable1139202erodable
erosible1046442erosible
errable9312182er_rable
evadable1436362evadable
framable1537572framable
gradable1238822gradable
graspable1444872graspable
grazable2036222grazable
leasable101510132leasable
parsable12311692parsable
perusable1347452perusable
raisable10311642_raisable
ratable91717552_ratable
readable11313162readable
reapable12311392reapable
reusable10811272reusable
teasable101511172teasable
tradable1139872tradable
abatable1238023abatable
abradable1495063abradable
abusable1236373abusable
amassable1346063amassable
amusable1237143amusable
arable81821003__arable
arguable1135903arguable
arousable1145573arousable
barrable1249253barrable
bearable121512363bearable
beatable121612243beatable
blamable1436693blamable
boatable121610263boatable
brabble10349973bra_bble
bramble133710033bra_mble
breakable1746163breakable
bribable1137223bribable
browsable1643863browsable
capable13313363_capable
cartable121314093cartable
cascable141510623_cascable
cashable15159793_cashable
castable121613973_castable
causable1239973causable
chaseable1646343chaseable
chasuble1543063chasuble
classable1347143classable
closable12168003closable
creatable1339563creatable
crossable1347073crossable
crushable1645263crushable
datable101714233_datable
debatable1446313debatable
decayable1745623decayable
defrayable1943253defrayable
degradable1543883degradable
delayable1546063delayable
demisable1448533demisable
deposable1446833deposable
derisible1245773derisible
derivable1548063derivable
devisable1546853devisable
disable10516433_disable
drabble12238883dra_bble
draftable1575563draftable
drainable1237583drainable
drapeable1445673drapeable
drivable1438023drivable
dryable13237433dr_yable
eatables10169793e_atables
editable11310423editable
educable1337093educable
effable15106673e_ffable
enable83318483e__nable
enactable1338493enactable
encashable1744183encashable
enviable1337853enviable
equable1849253e_quable
equatable2045193equatable
eradicable1545633eradicable
erase54925493eras___e
erasure736943eras_ure
erectable131210093erectable
erodible1145493erodible
escapable1544983escapable
evadible1443973evadible
evaluable1444233evaluable
evitable1339323evitable
evocable1537103evocable
exactable2046433exactable
excisable2045053excisable
excusable2044373excusable
exilable1737203exilable
exorable1738933exorable
expiable1946113expiable
exposable2044793exposable
eyeable1239063e_yeable
fadable13310463_fadable
farmable1538203farmable
feasible1376093feasible
foamable1537043foamable
frameable1645353frameable
frankable1844923frankable
friable122612563fr_iable
fryable15277463fr_yable
getatable1235953getatable
gnawable1435683gnawable
grabbable1343193grabbable
grabble12339643gra_bble
grantable1257293grantable
grazeable2144153grazeable
growable1435623growable
hatable121713963_hatable
healable131610183healable
hearable131611613hearable
heatable131612043heatable
heritable1439453heritable
inarable10313133inarable
irascible1344773irascible
kissable1436853kissable
lapsable12117383lapsable
learnable1145563learnable
loanable1037613loanable
losable91910953_losable
makable15510203_makable
maskable1638003_maskable
metastable1444923metastable
missable12311533missable
namable11312343_namable
parable111819783_parable
passable12310633passable
payable141711323_payable
perishable1745263perishable
permeable1556823permeable
placable14169243placable
playable15137923playable
posable112212783_posable
presale9416353presa_le
probable1439053probable
provable1539093provable
prunable1237843prunable
rabble103818243_ra_bble
radiable11611303_radiable
raiseable1147243_raiseable
ramble104519973_ra_mble
rassle63813203_ras_sle
ratables10159723_ratables
ratably121711513_ratably
rateable10311443_rateable
reachable16129663reachable
readably1438383readably
reasonable1246283reasonable
reefable1339533reefable
reelable10311603reelable
refusable1476683refusable
relatable11310053relatable
relaxable1836363relaxable
releasable1245483releasable
reliable10313073reliable
rentable101716333rentable
reparable1359953reparable
repayable1666343repayable
resalable1138733resalable
resale64025543_resa_le
restable101618443restable
retable91820403_retable
reusables1175223reusables
revisable1437993revisable
ridable101412493_ridable
rinsable10310043rinsable
risible937923_risible
ropable111611333_ropable
rowable121510303_rowable
rulable9310533_rulable
rustable101511363_rustable
sable74732163___sable
salable91415463_salable
savable121711863_savable
sayable121411613_sayable
scalable121710233scalable
sealable101512693sealable
seisable10311373seisable
separable1348673separable
servable13310093ser_vable
shakable17177683shakable
shamable15168803shamable
shapable15197803shapable
sharable131910693sharable
shavable16177273shavable
slakable14177553slakable
slayable13157563slayable
sparable121611983sparable
statable10310703statable
swayable16135533swayable
takable13310193_takable
tamable11312853_tamable
tastable101511973_tastable
taxable1639073_taxable
tearable101512673tearable
traceable1338323traceable
trackable1736743trackable
tractable1338513tractable
tradeable1247413tradeable
trainable1138943trainable
transaxle1645913transaxle
treatable1139323treatable
triable92515393tr_iable
trustable1147123trustable
unusable1038953unusable
usable84012553__usable
variable13310063variable
veritable1448743veritable
wadable13310233_wadable
washable16138043_washable
wastable131410453_wastable
waxable1937673_waxable
wearable131510563wearable
wrassle10357173wras_sle
wrastle10368993wras_tle
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 Filter1786911461620.423422437.4
2DLD Change Limit1461622227.09320606.5
3Display Results2222220.0932387.1
 (SQL Overall)1786912227.60923484.2
 
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.