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

171 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
functionalities2062701functionalities_
fictionalities1963633f_ictionalities_
functionalism2064564functional__i_sm
functionalisms2163984functionali_sms_
functionalist1865264functional__i_st
functionalistic2272294functionalisti__c
functionalists1964364functionali_sts_
functionality2163534functionalit___y
functionaries1863014functiona__ries_
nationalities1356914__nationalities_
notionalities1355924__notionalities_
emotionalities1673845_emotionalities_
fictionalises1855835f_ictionali_ses_
fictionalizes2774885f_ictionali_zes_
fractionalizes28134775fractionali_zes_
functionless1752415function_l___ess
irrationalities1563125irrationalities_
optionalities1574545__optionalities_
punctualities1753465punct__ualities_
rationalities1357285__rationalities_
atonalities1148406___at_onalities_
denationalizes24115526denationali_zes_
ductilities1446206du_cti___lities_
factionalism1987086f_actional__i_sm
factionalisms20106366f_actionali_sms_
factualities1754536f_act__ualities_
farcicalities2053576farc_i_calities_
fictionalise1756266f_ictional__i_se
fictionalised1964296f_ictionali_se_d
fictionalising2062766f_ictionalisi_ng
fictionality2054616f_ictionalit___y
fictionalize2665126f_ictionali_ze__
fictionalized2864066f_ictionali_ze_d
fictionalizing2963266f_ictionalizi_ng
finalities1349906f____i_nalities_
fractionalize27115206fractionali_ze__
fractionalized29144116fractionali_ze_d
fractionalizing30112996fractionalizi_ng
fractionates1754166fractiona__t_es_
functional15116676functional______
functionally2054976functional____ly
fungibilities1964516fun_gi_bilities_
futilities1348866fu__ti___lities_
internalities1358636_in_ternalities_
municipalities2062576munici_palities_
nationalises122910366__nationali_ses_
nationalizes21178616__nationali_zes_
nuptialities1454786nu_pti__alities_
polytonalities1982746polyt_onalities_
practicalities2053566practi_calities_
renationalizes23115906renationali_zes_
tonalities101711736____t_onalities_
unmoralities1485566_un__moralities_
actinolites1354747__acti_nolit_es_
actualities1346827__act__ualities_
animalities1348997_an__i_malities_
antigravities1763087_an_tigravities_
bestialities1455497_besti__alities_
cardinalities1654377_cardi_nalities_
carnalities1348777___c_arnalities_
centralities1448627cen_t__ralities_
chiralities1646517___chi_ralities_
commonalities1965157__commonalities_
conceptualities2174297conceptualities_
concinnities1654417conc_i_n_nities_
continuities1456247con_ti_n_uities_
convivialities2262777con_vivialities_
criminalities1754747___criminalities_
criticalities1754687_criti_calities_
cyclicalities1953037_cycli_calities_
denationalize23115907denationali_ze__
denationalized25124967denationali_ze_d
denationalizing26143687denationalizi_ng
dentalities1249547den_t___alities_
dictionaries1554787_dictiona__ries_
effectualities2262207effect__ualities_
emotionalizes2454577_emotionali_zes_
erectilities1447127erecti___lities_
externalities2055187__externalities_
facilities1549827f_ac_i___lities_
facticities1846877f_acti___cities_
fatalities1349447f__at___alities_
fertilities1448827f_erti___lities_
fictionizes2554107f_iction__i_zes_
fractionate1654267fractiona__t_e__
fractionated1853087fractiona__t_e_d
fractionating1953087fractiona__ti_ng
fractionation1853207fractiona__ti_on
fractionations1952867fractiona__tions
fractionators1862137fractiona__tors_
frictionless1752557friction_l___ess
frontalities1555577f____rontalities_
functionary1953757functiona_____ry
functioned1643997function_____e_d
functioning1753247function____i_ng
functions1437747function______s_
fusibilities1746237fu__si_bilities_
genialities12148647gen__i__alities_
gentilities1249137gen_ti___lities_
impersonalities1963677impersonalities_
incivilities1756337_inc_i_vilities_
integralities1495517_in_tegralities_
inutilities1148187_inuti___lities_
junctional19105367junctional______
juniorities1853997jun__io__rities_
lectionaries1454777_lectiona__ries_
marginalities1654327_margi_nalities_
mentalities13410027men_t___alities_
microtonalities19122687microtonalities_
monotonicities1882957monot_onicities_
multipolarities1981507mu_ltipolarities_
musicalities1655827mu__si_calities_
mutualities1395837mu__t__ualities_
natalities10410667__nat___alities_
nationalise111910487__national__i_se
nationalised13197817__nationali_se_d
nationalising1454727__nationalisi_ng
nationalism131910377__national__i_sm
nationalisms14259797__nationali_sms_
nationalist111412167__national__i_st
nationalistic1595557__nationalisti__c
nationalists122010337__nationali_sts_
nationality14147937__nationalit___y
nationalize20169027__nationali_ze__
nationalized22197347__nationali_ze_d
nationalizer21176357__nationali_ze_r
nationalizers22164107__nationali_zers
nationalizing2355467__nationalizi_ng
nodalities11138587__n___odalities_
nonutilities1256687nonuti___lities_
notionality14126237__notionalit___y
optimalities1654667__opti_malities_
originalities1464887_origi_nalities_
orthogonalities1991947orthogonalities_
partialities14108037_parti__alities_
personalities1556477__personalities_
pertinacities1754537_perti_nacities_
principalities2083207princ_i_palities_
questionaries2262317questiona__ries_
quizzicalities3361287quizzi_calities_
rationalises122010377__rationali_ses_
rationalizes21199257__rationali_zes_
reactionaries1553547reactiona__ries_
renationalize22106387renationali_ze__
renationalized2495267renationali_ze_d
renationalizing25113747renationalizi_ng
seasonalities1353577__seasonalities_
sectilities1348697_secti___lities_
sectionalism1657107_sectional__i_sm
sectionalisms1756527_sectionali_sms_
sensationalises15234687sensationali_ses_
sensationalizes24253887sensationali_zes_
socialities1349297_soc_i__alities_
spatialities1465567_spati__alities_
specialities1656797spec_i__alities_
subtilities1347857su_bti___lities_
synchroneities2262607synchron_eities_
synchronicities2572427synchronicities_
tactilities1347677_tacti___lities_
totalities101210787____t_otalities_
tunabilities14138747tunabi___lities_
uncinariases1461987_unc_i_nariases_
unclarities1345337_unc___larities_
unisexualities2173207_unisexualities_
universalities1763047_universalities_
unpunctualities1971387unpunct__ualities_
unrealities1147537_un___realities_
untenabilities1657017_un_t_enabilities_
utilities9610807_u__ti___lities_
venialities14168937ven__i__alities_
verticalities1885217_verti_calities_

Search took 10 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 Limit950241718.51611158.3
3Display Results1711710.1401221.4
 (SQL Overall)1786911719.01619819.3
 
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.