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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
merchantability279182(None) 
exchangeability33101424_exchangeability
machinability2573914m_achin_ability
machineability26132504m_achineability
merchantable2152024merchantab_l__e
metastability2055574me__tastability
accountability2362615_accountability
castability1848415___c_astability
changeability2453345___changeability
countability1956585___countability
erasability1668935_er__a_sability
excitability2655675_exc__itability
expandability2853695_e_xpandability
extractability28103555_extractability
germinability2155065ger_min_ability
heritability2047985her___itability
leachability2255255leach___ability
marketability2454135mar__ketability
marriageability23111665marriageability
meltability1848685me____ltability
mercantilism1862495merc_ant__ilism
mercantilist1663105merc_ant__ilist
mercantilists1762315merc_ant__ilists
perceptibility2562945perc_eptibility
presentability2164505_presentability
preventability2464065_preventability
printability1946865_pr__intability
recallability2054505re_c_allability
rentability16410195__r__entability
repeatability2056245re_pea_tability
tractability1947095_tr__actability
treatability1747435_tr_ea_tability
unchangeability2672025_unchangeability
acceptability2454126__acceptability
actability1749086_____actability
adaptability2055226___adaptability
amenability1847496ame____n_ability
bankability2245246____bankability
bearability1847336be___a_rability
breathability2354086_br_eathability
capability1947596___c_a_pability
cleanability1955226__clean_ability
creditability2155696_cr_editability
cutability1747866___c__utability
decidability2145746de_c__idability
delectability2155676de__lectability
deniability1748726de____niability
dependability2254866de__pendability
detachability2454316de__tachability
detectability2155666de__tectability
detonability1856146de__ton_ability
dilatability1845456__dila_tability
drapability1986476_dr__a_pability
drapeability2055916_dr__apeability
drinkability2254696_dr__inkability
electability1947056_e__lectability
equitability2645776_e__quitability
excludability2852696_exc_ludability
exhaustibility2961816_e_xhaustibility
expansibility2763476_e_xpansibility
expendability2853846_e_xpendability
exportability2774256_e_xportability
extendability2653596_e_xtendability
frangibility2154026_fr__angibility
habitability2255096____habitability
hatchability2553776hatch___ability
impregnability24163236impr_egn_ability
incapability2156516_inc_a_pability
inscrutability2163836insc_rutability
intractability2155866_intractability
irrefutability2293406_irrefutability
irritability1747486_ir__ritability
mailability1847306m____ailability
maintainability2261576maintainability
manageability2153916m__anageability
measurability2054476me__asurability
memorability2146446me___morability
mensurability2054386me__nsurability
mentality1449136me____nta__lity
mercantile1453516merc_ant__il__e
mercantilisms1962536merc_ant__ilisms
mercantilistic2071416merc_ant__ilistic
mercenarily1852656merc_en_aril__y
merchandising2261816merchan__dising
merchandizing3162286merchan__dizing
merchanting1944316merchant____ing
mutability1748076m_____utability
overstability21125376over___stability
palatability1946386__pala_tability
patentability2054786__patentability
perdurability2154686per__durability
perfectibility2663266per_fectibility
performability2663036per_formability
perishability2365236per__ishability
permeability2157176per___meability
portability1849566por____tability
predictability2454016_predictability
pregnability2056166_pr_egn_ability
profitability2355136_pr_ofitability
promotability2254806_pr_omotability
readability1748076__r_ea_dability
reasonability1854796re_ason_ability
recognizability3271816re_cognizability
recoverability2473206re_coverability
rectifiability2462576re_ctifiability
refrangibility2382606re_frangibility
refundability2253946__refundability
repairability2055856__repairability
reputability1946986__r_eputability
resectability2056096__resectability
respectability2353976re_spectability
roadability1757206__r_oa_dability
separability1946916se__pa_rability
serviceability2462866ser_viceability
shareability2054926___shareability
spreadability2154406spr_ea_dability
tenability1549126te____n_ability
testability1648806te____stability
thermostability2582046ther_mostability
traceability1956536_tr__aceability
trainability1746856_tr__ainability
trustability1756136_tr__ustability
unacceptability2681946unacceptability
unpalatability2163096unpala_tability
unthinkability2662356_unthinkability
verifiability2454446ver__ifiability
versatility1755136ver_sa_t__ility
wearability1947106we___a_rability
weatherability2572866weath_erability
wettability1946486we____ttability

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 Filter178691950240.360496363.9
2DLD Change Limit950241308.34311389.7
3Display Results1301300.0931397.8
 (SQL Overall)1786911308.79620315.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.