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

150 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
mappable163592(None) 
tappable1436341tappable
capable13313362ca_pable
dippable1536122dippable
flappable1843562flappable
lapsable12117382lapsable
mailable1239622mailable
makable15510202ma_kable
makeable1637252makeable
maskable1638002maskable
palpable1448032palpable
rippable1435382rippable
tapeable1238822tapeable
tippable1435262tippable
actable11313473_actable
adaptable1444613adaptable
addable11218843_addable
affable15117403_affable
amassable1346063amassable
amenable1238863amenable
amiable11312033_amiable
amicable1438433amicable
amusable1237143amusable
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
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249253barrable
callable12310753callable
capabler1435363ca_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
helpable1536613helpable
imageable1445443imageable
impalpable1843363impalpable
jailable1737143jailable
jammable2144513jammable
jumpable2143953jumpable
keepable1635323keepable
lapsible1273973lapsible
laudable1137893laudable
macabre1335223ma_cabre
malleable1376073malleable
manacle11310283ma_nacle
mandible1337543mandible
maple95521143ma_p__le
marble104219103ma__rble
matchable1845463matchable
mayapple1741703mayapple
maypole1446383mayp_ole
meltable12310473meltable
mendable131510583mendable
millable121710133millable
minable112315073m_inable
mineable121611053mineable
missable12311533missable
mixable18259173m_ixable
mockable1846643mockable
moldable1337103moldable
movable14189433m_ovable
moveable15168013moveable
mutable11312303m_utable
namable11312343na_mable
nameable1238863nameable
packable1838633packable
palpably1745363palpably
parable111819783pa_rable
parsable12311693parsable
passable12310633passable
pawnable1535983pawnable
payable141711323pa_yable
radiable11611303radiable
raisable10311643raisable
rapparee1245873rapparee
ratable91717553ra_table
rateable10311443rateable
reapable12311393reapable
recappable1843733recappable
ropable111611333_ropable
sailable10310563sailable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
shapable15197803shapable
shapeable1645743shapeable
shippable1853793shippable
skippable1952583skippable
sparable121611983sparable
stoppable1544103stoppable
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tannable1039383tannable
tastable101511973tastable
taxable1639073ta_xable
typable1435883_typable
typeable1535233typeable
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.423422437.4
2DLD Change Limit1461621507.48319532.5
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.96922423.3
 
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.