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

145 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
preferabilities225460(None) 
penetrabilities1965323p_enetrabilities
perdurabilities2074433perdurabilities
permeabilities2056823perme_abilities
preferability2355233preferabilit__y
pregnabilities1956543pre_gnabilities
profitabilities2284563profitabilities
reformabilities2264533_reformabilities
renewabilities1956203_renewabilities
severabilities1947433_severabilities
venerabilities1967353_venerabilities
agreeabilities1755344agre_e_abilities
alterabilities1667334_alterabilities
bearabilities1748674_be_arabilities
breathabilities2253994breathabilities
creditabilities2065274creditabilities
desirabilities1747524_desirabilities
deterrabilities1875384_deterrabilities
drapeabilities1955984drape_abilities
driveabilities2055164drive_abilities
enumerabilities1954064enumerabilities
filterabilities2053284filterabilities
ineffabilities2256154inef_fabilities
inexorabilities2454674inexorabilities
memorabilities20137004_memorabilities
operabilities17510054__operabilities
perishabilities2255274perishabilities
prehensilities1962174prehe_nsilities
printabilities1847274pr_intabilities
probabilities1958074pr__obabilities
promotabilities2184524promotabilities
readabilities1649304_re_adabilities
refundabilities2153924_refundabilities
reliabilities15410444_re_liabilities
remediabilities2054614_remediabilities
removabilities2186314_removabilities
rentabilities15411234_re_ntabilities
repairabilities1955364_repairabilities
repeatabilities1955914_repeatabilities
reputabilities1847424_reputabilities
resectabilities1956014_resectabilities
reusabilities1549264_re_usabilities
reversibilities2084154_reversibilities
separabilities1847344_separabilities
sinterabilities17114614sinterabilities
solderabilities1873374solderabilities
spreadabilities2054004spre_adabilities
tolerabilities16116604_tolerabilities
traceabilities1855864trace_abilities
treatabilities1657604tre_atabilities
vulnerabilities2053084vulnerabilities
wearabilities1848414_we_arabilities
admirabilities1956025_admirabilities
adorabilities1647805__adorabilities
affabilities2046945__af_fabilities
affectabilities2553985affectabilities
affordabilities2453055_affordabilities
alienabilities1656205_alienabilities
amenabilities1778835__amenabilities
appealabilities2163885appe_alabilities
arabilities13413095____arabilities
believabilities22153945believabilities
brushabilities2153965br_ushabilities
cleanabilities1856045cle_anabilities
comparabilities2374375comparabilities
credibilities1856065cr__edibilities
crossabilities1855685cr_ossabilities
curabilities1649385___curabilities
decidabilities2046235_decidabilities
defeasibilities2153815_defeasibilities
defensibilities2164045_defensibilities
delectabilities2065555_delectabilities
deniabilities1649765_de_niabilities
dependabilities2155245_dependabilities
detectabilities2065825_detectabilities
detonabilities1756705_detonabilities
drapabilities1847105dr__apabilities
drillabilities1754785dr_illabilities
drinkabilities2155035dr_inkabilities
drivabilities1947245dr__ivabilities
durabilities1549335___durabilities
dyeabilities1847865__dye_abilities
educabilities1857065__educabilities
electabilities1857565ele_ctabilities
ephemeralities2171785ephemera__lities
equabilities2348155__e_quabilities
erasabilities1549605__erasabilities
fertilities1448815___fer_tilities
forgeabilities2054725forge_abilities
formabilities2046995___formabilities
fragilities1547155___f_ragilities
friabilities1789155___friabilities
generalities1347015_genera__lities
germinabilities2084505germinabilities
heritabilities1958195_heritabilities
honorabilities1955945_honorabilities
ineducabilities2054235ineducabilities
inevitabilities2055645inevitabilities
infertilities1656205_infer_tilities
insurabilities1676895_insurabilities
integrabilities1885505integrabilities
irritabilities1647295ir_ritabilities
leachabilities2155535_leachabilities
liveabilities1846755_live_abilities
malleabilities1874975malle_abilities
marketabilities2353735marketabilities
measurabilities1964225measurabilities
meltabilities1749865_me_ltabilities
mensurabilities1964415mensurabilities
observabilities2293745_observabilities
openabilities1748615__openabilities
overstabilities2055245overstabilities
packabilities2346555p__ackabilities
palatabilities1846785p_alatabilities
palpabilities1947245p__alpabilities
patentabilities1995335patentabilities
perfectivities2483875perfe_ctivities
placabilities1947615p__lacabilities
playabilities2046605p__layabilities
pliabilities1649385p___liabilities
portabilities17410185p__ortabilities
potabilities16411295p___otabilities
preferable1746725preferab_l___e_
preservability2453325preservabilit__y
puerilities1347535p__uer__ilities
punishabilities2253175punishabilities
reasonabilities1754665_reasonabilities
recallabilities1963955_recallabilities
reducibilities1954165_reducibilities
refractivities22103965_ref_ractivities
replicabilities2155105_replicabilities
retractilities1674075_re_tractilities
roadabilities1647795_r_oadabilities
sewabilities1748935___sewabilities
shareabilities1955215share_abilities
squeezabilities3562305squeezabilities
tenabilities14911485___tenabilities
testabilities1549935_te_stabilities
tractabilities1846585tr_actabilities
trainabilities1646595tr_ainabilities
trustabilities16105815tr_ustabilities
unreliabilities1754785unre_liabilities
untenabilities1656995_untenabilities
verifiabilities2354435verifiabilities
wettabilities1847775_we_ttabilities

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.1061685764.2
2DLD Change Limit658741455.08012967.3
3Display Results1451450.1101318.2
 (SQL Overall)1786911455.29633740.7
 
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.