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

97 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
tradeable124741(None) 
traceable1338321traceable
tradable1139871trad_able
drapeable1445672drapeable
frameable1645352frameable
gradable1238822grad_able
grazeable2144152grazeable
radiable11611302_radiable
rateable10311442_rateable
rideable1158652_rideable
takeable1437462t_akeable
tameable1238602t_ameable
tapeable1238822t_apeable
traceably1646222traceably
trackable1736742trackable
tractable1338512tractable
trainable1138942trainable
wadeable1437442_wadeable
abradable1495063abrad_able
addable11218843__addable
blameable1544723blameable
bridgeable1641973bridgeable
chaseable1646343chaseable
dateable1149443_dateable
draftable1575563draftable
drainable1237583drainable
drapable1377573dra_pable
drawable1467113dra_wable
driveable1544523driveable
eradicable1545633eradicable
erasable10511043era_sable
erodable1139203erod_able
evadable1436363evad_able
faceable15108493_faceable
fadable13310463_fad_able
framable1537573fra_mable
frankable1844923frankable
grabbable1343193grabbable
grantable1257293grantable
graspable1444873graspable
grazable2036223gra_zable
hateable1339373_hateable
imageable1445443imageable
makeable1637253_makeable
nameable1238863_nameable
orderable1246183or_derable
peaceable1548243peaceable
placeable1536913placeable
priceable1546823priceable
radiale83813523_radia_le
raisable10311643_raisable
raiseable1147233_raiseable
ratable91717553_ra_table
rateably1337783_rateably
readable11313163read_able
ridable101412493_rid_able
saleable10312023_saleable
saveable1339003_saveable
shakeable1844943shakeable
shameable1645573shameable
shapeable1645743shapeable
shareable1436733shareable
spareable1337263spareable
stageable1246343stageable
stateable1136903stateable
takable13310193t_a_kable
talkable1437193t_alkable
tamable11312843t_a_mable
tannable1039383t_annable
tappable1436343t_appable
targetable1383873targetable
tastable101511973t_astable
tasteable1146123tasteable
taxable1639073t_a_xable
teachable16137603teachable
tearable101512673tea_rable
teasable101511173tea_sable
toteable1048353t_oteable
trabeate1049483trabea_te
tractably1646243tractably
trailerable1352823trailerable
transaxle1645913transaxle
traversable1652813traversable
treacle939973tr__eacle
treadle8310103tr__eadle
treatable1139323treatable
treble8311663tr__e_ble
tremble1138003tr__emble
triable92515393tr__iable
truckable1744513truckable
trustable1147123trustable
tuneable1038913t_uneable
typeable1535233t_ypeable
untraceable1546853untraceable
upgradeable1752133upgradeable
wadable13310233_wad_able
writeable1444613writeable

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.1561145455.1
2DLD Change Limit148641978.40617682.7
3Display Results97970.0462108.7
 (SQL Overall)178691978.60820758.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.