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

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

52 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
unflappability268233(None) 
inflammability2663463inflammability
unflappably2352273unflappab_l__y
flammability2453904__flammability
incapability2156514in_ca_pability
nonflammability2771514nonflammability
unalterability1963474unalterability
unavailability2263624unavailability
unflappable2053054unflappab_l__e
unpalatability2163094unpalatability
adaptability2055225__adaptability
analyzability3053425anal_yzability
capability1947595___ca_pability
collapsibility2361965collapsibility
culpability2045295_cul__pability
dilatability1845455_dila_tability
drapability1986475__dra_pability
drapeability2055915__drapeability
enforceability2472555enforceability
impalpability2454115_impalpability
implacability2454885impla_cability
inalienability1954555inalienability
inalterability1954565inalterability
ineffaceability2862285ineffaceability
ineluctability2185055ineluctability
infallibility2164305inf_allibility
infeasibility2155725infea_sibility
inflexibility2883935infl_exibility
infrangibility2363635infrangibility
insatiability1856495in_satiability
inseparability2154435inseparability
intractability2155865intractability
invariability2155975in_variability
palatability1946385_pala_tability
palpability2046335___palpability
placability2047145__pla_cability
playability2146025__pla_yability
unacceptability2681945unacceptability
unassailability2072325unassailability
unchangeability2672025unchangeability
undecidability2363105undecidability
undesirability2063935undesirability
unknowability2572345un_knowability
unreliability1855605un_reliability
unsociability2054895un_sociability
unsuitability1865135un_suitability
untenability1756425un__tenability
unthinkability2662355unthinkability
untouchability2462285untouchability
unworkability2552905un_workability
upgradability2253045upgra_dability
upgradeability2362435upgradeability

Search took 7 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.390458182.1
2DLD Change Limit95024526.12315519.2
3Display Results52520.0331575.8
 (SQL Overall)178691526.54627297.7
 
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.