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 “draftable” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
draftable157556(None) 
datable101714232d_a_table
drainable1237582drainable
drapable1377572dra_pable
drapeable1445672drapeable
drawable1467112dra_wable
grantable1257292grantable
ratable91717552_ra_table
tractable1338512tractable
abatable1238023aba_table
actable11313473__actable
adaptable1444613adaptable
affable15117403__affable
beatable121612243bea_table
boatable121610263boa_table
cartable121314093_cartable
castable121613973_castable
chantable1636893chantable
chartable1636833chartable
creatable1339563creatable
damnable1347593d_amnable
dateable1149443d_ateable
debatable1446313debatable
deletable12149503deletable
denotable1238373denotable
deputable1487043deputable
dilatable1246853dilatable
doubtable1445163doubtable
drabble12238883dra__bble
draftee11379523draft__ee
draftily1534413draft_ily
drawtube1441613drawtub_e
driftage1342933drifta_ge
drillable1245133drillable
drinkable1644113drinkable
drivable1438023dr_ivable
driveable1544523driveable
droppable1643273droppable
dryable13237433dr__yable
dubitable1445093dubitable
eatable91717603_ea_table
enactable1338493enactable
erasable10511043era_sable
erectable131210093erectable
exactable2046433exactable
framable1537573fra_mable
frameable1645353frameable
frankable1844923frankable
giftable1465893_giftable
grabbable1343193grabbable
gradable1238823gra_dable
graftage1343683grafta_ge
graspable1444873graspable
grazable2036223gra_zable
grazeable2144153grazeable
hatable121713963_ha_table
heatable131612043hea_table
irritable1148053irritable
liftable1376863_liftable
plantable1337273plantable
printable1338203printable
profitable1744963profitable
radiable11611303_radiable
raisable10311643_raisable
ratables10159723_ra_tables
ratably121711513_ra_tably
rateable10311443_rateable
refutable1477863_refutable
rentable101716333_rentable
restable101618443_restable
retable91820403_r_etable
rustable101511363_rustable
shiftable1744893shiftable
statable10310703sta_table
tastable101511973_tastable
traceable1338323traceable
trackable1736743trackable
tractably1646243tractably
tradable1139873tra_dable
tradeable1247413tradeable
trainable1138943trainable
treatable1139323treatable
trustable1147123trustable
unactable13310053unactable
wastable131410453_wastable
writable1338753wr_itable

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641866.26623721.8
3Display Results86860.0302866.7
 (SQL Overall)178691866.71926594.9
 
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.