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

127 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
tractable133851(None) 
traceable1338321traceable
trackable1736741trackable
tractably1646241tractably
actable11313472__actable
draftable1575562draftable
enactable1338492enactable
erectable131210092erectable
exactable2046432exactable
extractable2254152extractable
grantable1257292grantable
intractable1557362intractable
ratable91717552_ra_table
retractable1545122retractable
tastable101511972t_astable
teachable16137602teachable
traceably1646222traceably
tractate10411002tracta_te
tractile10311072tract_ile
tradable1139872tra_dable
tradeable1247412tradeable
trainable1138942trainable
treatable1139322treatable
truckable1744512truckable
trustable1147122trustable
unactable13310052unactable
abatable1238023aba_table
abstractable1852193abstractable
adaptable1444613adaptable
attachable1743193attachable
beatable121612243bea_table
boatable121610263boa_table
bracteole1343313bracteole
cartable121314093_cartable
castable121613973_castable
chantable1636893chantable
chartable1636833chartable
coachable1846303coachable
creatable1339563creatable
datable101714233_da_table
distractable1753603distractable
drainable1237583drainable
drapable1377573dra_pable
drapeable1445673drapeable
drawable1467113dra_wable
eatable91717603_ea_table
ejectable20136573ejectable
electable13149623electable
erasable10511043era_sable
faceable15108493_faceable
fractal1237623fracta_l_
fractals1346133fracta_ls
framable1537573fra_mable
frameable1645353frameable
frankable1844923frankable
grabbable1343193grabbable
gradable1238823gra_dable
graspable1444873graspable
grazable2036223gra_zable
grazeable2144153grazeable
hackable1937473_hackable
hatable121713963_ha_table
heatable131612043hea_table
intractably1856663intractably
irritable1148053irritable
leachable16136443leachable
locatable1345573locatable
packable1838633_packable
peaceable1548253peaceable
placable14169243plac_able
placeable1536913placeable
plantable1337273plantable
poachable1846243poachable
practicable1953833practicable
priceable1546823priceable
printable1338203printable
radiable11611303_radiable
raisable10311643_raisable
ratables10159723_ra_tables
ratably121711513_ra_tably
rateable10311443_rateable
reachable16129653reachable
rentable101716333_rentable
restable101618443_restable
retable91820403_r_etable
rockable1638013_rockable
rustable101511363_rustable
stackable1735993stackable
statable10310703sta_table
tactile9310613t_act_ile
takable13310193t_a_kable
takeable1437463t_akeable
talkable1437193t_alkable
tamable11312853t_a_mable
tameable1238603t_ameable
tannable1039383t_annable
tapeable1238823t_apeable
tappable1436343t_appable
targetable1383873targetable
tasteable1146123t_asteable
taxable1639073t_a_xable
teachably19135183teachably
tearable101512673tea_rable
teasable101511173tea_sable
temptable1545813temptable
tenantable1244183tenantable
testable101412623t_estable
tiltable10159013t_iltable
timetable1346873timetable
titratable1243693titra_table
torchable1645533torchable
totable92313363t__otable
touchable1645023touchable
tracheole1445573tracheole
trachle12311853trac__hle
trackage1545653tracka_ge
trackball1743813trackball
tractates1159763tractates
tractive13310043tract_ive
transaxle1645913transaxle
triable92515393tr__iable
turntable1144983turntable
twistable1444273twistable
untraceable1546853untraceable
vacatable1644643_vacatable
wastable131410453_wastable
writable1338753wr_itable

Search took 9 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.1731032896.0
2DLD Change Limit1486411277.78019105.5
3Display Results1271270.0632015.9
 (SQL Overall)1786911278.01622291.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.