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

86 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
unpalatability216308(None) 
palatability1946372__palatability
analyzability3053424an_alyzability
dilatability1845444__dilatability
impalpability2454104impal_pability
implacability2454874imp_lacability
palpability2046324__pal_pability
placability2047134__p_lacability
playability2146014__p_layability
repeatability2056234rep_eatability
unalterability1963474un_alterability
unavailability2263614un_availability
unflappability2682324unflappability
unpalatable1544794unpalatab_l__e
unreliability1855594unrel_iability
unsuitability1865134un_suitability
upgradability2253034u_pgradability
actability1749075___a_ctability
adaptability2055215_ada_ptability
appealability2253955_appealability
applicability24114065_applicability
castability1848405__ca_stability
employability2553045emp_loyability
expandability2853685expa_ndability
exportability2774245exp_ortability
habitability2255095__habitability
impassability2265255impa_ssability
imputability2146385imp__utability
inalienability1954555in_alienability
inalterability1954565in_alterability
inapplicability26102925inapplicability
incalculability2462215incalculability
incapability2156505in__capability
indomitability2254835indomitability
indubitability2264075indubitability
ineluctability2185055ineluctability
inevitability2156965in_evitability
infallibility2164305infal_libility
inflammability2663455inflammability
inheritability2255595inheritability
insatiability1856485insa_tiability
inscrutability2163825inscrutability
inseparability2154425inseparability
instability1649445in___stability
intolerability1964525intolerability
intractability2155855intractability
invariability2155965inva_riability
localizability3062175localizability
malleability1954845__malleability
meltability1848685__mel_tability
metastability2055565meta_stability
navigability2155445_n_avigability
notability1549695_n___otability
packability2446035__pa_ckability
palatabilities1846805__palatabilities
palatably1644445__palatab_l__y
partibility1847105__pa_rtibility
patentability2054775__patentability
pliability1748045__p_l_iability
portability1849555__p_ortability
potability1749805__p__otability
printability1946855__printability
recallability2054495recal_lability
repairability2055845repa_irability
replicability2255595rep_licability
reputability1946975rep__utability
salability1548515__sal__ability
separability1946905sep__arability
spreadability2154395_spreadability
supportability2362235supportability
tractability1947085_tra_ctability
translatability2061675translatability
treatability1747425__treatability
unacceptability2681945unacceptability
unassailability2072315unassailability
unchangeability2672025unchangeability
undecidability2363105undecidability
undesirability2063935undesirability
unemployability2771465unemployability
unknowability2572345un_knowability
unsociability2054895un_sociability
untenability1756425un__tenability
unthinkability2662355unthinkability
untouchability2462285untouchability
unworkability2552895un_workability
upgradeability2362425u_pgradeability

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.1101624463.6
2DLD Change Limit95024866.51614583.2
3Display Results86860.0631365.1
 (SQL Overall)178691866.68926714.2
 
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.