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

267 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
castable12161397(None) 
cartable121314091cartable
cascable141510621cascable
cashable15159791cashable
tastable101511971tastable
wastable131410451wastable
actable11313472_actable
callable12310752callable
cantabile1346892cantabile
capable13313362ca_pable
cascabel14174502cascabel
cascables15165772cascables
castle84918962cast__le
causable1239972causable
chantable1636892chantable
chartable1636832chartable
chaseable1646342chaseable
citable11313462c_itable
classable1347142classable
constable13311002constable
cuttable1247952cuttable
datable101714232da_table
eatable91717602ea_table
gustable11138202gustable
hatable121713962ha_table
instable10313202instable
listable10810312listable
maskable1638002maskable
nestable101613672nestable
passable12310632passable
ratable91717552ra_table
restable101618442restable
rustable101511362rustable
stable83921642__stable
tasteable1146122tasteable
testable101412622testable
unstable10313762unstable
washable16138042washable
abatable1238023abatable
adaptable1444613adaptable
addable11218843_addable
affable15117403_affable
agitable1138583agitable
amassable1346063amassable
amiable11312033_amiable
arable81821003_a_rable
astilbe945653_astilbe
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bastile9313913bast_ile
bastille1048003bastille
beatable121612243beatable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
cable95329913c___able
canoeable1347103canoeable
cantabiles1445763cantabiles
cantal84122033canta_l_
cantala94114673canta_la
cantals93919573canta_ls
canticle1239703canticle
cantle84522153cant__le
capabler1435353ca_pabler
capably1639253ca_pably
carpale113414353carpa_le
cartage10312593carta_ge
casaba1079263cas_ab_a
casabas1139983cas_abas
cascabels15163233cascabels
cascade12118603casca_de
casease939323casea_se
caseate9314783casea_te
cassaba1145663cassab_a
cassabas1245733cassabas
castanet10416193castanet
castaway1664573castaway
caste75932363cast___e
castled104311513cast__led
castles94917733cast__les
castrate10313863castrate
casual81112863casua_l_
casually1356823casually
casuals91410533casua_ls
catalo8314853ca_ta_lo
catchable1845713catchable
cattail939183cattail_
cattails1038553cattails
cattalo938423catta_lo
cattle85118903ca_t_tle
charitable1744643charitable
chasuble1543063chas_uble
cheatable1646713cheatable
chewable1835443chewable
citeable1238413citeable
claimable1545703claimable
closable12168003closable
closeable13155023closeable
clubable1436093clubable
coachable1846303coachable
coastal9411043coasta_l_
coastally1446503coastally
codable12311663c_odable
cogitable1446943cogitable
coinable12311583coinable
constables1446733constables
cookable16147973cookable
copyable1736623copyable
costae85319683costa__e
costal85419513costa_l_
costally1339733costally
costate94019273costa_te
countable1348853countable
covetable1648163covetable
creatable1339563creatable
crossable1347073crossable
crushable1645263crushable
culpable1436283culpable
curable112414513c_urable
curbable1447663curbable
damnable1347593damnable
dateable1149443dateable
disable10516433dis_able
draftable1575563draftable
eatables10169793ea_tables
editable11310423editable
enactable1338493enactable
encashable1744173encashable
erasable10511043eras_able
evitable1339323evitable
exactable2046433exactable
faceable15108493faceable
fadable13310463fa_dable
farmable1538203farmable
fastball1344913fastball
fishable1637593fishable
fittable1337093fittable
gainable1138933gainable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
grantable1257293grantable
graspable1444873graspable
gustables12165223gustables
habitable1645953habitable
hackable1937473hackable
hangable1438213hangable
hastate10313913hasta_te
hateable1339373hateable
heatable131612043heatable
hittable1336853hittable
huntable1338093huntable
imitable1239123imitable
issuable1046873issuable
jailable1737143jailable
jammable2144513jammable
kissable1436853kissable
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leas_able
liftable1376863liftable
locatable1345573loca_table
losable91910953los_able
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
mappable1635923mappable
mastaba1146223mastab_a
mastabah1554023mastabah
mastabas1246803mastabas
meltable12310473meltable
metastable1444923metastable
missable12311533missable
mutable11312303_mutable
namable11312343na_mable
nameable1238863nameable
nettable101610243nettable
notable92114903_notable
obstacle1243593obstacle
packable1838633packable
paintable1337243paintable
palatable1346383palatable
palpable1448033palpable
parable111819773pa_rable
parsable12311693parsable
partible1238063partible
passably1537253passably
passible1237693passible
pastille1038943pastille
pawnable1535983pawnable
payable141711323pa_yable
pettable121710713pettable
plantable1337273plantable
portable12313203portable
posable112212783pos_able
potable112115363_potable
quotable1936493quotable
radiable11611303radiable
raisable10311643raisable
raiseable1147243raiseable
ratables10159723ra_tables
ratably121711513ra_tably
rateable10311443rateable
rentable101716333rentable
restabled12148963restabled
restables111511423restables
retable91820403_retable
sable74732163__s_able
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
scalable121710233sca_lable
scannable1345643scannable
scrutable1346043scrutable
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stale55637103__sta_le
staple84415823__staple
statable10310703statable
suable83920553__suable
suitable10310893suitable
table75429603___table
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
taxable1639073ta_xable
teasable101511173teas_able
tiltable10159013tiltable
totable92313363_totable
tractable1338513tractable
trustable1147123trustable
twistable1444273twistable
unactable13310053unactable
unstabler1145623unstabler
unstably1339493unstably
usable84012553_us_able
useable9911063_useable
vacatable1644643vacatable
valuable1336863valuable
variable13310063variable
visitable1445873visitable
votable122111373_votable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
washables17144743washables
wastage11109253wasta_ge
waxable1937673wa_xable
wettable13148043wettable
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 Limit1461622677.14020470.9
3Display Results2672670.1102427.3
 (SQL Overall)1786912677.67323288.3
 
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.