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

197 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
farcicalities205357(None) 
cardinalities1654393cardinalities
facilities1549823fa_ci__lities
factualities1754533fa_ctualities
farcicality2153283farcicalit__y
marginalities1654343marginalities
parfocalities2053713parfocalities
partialities14108043parti_alities
practicalities2053563practicalities
verticalities1885213verticalities
actualities1346824_a_ctualities
animalities1348994_a_nimalities
atypicalities2052684atypicalities
axialities1747734_a_xi_alities
carnalities1348784car__nalities
classicalities1862534classicalities
comicalities1846974_comicalities
cordialities1546154cordi_alities
criticalities1754684criticalities
cyclicalities1953034cyclicalities
ethicalities1754444_ethicalities
facticities1846874factic__ities
fallibilities1854544fallibilities
fatalities1349444fa___talities
fertilities1448824ferti__lities
finalities1349914f___inalities
formalities16137824for__malities
fragilities1547164fragi__lities
frivolities1744054f_r_ivolities
frontalities1555594f_rontalities
frugalities1544164f_r_ugalities
gracilities1447684graci__lities
labialities1347034la_bi_alities
lexicalities2154724_lexicalities
logicalities1555054_logicalities
musicalities1655824_musicalities
partibilities1748104partibilities
physicalities2393644physicalities
primalities1548294_pr_imalities
rascalities1347224__rascalities
socialities1349294_soci_alities
specialities1656794speci_alities
topicalities1655584_topicalities
typicalities1954154_typicalities
varicosities1753484var_icosities
veridicalities2063064veridicalities
abilities11714145_a_bi__lities
acidities12810185_a_ci__dities
acridities1348295_acri__dities
admiralties1452095_admiral_ties
agilities10810975_a_gi__lities
amicabilities19197915_a_micabilities
amoralities1347425_a_moralities
analities9715875_a___nalities
anilities9516005_a_ni__lities
arabilities13413105_ar_abilities
argillites1143485_argi_llit_es
aridities10911635_ar_i__dities
articulacies1664785_articulacies
articulates1349045_articulat_es
artificialities2061965_artificialities
asexualities1994575_asexualities
atonalities1148415_a_tonalities
audibilities1546645_audibilities
auralities10410225_a__uralities
banalities1249815ba___nalities
barbarities1544995bar__barities
basicities1446865ba_sic__ities
bestialities1455495besti_alities
brutalities1345445_br_utalities
cardinalates1552625cardinalat_es
cariosities1346505car_i_osities
causalities1346225ca__usalities
chiralities1646515__chiralities
circularities1755035circularities
civilities1547845___civilities
corporalities1755295corporalities
criminalities1754745criminalities
docilities1349005_doci__lities
effectualities2262205effectualities
efficacities2252195_efficacities
fabricates1746485fabrica__t_es
facilitates1644305fa_ci__litates
faculties1455145fa___cul_ties
familiarities1852865familiarities
farcical1546955farcical_____
farcically2046325farcical___ly
fascicles1664265fascic_l___es
fasciculate1854005fasciculat_e_
fasciculated2053055fasciculat_ed
fasciculation20133565fasciculation
fasciculations21133095fasciculations
fascicules1742985fascicul___es
fasciitis1443545fasci___iti_s
fasciitises1652565fasci___itises
fascinates1547155fascina__t_es
fascioliases17131445fasci_oliases
fatigabilities2065385fa_tigabilities
fayalites1546065fa___yalit_es
feasibilities1866565feasibilities
febricities1844955febric__ities
febrilities1645155febri__lities
felicities1549745f_elic__ities
feracities1548715fer___acities
ferocities1548255fer_oc__ities
fervidities1863945fervi__dities
feudalities1545345f__eudalities
fictionalities1963645fictionalities
fidelities1445935f___idelities
fissilities1445655fissi__lities
flaccidities2052195flac_cidities
flexibilities2564015flexibilities
folliculitis1761155folliculiti_s
folliculitises1961255folliculitises
formabilities2047005formabilities
formicaries1853655formica__ries
formidabilities2353375formidabilities
fornicates1545855fornica__t_es
frailties1245855f_rai__l_ties
frangibilities2054035frangibilities
friabilities1789185f_riabilities
fricatives1844695f_r_icati_ves
frigidities1644035f_r_igidities
functionalities2062705functionalities
fungibilities1964515fungibilities
fusibilities1746235f_usibilities
futilities1348865f_uti__lities
garrulities1243515gar__rulities
genialities12148645_geni_alities
haecceities1851715haec_c_eities
hospitalities1854125hospitalities
illogicalities17132525illogicalities
impartialities1863495imparti_alities
incivilities1756335_incivilities
irascibilities1854835irascibilities
irrealities1146215_ir_realities
jovialities2145165_jovi_alities
labilities12712235la_bi__lities
localities1259735___localities
mammalities1444855ma__mmalities
marcasites1445625mar__casit_es
marginalizes2463595marginali_zes
materialities1566395materialities
miscibilities1955715miscibilities
moralities121111925mor___alities
mortalities1348425mor__talities
municipalities2062575municipalities
nasalities1048565na___salities
natalities10410665na___talities
nationalities1356925nationalities
normalities13148115nor__malities
nuptialities1454785nupti_alities
optimalities1654665_optimalities
oracularities1553045oracularities
oralities91214125_or___alities
originalities1464885originalities
parfocalizes2852845parfocali_zes
particularities1993375particularities
particulates1647375particulat_es
personalities1556475personalities
perspicacities2261995perspicacities
pertinacities1754535pertinacities
principalities2083205principalities
prodigalities1763935prodigalities
punctualities1753465punctualities
quizzicalities3361285quizzicalities
racializes2148465ra_ci_ali_zes
radicalises1445585ra_dicali_ses
radicalizes2345695ra_dicali_zes
rancidities1445595ranci__dities
rationalities1357305rationalities
realities9316315__r__ealities
regalities11410595__r_egalities
ruralities1048575__r_uralities
servilities1447055servi__lities
socialites1247505_soci_alit_es
spatialities1465565spati_alities
specialties1544665speci_al_ties
spiralities1348015__spiralities
tactilities1347675ta_c_tilities
tangibilities1655485tangibilities
technicalities2161955technicalities
theatricalities2061685theatricalities
trivialities1555225_trivialities
unrealities1147535unr__ealities
vagilities1447955va_gi__lities
variabilities1848645variabilities
variolites1346675var_i_olit_es
vascularities1893315vascularities
venialities14168935_veni_alities
vermiculites1952995vermiculit_es
virilities1379135vir_i__lities
virtualities1554695vir_tualities
vitalities1349095___vitalities
vocalities1549395___vocalities
vorticities1647095vortic__ities
whimsicalities2461735whimsicalities

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 Filter1786911247900.420425454.8
2DLD Change Limit1247901979.33013375.1
3Display Results1971970.1231601.6
 (SQL Overall)1786911979.87318099.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.