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
unpalatability216309(None) 
palatability1946382__palatability
analyzability3053424an_alyzability
dilatability1845454__dilatability
impalpability2454114impal_pability
implacability2454884imp_lacability
palpability2046334__pal_pability
placability2047144__p_lacability
playability2146024__p_layability
repeatability2056244rep_eatability
unalterability1963474un_alterability
unavailability2263624un_availability
unflappability2682334unflappability
unpalatable1544794unpalatab_l__e
unreliability1855604unrel_iability
unsuitability1865134un_suitability
upgradability2253044u_pgradability
actability1749085___a_ctability
adaptability2055225_ada_ptability
appealability2253965_appealability
applicability24114065_applicability
castability1848415__ca_stability
employability2553045emp_loyability
expandability2853695expa_ndability
exportability2774255exp_ortability
habitability2255095__habitability
impassability2265265impa_ssability
imputability2146385imp__utability
inalienability1954555in_alienability
inalterability1954565in_alterability
inapplicability26102925inapplicability
incalculability2462215incalculability
incapability2156515in__capability
indomitability2254835indomitability
indubitability2264075indubitability
ineluctability2185055ineluctability
inevitability2156965in_evitability
infallibility2164305infal_libility
inflammability2663465inflammability
inheritability2255605inheritability
insatiability1856495insa_tiability
inscrutability2163835inscrutability
inseparability2154435inseparability
instability1649445in___stability
intolerability1964525intolerability
intractability2155865intractability
invariability2155975inva_riability
localizability3062185localizability
malleability1954845__malleability
meltability1848685__mel_tability
metastability2055575meta_stability
navigability2155445_n_avigability
notability1549705_n___otability
packability2446045__pa_ckability
palatabilities1846805__palatabilities
palatably1644445__palatab_l__y
partibility1847115__pa_rtibility
patentability2054785__patentability
pliability1748055__p_l_iability
portability1849565__p_ortability
potability1749815__p__otability
printability1946865__printability
recallability2054505recal_lability
repairability2055855repa_irability
replicability2255605rep_licability
reputability1946985rep__utability
salability1548525__sal__ability
separability1946915sep__arability
spreadability2154405_spreadability
supportability2362245supportability
tractability1947095_tra_ctability
translatability2061685translatability
treatability1747435__treatability
unacceptability2681945unacceptability
unassailability2072325unassailability
unchangeability2672025unchangeability
undecidability2363105undecidability
undesirability2063935undesirability
unemployability2771465unemployability
unknowability2572345un_knowability
unsociability2054895un_sociability
untenability1756425un__tenability
unthinkability2662355unthinkability
untouchability2462285untouchability
unworkability2552905un_workability
upgradeability2362435u_pgradeability

Search took 8 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 Limit95024866.94013692.2
3Display Results86860.140614.3
 (SQL Overall)178691867.44024017.6
 
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.