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

251 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
tastable10151197(None) 
castable121613971castable
tasteable1146121tasteable
testable101412621testable
wastable131410451wastable
actable11313472_actable
cartable121314092cartable
cascable141510622cascable
cashable15159792cashable
datable101714232da_table
eatable91717602ea_table
gustable11138202gustable
hatable121713962ha_table
instable10313202instable
listable10810312listable
maskable1638002maskable
metastable1444922metastable
nestable101613672nestable
passable12310632passable
ratable91717552ra_table
restable101618442restable
rustable101511362rustable
stable83921642__stable
statable10310702sta_table
takable13310192ta_kable
takeable1437462takeable
talkable1437192talkable
tamable11312852ta_mable
tameable1238602tameable
tannable1039382tannable
tapeable1238822tapeable
tappable1436342tappable
taxable1639072ta_xable
teasable101511172teas_able
tiltable10159012tiltable
totable92313362t_otable
tractable1338512tractable
trustable1147122trustable
twistable1444272twistable
unstable10313762unstable
washable16138042washable
abatable1238023abatable
adaptable1444613adaptable
addable11218843_addable
affable15117403_affable
agitable1138583agitable
amassable1346063amassable
amiable11312033_amiable
arable81821003_a_rable
astilbe945653_astilbe
atonable1038793atonable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bastile9313913bast_ile
bastille1047993bastille
beatable121612243beatable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
callable12310753callable
cantabile1346893cantabile
capable13313363ca_pable
cascabel14174503cascabel
cascables15165773cascables
castle84918963cast__le
causable1239973causable
chantable1636893chantable
chartable1636833chartable
chaseable1646343chaseable
citable11313463_citable
classable1347143classable
constable13311003constable
cuttable1247953cuttable
damnable1347593damnable
dateable1149443dateable
detestable13136503detestable
disable10516433dis_able
draftable1575563draftable
eatables10169793ea_tables
editable11310423editable
enactable1338493enactable
erasable10511043eras_able
evitable1339323evitable
exactable2046433exactable
faceable15108493faceable
fadable13310463fa_dable
farmable1538203farmable
fastball1344913fastball
fishable1637593fishable
fittable1337093fittable
gainable1138933gainable
getable101712553_getable
getatable1235953geta_table
gettable11178133gettable
giftable1465893giftable
grantable1257293grantable
graspable1444873graspable
gustables12165223gustables
habitable1645953habitable
hackable1937473hackable
hangable1438213hangable
hastate10313913hasta_te
hateable1339373hateable
heatable131612043heatable
hittable1336853hittable
huntable1338093huntable
imitable1239123imitable
issuable1046873issuable
jailable1737143jailable
jammable2144513jammable
kissable1436853kissable
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leas_able
liftable1376863liftable
losable91910953los_able
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
mappable1635923mappable
mastaba1146223mastab_a
mastabah1554023mastabah
mastabas1246803mastabas
meltable12310473meltable
metastably1743143metastably
missable12311533missable
mutable11312303_mutable
namable11312343na_mable
nameable1238863nameable
nettable101610243nettable
notable92114903_notable
obstacle1243593obstacle
packable1838633packable
paintable1337243paintable
palatable1346373palatable
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
restabled12148953restabled
restables111511423restables
retable91820403_retable
rotatable1146653rota_table
sable74732163__s_able
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stackable1735993stackable
stageable1246343stageable
stainable1138093stainable
stale55637103__sta_le
staple84415823__staple
stateable1136903stateable
statutable1242643statutable
suable83920553__suable
suitable10310893suitable
table75429603___table
tabulable1344043tabulable
tactile9310613tact_ile
tamale83717403ta_ma_le
tangible1145603tangible
targetable1383873targetable
tartare73012683tarta_re
taste55127233tast___e
tastily103311643tast_ily
tattle64115653ta_t_tle
taxables1734383ta_xables
taxably1936043ta_xably
teachable16137603teachable
tearable101512673tearable
tellable10169773tellable
temptable1545813temptable
tenable93214493t_enable
tenantable1244183tenantable
tentacle1037693tentacle
testae64216253testa__e
testate73916233testa_te
testicle1037443testicle
tillable10159753tillable
timetable1346873timetable
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
toteable1048353toteable
towable121910113t_owable
traceable1338323traceable
trackable1736743trackable
tractably1646243tractably
tradable1139873tradable
tradeable1247413tradeable
trainable1138943trainable
treatable1139323treatable
triable92515393t_riable
tubbable1134683tubbable
tunable92511313t_unable
tuneable1038913tuneable
turnable1037853turnable
turntable1144983turntable
typable1435883t_ypable
typeable1535233typeable
unactable13310053unactable
unstabler1145623unstabler
unstably1339493unstably
untestable1248823untestable
usable84012553_us_able
useable9911063_useable
vacatable1644643vacatable
valuable1336863valuable
variable13310063variable
visitable1445873visitable
votable122111373_votable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
washables17144743washables
wastage11109253wasta_ge
waxable1937673wa_xable
wettable13148043wettable
writable1338753writable

Search took 10 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 Limit1461622518.75016704.2
3Display Results2512510.1102281.8
 (SQL Overall)1786912519.28319249.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.