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

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

57 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
impenetrability2462481impenetrability_
penetrability2055213__penetrability_
impenetrably2152284impenetrab_l__y_
imponderability25132144imponderability_
impeccability2654465imp__eccability_
impenetrable1852375impenetrab_l___e
imperishability2772725imperishability_
impermeability2563915impe_rmeability_
impregnability24163235imp_regnability_
imputability2146385imp__ut_ability_
mensurability2054385_m_ensurability_
penetrabilities1965345__penetrabilities
venerability2046775__vene_rability_
amenability1847496am_en___ability_
compensability2563536compen__sability_
demonstrability2382256demonstrability_
dependability2254866depen__dability_
deterrability1974996__deterrability_
dispensability2263206dispen__sability_
expendability2853846expen__dability_
ignitability1856056i__gnit_ability_
immutability2155896im__mut_ability_
impalpability2454116imp__alpability_
impassability2265266imp__assability_
implacability2454886imp__lacability_
impressibility2364406imp_ressibility_
improbability2464406imp__robability_
improvability2564596imp__rovability_
inalterability1954566inalte_rability_
ineffability2356396i___neffability_
inevitability2156966i_nevit_ability_
inexorability2585466i_ne_xorability_
inheritability2255606inherit_ability_
inseparability2154436inse_parability_
instability1649446i___nst_ability_
insurability1757226i___nsurability_
integrability1956586i__ntegrability_
intolerability1964526intole_rability_
invulnerability2372216invulne_rability_
irrefutability2293406irrefut_ability_
irrepealability2262286irrepealability_
marketability2454136_market_ability_
measurability2054476_m_easurability_
meltability1848686_m_e_lt_ability_
memorability2146446_m_e_morability_
openability1846936_open___ability_
operability1848856_op__e_rability_
patentability2054786paten_t_ability_
penetralia1254126__penetra__li__a
perdurability2154686__perdurability_
preferability2355256_prefe_rability_
renewability2055836__rene_wability_
rentability16410196__ren_t_ability_
repeatability2056246repe_at_ability_
severability2046756__seve_rability_
sinterability1855216__sinterability_
vulnerability2153266_vulne_rability_

Search took 5 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 Filter178691658740.326548131.9
2DLD Change Limit65874574.54614490.5
3Display Results57570.0461239.1
 (SQL Overall)178691574.91836334.1
 
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.