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

121 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
traceable133832(None) 
traceably1646221traceably
trackable1736741trackable
tractable1338511tractable
tradeable1247411tradeable
drapeable1445672drapeable
faceable15108492_faceable
frameable1645352frameable
grazeable2144152grazeable
peaceable1548252peaceable
placeable1536912placeable
priceable1546822priceable
rateable10311442_rateable
takeable1437462t_akeable
tameable1238602t_ameable
tapeable1238822t_apeable
teachable16137602teachable
tractably1646242tractably
tradable1139872tra_dable
trainable1138942trainable
truckable1744512truckable
untraceable1546852untraceable
actable11313473__actable
attachable1743193attachable
blameable1544723blameable
chaseable1646343chaseable
coachable1846303coachable
danceable1445303danceable
dateable1149443_dateable
draftable1575563draftable
drainable1237583drainable
drapable1377573dra_pable
drawable1467113dra_wable
driveable1544523driveable
effaceable2042263effaceable
embraceable1952083embraceable
enactable1338493enactable
erasable10511043era_sable
erectable131210093erectable
exactable2046433exactable
extractable2254153extractable
forceable1646213forceable
framable1537573fra_mable
frankable1844923frankable
grabbable1343193grabbable
gradable1238823gra_dable
grantable1257293grantable
graspable1444873graspable
grazable2036223gra_zable
hackable1937473_hackable
hateable1339373_hateable
imageable1445443imageable
intractable1557363intractable
lacerable1346943_lacerable
leachable16136443leachable
makeable1637253_makeable
nameable1238863_nameable
packable1838633_packable
peaceably1845583peaceably
placable14169243plac_able
poachable1846243poachable
radiable11611303_radiable
raisable10311643_raisable
raiseable1147243_raiseable
ratable91717553_ra_table
rateably1337783_rateably
reachable16129653reachable
retractable1545123retractable
rideable1158653_rideable
rockable1638013_rockable
saleable10312023_saleable
saveable1339003_saveable
shakeable1844943shakeable
shameable1645573shameable
shapeable1645743shapeable
shareable1436733shareable
sliceable1345443sliceable
spareable1337263spareable
stackable1735993stackable
stageable1246343stageable
stateable1136903stateable
takable13310193t_a_kable
talkable1437193t_alkable
tamable11312853t_a_mable
tannable1039383t_annable
tappable1436343t_appable
targetable1383873targetable
tastable101511973t_astable
tasteable1146123tasteable
taxable1639073t_a_xable
teachably19135183teachably
tearable101512673tea_rable
teasable101511173tea_sable
torchable1645533torchable
toteable1048353t_oteable
touchable1645023touchable
trabeate1049483trabea_te
tracheae1349113trachea__e
tracheal1348253trachea_l_
tracheate1448233trachea_te
tracheole1445573tracheole
trachle12311853trac__hle
trackage1545653tracka_ge
trackball1743813trackball
tractate10411003tracta_te
tractile10311073trac_tile
trailerable1352823trailerable
transaxle1645913transaxle
traversable1652813traversable
treacle939973tr__eacle
treadle8310103tr__eadle
treatable1139323treatable
treble8311663tr__e_ble
tremble1138003tr__emble
triable92515393tr__iable
trustable1147123trustable
tuneable1038913t_uneable
typeable1535233t_ypeable
unactable13310053unactable
wadeable1437443_wadeable
writeable1444613writeable

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411217.07621006.4
3Display Results1211210.0631920.6
 (SQL Overall)1786911217.31224438.0
 
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.