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

168 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
tappable143634(None) 
mappable1635921mappable
tapeable1238821tapeable
tippable1435261tippable
capable13313362ca_pable
dippable1536122dippable
flappable1843562flappable
lapsable12117382lapsable
palpable1448032palpable
rippable1435382rippable
stoppable1544102stoppable
takable13310192ta_kable
takeable1437462takeable
talkable1437192talkable
tamable11312852ta_mable
tameable1238602tameable
tannable1039382tannable
tastable101511972tastable
taxable1639072ta_xable
typable1435882t_ypable
typeable1535232typeable
actable11313473_actable
adaptable1444613adaptable
addable11218843_addable
affable15117403_affable
amiable11312033_amiable
appal95315223_appa_l_
appall10379743_appa_ll
appalled1344813_appalled
appalls11337743_appalls
appals104812943_appa_ls
apparel1146003_apparel
apple94517673_app__le
appliable1545053_appliable
apposable1545603_apposable
arable81821003_a_rable
atonable1038793atonable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
callable12310753callable
capabler1435353ca_pabler
capably1639253ca_pably
carpale113414353carpa_le
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
chippable2073353chippable
clippable1773463clippable
copyable1736623copyable
culpable1436283culpable
damnable1347593damnable
dapple1138853dapp__le
datable101714233da_table
dateable1149443dateable
drapable1377573drapable
drapeable1445673drapeable
droppable1643273droppable
dupable12238383_dupable
eatable91717603ea_table
expiable1946113expiable
faceable15108493faceable
fadable13310463fa_dable
farmable1538203farmable
gainable1138933gainable
graspable1444873graspable
hackable1937473hackable
hangable1438213hangable
hatable121713963ha_table
hateable1339373hateable
helpable1536603helpable
jailable1737143jailable
jammable2144513jammable
jumpable2143953jumpable
keepable1635323keepable
lapsible1273973lapsible
laudable1137893laudable
mailable1239623mailable
makable15510203ma_kable
makeable1637253makeable
maskable1638003maskable
namable11312343na_mable
nameable1238863nameable
packable1838633packable
palpably1745363palpably
parable111819773pa_rable
parsable12311693parsable
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
radiable11611303radiable
raisable10311643raisable
rapparee1245873rapparee
ratable91717553ra_table
rateable10311443rateable
reapable12311393reapable
recappable1843723recappable
ropable111611333_ropable
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
shapable15197803shapable
shapeable1645743shapeable
shippable1853793shippable
skippable1952583skippable
sparable121611983sparable
stackable1735993stackable
stageable1246343stageable
stainable1138093stainable
statable10310703sta_table
stateable1136903stateable
strippable1642663strippable
table75429603t___able
tabulable1344043tabulable
tadpole1036143tadp_ole
tamale83717403ta_ma_le
tampala1136613tampa_la
tangible1145603tangible
tapalo839793ta_pa_lo
taphole1239773ta_phole
tasteable1146123tasteable
taxables1734383ta_xables
taxably1936043ta_xably
teachable16137603teachable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
temptable1545813temptable
tenable93214493t_enable
testable101412623testable
tillable10159753tillable
tiltable10159013tiltable
tipple103411913tipp__le
tithable1336853tithable
titrable1038963titrable
topple104411323topp__le
totable92313363t_otable
toteable1048353toteable
towable121910113t_owable
traceable1338323traceable
trackable1736743trackable
tractable1338513tractable
tradable1139873tradable
tradeable1247413tradeable
trainable1138943trainable
triable92515393t_riable
tubbable1134683tubbable
tunable92511313t_unable
tuneable1038913tuneable
turnable1037853turnable
valuable1336863valuable
vaporable1645543vaporable
variable13310063variable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable

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.420425454.8
2DLD Change Limit1461621687.42319690.4
3Display Results1681680.0762210.5
 (SQL Overall)1786911687.91922564.8
 
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.