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

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

152 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
provincialities226225(None) 
provincializes3062032provinciali_zes
principalities2083203pr__incipalities
provincialisms23102213provinciali_sms
provincialists21122303provinciali_sts
provinciality2362333provincialit__y
provincialize2962073provinciali_ze_
provincialized3161833provinciali_zed
provincializing3271593provincializing
potentialities1674194p_otentialities
prodigalities1763934prodi__galities
provincialism22102434provincial__ism
provincialist20102814provincial__ist
provincials1852944provincial____s
artificialities2061965artificialities
comicalities1846955_comi_c_alities
convivialities2262775convi_vialities
criminalities1754735crimin__alities
criticalities1754675criti_c_alities
erodibilities1656885erodi_bi_lities
frontalities1555555fro__n_talities
invincibilities2293725_invincibilities
jovialities2145165_jov___ialities
logicalities1555055_logi_c_alities
originalities1464885origin__alities
physicalities2393635physi_c_alities
practicalities2053565practic_alities
prehensilities1962175prehensi_lities
primalities1548285pr__i__malities
probabilities1958075pro_babi_lities
profitabilities2284565profitabilities
prolificities2053475proli_fi_cities
promiscuities1981785promisc__uities
propinquities2662075propin__quities
provincial1754015provincial_____
provincially2253025provincial___ly
socialities1349285_so___cialities
topicalities1655585_topi_c_alities
triaxialities2063045tr__iaxialities
trivialities1555215tr__i_vialities
venialities14168935___ven_ialities
atonalities1148396ato__n__alities
atypicalities2052686atypi_c_alities
bovinities1546006_bovin____ities
cardinalities1654356cardin__alities
colinearities1553716_colin_earities
collegialities1763046_collegialities
commercialities2363306commercialities
concavities1846116_co__nc_avities
concinnities1654406_co__ncinnities
congenialities1774196_congenialities
connubialities1862596_connubialities
cordialities1546126_co__rdialities
credibilities1856066credi_bi_lities
crossabilities1855686crossabi_lities
cyclicalities1953036cycli_c_alities
docilities1349006_do___ci_lities
drivabilities1947246driv_abi_lities
driveabilities2055166driveabi_lities
emotionalities1673846emoti_onalities
equivocalities28112066equivoc_alities
essentialities1473236_essentialities
ethicalities1754436_ethi_c_alities
eventualities1653516__eventualities
farcicalities2053576farci_c_alities
finalities1349886___fin__alities
friabilities1789156fr__iabi_lities
genialities12148646___gen_ialities
gracilities1447676gr___aci_lities
homosocialities2292066homosocialities
illogicalities17132526illogi_c_alities
improvabilities24114476improv_abi_lities
incivilities1756336____incivilities
inviabilities1848816_inviabi_lities
jovialties2042346_jov___ial_ties
juvenilities2252726_juven_i_lities
lexicalities2154726_lexi_c_alities
linealities1148206___lin_ealities
localities1259736_lo___c_alities
lovabilities1788006_lov_abi_lities
marginalities1654326margin__alities
movabilities1978366_mov_abi_lities
municipalities2062576_muni_cipalities
musicalities1655826_musi_c_alities
notionalities1355926_noti_onalities
noviciates1543766_novi_cia__t_es
ovalities12119806__ov____alities
oviparities1654296__ovi__parities
parfocalities2053716p_arfoc_alities
partialities14108036p___artialities
partibilities1748096parti_bi_lities
penalities121313446p___en__alities
personalities1556476person__alities
perspicacities2261996perspi_c_acities
pertinacities1754536pertin__acities
pliabilities1649386p__liabi_lities
politicalizes2663186p_oliticali_zes
polytonalities1982746p_olytonalities
portabilities17410186p_ortabi_lities
positivities1755456p_osi_ti_vities
possibilities1756056p_ossibi_lities
potabilities16411296p_o_tabi_lities
preciosities1655376pr___eciosities
pregnabilities1956546pr_egnabilities
primitivities2073566primi_ti_vities
principality2162666pr__incipalit__y
principalships22141446pr__incipalships
principles1643846pr__incipl___es
printabilities1847276pr__intabilities
proclitics1645636pro___c__litics
proclivities1964676pro___clivities
productivities2282596pro_ductivities
profanities1676236pro____fanities
proficiencies2261816profi_ci_encies
profundities1852616profun___dities
prolificacies22131656prolifica__cies
prolixities2046356pro___li_xities
promotabilities2184526promotabilities
pronunciation17113226pronuncia__tion
pronunciations18122776pronunciati_ons
propensities1655266propen___sities
propitiates1546206propi_tia__t_es
provinces1646856provinc______es
provocatives2253376prov_oc_ati_ves
proximities2255886pro___xi_mities
punctualities1753446p___unctualities
pyrogenicities2263566pyrogen_i_cities
rancidities1445576_r__anci_dities
rascalities1347206_r__asc_alities
rationalities1357266_rati_onalities
reliabilities15410446_reliabi_lities
risibilities1448626_risi_bi_lities
roadabilities1647796_roadabi_lities
sociabilities1748386_sociabi_lities
socialites1247506_so___cialit_es
specialities1656776___specialities
technicalities2161956technic_alities
tonalities101711736_to__n__alities
trainabilities1646596tr_ainabilities
tropicalizes2554126tropi_c_ali_zes
typicalities1954156_typi_c_alities
venalities131510726___ven__alities
veridicalities2063066veridi_c_alities
verticalities1885216verti_c_alities
viabilities1679676___viabi_lities
vicinities1547456___vi_ci_nities
virilities1379126___vi_ri_lities
virtualities1554696___virtualities
viscidities1744466___visci_dities
visualities1446546___vi_sualities
vitalities1349086___vi__talities
vocalities1549396___v_oc_alities

Search took 9 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.1231452772.4
2DLD Change Limit950241528.48611197.7
3Display Results1521520.1061434.0
 (SQL Overall)1786911528.71520503.8
 
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.