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

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

132 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
predictability245398(None) 
creditability2155672credi_tability
predictably2153963predictab_l__y
presentability2164483presentability
preventability2464043preventability
printability1946843pr__intability
profitability2355103profi_tability
resectability2056083_resectability
credibility1955494credi___bility
deductibility2253504_deductibility
delectability2155674_delectability
detectability2155664_detectability
educability1946244__educ_ability
electability1947054__electability
excitability2655674__excitability
heritability2047974_heri_tability
ineducability2155434ineduc_ability
ineluctability2185044ineluctability
inevitability2156954inevi_tability
irritability1747454ir_ri_tability
perdurability2154664perd_urability
perfectibility2663264perfectibility
perishability2365194p_erishability
practicability2553294practic_ability
predictable1844984predictab_l__e
preferability2355234pre_ferability
pregnability2056134pre__gnability
preservability2453324preservability
promotability2254774pr_omotability
reducibility2054164_reduc_ibility
reliability1649454_reli__ability
rentability16410184_re__ntability
repeatability2056224_repeatability
replicability2255594_replic_ability
reputability1946974_re_putability
resistibility1864364_resistibility
respectability2353964_respectability
serviceability2462864serviceability
tractability1947074tr__actability
treatability1747414tre__atability
actability1749075____actability
adaptability2055205__adaptability
adoptability2054745__adoptability
affectability2663855_affectability
amicability2047305__amic_ability
applicability24114065applic_ability
believability2353755_believability
breathability2354065bre_athability
codifiability2473605_codifiability
conductibility2462805conductibility
creditabilities2065275credi_tabilities
creditably1844545credi_tab_l__y
decidability2145745_deci_dability
deniability1748725_deni__ability
desirability1847255_desi_rability
detachability2454305_detachability
dilatability1845445___dilatability
disability1649765___di_sability
drillability1854615dr__illability
drinkability2254675dr__inkability
drivability2046775dr__i_vability
driveability2155075dr__iveability
edibility1546915__edi___bility
equitability2645775__equitability
erectility1546265ere__ct__ility
erodibility1755945erodi___bility
extractability28103535extractability
friability1847885fr__i__ability
germinability2155045germi_nability
habitability2255085_habi_tability
ignitability1856035_igni_tability
ineradicability2383365ineradic_ability
inheritability2255585inheri_tability
intractability2155835intractability
irreducibility2262565irreduc_ibility
irrefutability2293395irrefutability
irresistibility2062655irresistibility
irrevocability2482935irrevoc_ability
justiciability2861945justiciability
leachability2255245_le_achability
meltability1848685_me__ltability
metastability2055565_metastability
modifiability2463145_modifiability
overstability21125365ove_rstability
packability2446025p___ackability
palatability1946365p__alatability
patentability2054775p_atentability
penetrability2055205p_enetrability
perceptibility2562945perceptibility
performability2663005performability
permeability2157145p_e_rmeability
permissibility2362935permissibility
placability2047125p__lac_ability
pleasurability2171945pleasurability
pliability1748045p__li__ability
portability1849535p___ortability
potability1749795p____otability
predicable1747195predic_ab_l__e
predicables1843815predic_ab_l_es
predicatively2453525predic_atively
predictively2384165predict__ively
probability2047675pr___obability
processability2363005processability
prodigality18113655prodi_ga__lity
productivity2362685product__ivity
punishability2353255p_unishability
readability1748045_re__adability
reasonability1854785_reasonability
recallability2054485_recallability
rectifiability2462565_rectifiability
reformability2354625_reformability
refundability2253935_refundability
remediability2154675_remediability
removability2255725_re_movability
renewability2055825_re_newability
repairability2055835_repairability
retrievability2252885_retrievability
reusability1648465_re__usability
spreadability2154385spre__adability
stretchability2462135stre_tchability
suitability1647115__sui_tability
testability1648805_te__stability
traceability1956515tr__aceability
trafficability2762235traffic_ability
trainability1746825tr_ai_nability
trustability1756125tr__ustability
undecidability2363095undecidability
unpredictably2362255unpredictab_l__y
unreliability1855585unreli__ability
unsuitability1865125unsui_tability
verifiability2454435_verifiability
wettability1946485_we__ttability

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.1261418182.5
2DLD Change Limit950241327.01613543.9
3Display Results1321320.0931419.4
 (SQL Overall)1786911327.23524698.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.