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

176 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
perishabilities225527(None) 
punishabilities2253172punishabilities
brushabilities2153963_brushabilities
erasabilities1549603_eras_abilities
fishabilities2146283__fishabilities
heritabilities1958193heri_tabilities
perdurabilities2074433perdurabilities
perishability2365193perishabilit__y
permeabilities2056823per_meabilities
printabilities1847273p_rintabilities
verifiabilities2354433verifiabilities
advisabilities2055544advis_abilities
believabilities22153944believabilities
breathabilities2253994breathabilities
crossabilities1855684_crossabilities
decidabilities2046234deci_dabilities
deniabilities1649764deni__abilities
desirabilities1747524desi_rabilities
detachabilities2354144detachabilities
disabilities15411104__dis_abilities
drillabilities1754784_drillabilities
drinkabilities2155034_drinkabilities
drivabilities1947244_dri_vabilities
driveabilities2055164_driveabilities
friabilities1789154_fri__abilities
germinabilities2084504germinabilities
irritabilities1647294irri_tabilities
leachabilities2155534le_achabilities
metastabilities1955494metastabilities
operabilities17510054oper___abilities
overstabilities2055244over_stabilities
penetrabilities1965324penetrabilities
perishables1852824perishab_l___es
pliabilities1649384p_li__abilities
portabilities17410184por__tabilities
preferabilities2254604preferabilities
pregnabilities1956544p_regnabilities
probabilities1958074p_r_obabilities
reliabilities15410444reli__abilities
resistibilities1753974resistibilities
reusabilities1549264re_us_abilities
risibilities1448624__ris_ibilities
testabilities1549934te__stabilities
trustabilities16105814_trustabilities
variabilities1848634vari__abilities
versatilities1656074ver_s_atilities
washabilities2145984__washabilities
adjustabilities2563235adjustabilities
admirabilities1956025admi_rabilities
admissibilities2063285admissibilities
agreeabilities1755345agr_eeabilities
alienabilities1656205_alienabilities
amiabilities16109875_ami__abilities
amicabilities19197895_ami_cabilities
applicabilities2353735appli_cabilities
arabilities13413095_ar___abilities
assignabilities1853075assignabilities
availabilities1955745avai_labilities
bearabilities1748675be__arabilities
biddabilities1944985__biddabilities
castabilities1748795__castabilities
codifiabilities2383035codifiabilities
coilabilities1748075_coi_labilities
creditabilities2065275creditabilities
curabilities1649385cur___abilities
delectabilities2065555delectabilities
dependabilities2155245dependabilities
detectabilities2065825detectabilities
deterrabilities1875385deterrabilities
detonabilities1756705de_tonabilities
divisibilities2064055divis_ibilities
drapabilities1847105_dr_apabilities
drapeabilities1955985_drapeabilities
durabilities1549335dur___abilities
edibilities1458705_edi___bilities
educabilities1857065_e_ducabilities
electabilities1857565_electabilities
eligibilities1655645_eli_gibilities
equabilities2348155_e__quabilities
equitabilities2566015_equitabilities
erodibilities1656885_er_odibilities
excitabilities2556315_excitabilities
fatigabilities2065375fati_gabilities
feasibilities1866565fe_as_ibilities
forgeabilities2054725for_geabilities
formabilities2046995for__mabilities
formidabilities2353375formidabilities
habitabilities21125315habi_tabilities
hatchabilities2453995_hatchabilities
ignitabilities17106305igni_tabilities
immiscibilities2363365immiscibilities
impassabilities21155245impassabilities
imperishability2772695imperishabilit__y
inabilities13412735___i_nabilities
inevitabilities2055645inevi_tabilities
instabilities1549845__instabilities
inviabilities1848815invi__abilities
inviolabilities2064315inviolabilities
invisibilities1956115invis_ibilities
irascibilities1854815_irascibilities
legibilities1547475legi___bilities
liabilities13710255__li__abilities
likabilities1877275__li_kabilities
livabilities1767715__li_vabilities
liveabilities1846755__liveabilities
mailabilities1767695_mai_labilities
marketabilities2353735marketabilities
measurabilities1964225measurabilities
meltabilities1749865me__ltabilities
memorabilities20137005me_morabilities
mensurabilities1964415mensurabilities
miscibilities1955695__miscibilities
modifiabilities2382845modifiabilities
navigabilities2064955navi_gabilities
negotiabilities1854035negotiabilities
openabilities1748615ope___nabilities
opposabilities2054905oppos_abilities
packabilities2346565p__ackabilities
palatabilities1846785p_alatabilities
palpabilities1947245p__alpabilities
partibilities1748095par__tibilities
patentabilities1995335patentabilities
periodicities1854905peri__odicities
perishable1745265perishab_l___e_
personalities1556475per_s_onalities
placabilities1947625p__lacabilities
plausibilities1873755plaus_ibilities
playabilities2046605p__layabilities
possibilities1756055p__ossibilities
potabilities16411295p___otabilities
primalities1548285p_ri_ma__lities
profitabilities2284565profitabilities
promotabilities2184525promotabilities
punishability2353255punishabilit__y
readabilities1649305__readabilities
reasonabilities1754665reasonabilities
recallabilities1963955recallabilities
reformabilities2264535reformabilities
refundabilities2153925refundabilities
remediabilities2054615remediabilities
removabilities2186315re_movabilities
renewabilities1956205re_newabilities
rentabilities15411235__rentabilities
repairabilities1955365repairabilities
repeatabilities1955915repeatabilities
replicabilities2155105replicabilities
reputabilities1847425re_putabilities
resectabilities1956015resectabilities
roadabilities1647795__roadabilities
sensibilities1557365se_ns_ibilities
separabilities1847345se_parabilities
severabilities1947435se_verabilities
sewabilities1748935se___wabilities
sociabilities1748385soci__abilities
sorbabilities1746995sor__babilities
spreadabilities2054005spreadabilities
stabilities13511755____stabilities
stainabilities1655725stai_nabilities
suabilities13610785____suabilities
suitabilities1548065_sui_tabilities
survivabilities2352705survivabilities
tenabilities14911485te___nabilities
traceabilities1855865_traceabilities
tractabilities1846585_tractabilities
trainabilities1646595_trainabilities
treatabilities1657605_treatabilities
unreliabilities1754785unreliabilities
upgradabilities2162465upgr_adabilities
usabilities1368985___us_abilities
venerabilities1967355ve_nerabilities
viabilities1679675__vi__abilities
violabilities1856815__violabilities
visibilities1747375__vis_ibilities
wearabilities1848415we__arabilities
wettabilities1847775we__ttabilities
workabilities2245675wor__kabilities

Search took 6 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.1101624463.6
2DLD Change Limit658741765.26612509.3
3Display Results1761760.1231430.9
 (SQL Overall)1786911765.49932495.2
 
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.