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

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

148 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
commercialities2363311commercialities_
commercialises22173813commerciali_ses_
commercializes31193783commerciali_zes_
commercialise21184164commercial__i_se
commercialised23193014commerciali_se_d
commercialising2472274commercialisi_ng
commercialism20184184commercial__i_sm
commercialisms21183664commerciali_sms_
commercialist21204684commercial__i_st
commercialistic2292114commercialisti__c
commercialists22183824commerciali_sts_
commerciality2463384commercialit___y
commercialize30184034commerciali_ze__
commercialized32203524commerciali_ze_d
commercializing3362714commercializi_ng
coercivities1954245co__erci_vities_
collegialities1763045colle_gialities_
comicalities1846975co_m_ic_alities_
commercials1954305commercial____s_
commonalities1965155comm__onalities_
communalities1954845comm__unalities_
congenialities1774195conge_nialities_
cordialities1546135co___rdialities_
homosocialities2292065homosocialities_
coequalities2355566co__e_qualities_
coevalities1646806co__e__valities_
colloquialities2671886colloquialities_
commercial1855286commercial______
commercially2354146commercial____ly
commonalties1854256comm__onal_ties_
comparabilities2374376comparabilities_
conceptualities2174296conceptualities_
connubialities1862596co_nnubialities_
convivialities2262776co_nvivialities_
corporalities1755296corpor__alities_
corporealities1863206corpor_ealities_
imbecilities1853656_imbe_ci_lities_
immaterialities1962876immater_ialities_
immoralities1655736_immor__alities_
immortalities1754206_immor_talities_
impartialities1863496_impartialities_
materialities1566396_mater_ialities_
potentialities1674206po_tentialities_
socialities1349296so____cialities_
specialities1656796__spe_cialities_
amoralities1347427__amor__alities_
artificialities2061967artificialities_
bestialities1455497___bestialities_
capercaillies1961387c_apercail_lies_
capercailzies2861267c_apercail_zies_
cardinalities1654377c___ardinalities_
carnalities1348777c___ar_nalities_
centralities1448627c___entralities_
chiralities1646517c__hir__alities_
churchianities247837c__hurchianities_
classicalities1862537classic_alities_
coilabilities1748097co_ilabi_lities_
collateralities17152337collateralities_
collectivities2174167colle_ctivities_
commemorates1753577commemora__t_es_
commemoratives2262427commemorati_ves_
commensalism1764957comme_nsal__i_sm
commensalisms1873757comme_nsali_sms_
commentaries1856807comme_nta__ries_
commentates17107617comme_nta__t_es_
commerces17147237commerc______es_
commodities1845497comm____odities_
communalizes2754237comm__unali_zes_
communicatees2163647communica__tees_
communicates2055617communica__t_es_
communities1747277comm____unities_
commutativities2471507commutativities_
compatibilities2363627compatibilities_
complicities2055967co_m_pli_cities_
compulsivities2361917compulsi_vities_
computabilities2354547computabilities_
concavities1846127co___nc_avities_
concinnities1654417co___ncinnities_
conjugalities2353007co__njugalities_
connaturalities17162607connaturalities_
connectivities2164477conne_ctivities_
contractilities1983197contractilities_
countabilities1856697countabi_lities_
criminalities1754747crim__inalities_
criticalities1754687c_ritic_alities_
cyclicalities1953037c_yclic_alities_
docilities1349007do____ci_lities_
domesticities1863807do_mesti_cities_
enumerabilities1954077enumerabilities_
ephemeralities2171787ephemer__alities_
essentialities1473247_essentialities_
etherealities1653697_ether_ealities_
externalities2055187_exter_nalities_
farcicalities2053577___farcicalities_
fertilities1448827___ferti_lities_
forgeabilities2054727forgeabi_lities_
formabilities2047007form_abi_lities_
formalities16137827fo___r_malities_
generalities1347017_gener__alities_
genialities12148647___ge_nialities_
homosexualities2772287homosexualities_
immiscibilities2363397_immiscibilities_
immobilities1846267_imm_obi_lities_
impersonalities1963677_impersonalities_
infertilities1656217_inferti_lities_
internalities1358637_inter_nalities_
jovialities2145167jo____vialities_
lexicalities2154727___lexicalities_
liberalities1446267_liber__alities_
literalities1267547_liter__alities_
localities1259737lo____c_alities_
logicalities1555057lo__gic_alities_
lognormalities1761707lognor_malities_
mammalities1444857mamm____alities_
marginalities1654327___marginalities_
mentalities13410027___me_ntalities_
monumentalities1962447monume_ntalities_
moralities121111927___mor__alities_
mortalities1348427___mor_talities_
municipalities2062577__municipalities_
musicalities1655827__music_alities_
nonmotilities1555137nonm_oti_lities_
normalities13148117no___r_malities_
operabilities17510057_o_perabilities_
oralities91214127_o___r__alities_
osmolalities1454177_osm__olalities_
overcapacities2372377_o_vercapacities_
partialities14108037___partialities_
permeabilities2056847permeabi_lities_
posteriorities1661857poster_iorities_
provincialities2262257provincialities_
puerilities1347537__puer_i_lities_
servilities1447057___servi_lities_
socialites1247507so____cialit_es_
solderabilities1873377solderabilities_
specialties1544667__spe_cial_ties_
sterilities11129017__ster_i_lities_
summabilities1975647summ_abi_lities_
temporalities1753497tempor__alities_
theatricalities2061687theatricalities_
tolerabilities16116607to_lerabilities_
topicalities1655587to__pic_alities_
universalities1763047univer_salities_
unmoralities1485567_unmor__alities_
venialities14168937___ve_nialities_
verticalities1885217___verticalities_
vocalities1549397vo____c_alities_
whimsicalities2461737whimsic_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.360496363.9
2DLD Change Limit950241488.29611454.2
3Display Results1481480.1101345.5
 (SQL Overall)1786911488.76620384.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.