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

213 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
noncelebrations1912282(None) 
concelebrations21103161concelebrations
noncelebration18113311noncelebration_
concelebration20133562concelebration_
celebrations1645743___celebrations
concelebrating2172593concelebrati_ng
noncelebrities1862163noncelebriti_es
accelerations1754194_accele_rations
celebration1546464___celebration_
cerebrations1646964___cerebrations
concelebrates19113584concelebrat__es
concentrations1877074conce_ntrations
confederations20104604confede_rations
decelerations1646424_decele_rations
decerebrations1993744_decerebrations
noncooperations1963174noncooperations
noncultivations20182754noncultivations
nonelections1456394non_ele__ctions
acceleration1654815_accele_ration_
calibrations1645155___calibrations
cancelations1657095cancel___ations
cancellations1754395cancel__lations
celebrating1646115___celebrati_ng
celebrators1544405___celebrat_ors
cerebration1547925___cerebration_
cogenerations1655915co_gene_rations
concatenations1873725concate_nations
concelebrant1862395concelebra___nt
concelebrants1961775concelebra__nts
concelebrate18103595concelebrat___e
concelebrated2093055concelebrat__ed
concentration1758015conce_ntration_
conciliations1747205concil__iations
confederation1995255confede_ration_
conflagrations2052725con_flagrations
congelations1549735congel___ations
conglobations1853945con_glob_ations
consecrations1749215con__secrations
considerations1764845conside_rations
deceleration1547175_decele_ration_
decerebration1884195_decerebration_
enculturations1652425_enculturations
incinerations1545685_incine_rations
intenerations1347465_intene_rations
noncelebrity1962155noncelebr__i_ty
noncooperation1863705noncooperation_
noncorrelations17122825noncorrelations
noncultivation19183065noncultivation_
nonelection1347205non_ele__ction_
nonlibrarians1561955non__librarians
nonsegregations17162695nonsegregations
novelizations2556365no_vel_izations
nucleations1345315n_uc_le__ations
recalibrations1853695_recalibrations
tolerations1158135to___le_rations
vociferations2153115vo_cife_rations
accelerating1753736_accele_rati_ng
accelerators1682946_accele_rat_ors
acculturations18182906_acculturations
ameliorations1563196__ameliorations
asseverations1652596_asseve_rations
botherations1754196bo__the_rations
calibration1545996___calibration_
cancelation1547776cancel___ation_
cancellation1655016cancel__lation_
celebrates1447676___celebrat__es
celebrator1444976___celebrat_o_r
celebratory1853306___celebrat_ory
celebrities15134446___celebriti_es
cementations1659016___cementations
cerebrating1646666___cerebrati_ng
coacervations2053876coac__ervations
cocultivations2152766co_cultivations
cogeneration1546446co_gene_ration_
collaborations1872746co__llaborations
colorations13911896___col_orations
commemorations1953446comme_morations
commensurations21182586commensurations
commiserations2053456commise_rations
compellations1954816compel__lations
complexations26134016co_mple_xations
concatenation1764096concate_nation_
concentrating1856436conce_ntrati_ng
concentrators1754996conce_ntrat_ors
conceptions17410596conc__e__ptions
concertinos15158126conc__e_r_tinos
conciliation1648236concil__iation_
concretions1549296conc____retions
concretizations2854036concretizations
condemnations1845406con__demnations
condensations1646276con__densations
confederating2054016confede_rati_ng
configurations2063706con_figurations
conflagration1953016con_flagration_
conflations16411146con_fl___ations
congelation14410346congel___ation_
conglobation1754256con_glob_ation_
conglomerations2062736conglomerations
congregations17186416con_gre_gations
conjurations2148496con___jurations
consecration1649786con__secration_
conservations1849096con__servations
consideration1655526conside_ration_
consolations1449746consol___ations
consolidations1754746consol_idations
conspirations1747726con__spirations
constellations1654406con_stellations
consternations16116046con_sternations
consultations1546936consul__tations
contemplations2074736conte_mplations
contestations1547736con__testations
conurbations1646666con__urb_ations
conversations1847456con__versations
cooperations1659196co__ope_rations
correlations1447866correl___ations
deaerations12311676___deae_rations
decelerating1645596_decele_rati_ng
decelerators1553496_decele_rat_ors
decerebrating1953206_decerebrati_ng
declarations1546806_dec_l_arations
degenerations1546356_degene_rations
delectations1547456___delectations
delegations1348036___dele_gations
deliberations1645536___deliberations
desecrations1559216___desecrations
discolorations17104306discol_orations
documentations19144486do_cumentations
elaborations1444926____elaborations
elevations1338636____ele_vations
elucubrations1751746eluc__ubrations
enculturation1552786_enculturation_
enucleations1444106_enucle__ations
enumerations14135516_en_ume_rations
equilibrations2561976_equilibrations
exacerbations2452506exace_rb_ations
execrations2048926____execrations
exonerations1947016exon___e_rations
federations1548886___fede_rations
fenestrations1695406fen_e_strations
focalizations2748996fo_cal_izations
generations12311426___gene_rations
incarcerations1853006_incarcerations
incineration1446296_incine_ration_
inclinations1448756_inc_l_inations
incorporations18134856_incorporations
incubations1547306_inc__ub_ations
inculcations1666316_incul__cations
inculpations1675966_incul__pations
inebriations1456326_in___ebriations
infiltrations1653906_infil_trations
inoculations1457686ino_cul___ations
inosculations1554426inoscul___ations
integrations13129476_in__tegrations
inteneration1248626_intene_ration_
lacerations1348336_lac__e_rations
librations12149066_____librations
localizations2449796lo_cal_izations
lucubrations1652546_luc__ubrations
macerations1548476_mac__e_rations
meliorations1466756___meliorations
miscegenations1963026miscege_nations
moderations1448276mo___de_rations
molestations1475476mo___lestations
monetizations2467646mon_e_tizations
mongrelizations2753706mongrel_izations
necessitations16122796n_ecessitations
nodulations12147006no_dul___ations
nonconnections1894146nonc_onnections
nonconservation2063096nonconservation_
nonconsumptions2182276nonconsumptions
noncooperators1862426noncooperat_ors
noncorrelation16113086noncorrelation_
nondelegates1452866nondele_gat__es
nondepositions17112556nonde_positions
noneducation1554356non_e_ducation_
nonimplications21122886nonimplications
nonimportations1962106nonimportations
noninformations2073136noninformations
nonlibrarian1462386non__librarian_
nonoperating1555416non_ope_rati_ng
nonoperational1663776non_ope_rational
nonrecognitions1871226nonrecognitions
nonregulation1473906nonre_gulation_
nonrelatives1564206nonrel___atives
nonsegregation16132806nonsegregation_
nonsolutions1254176nonsol___utions
nonvegetarians18151616nonvege_tarians
nonveterans1453376nonvete_ra___ns
normalizations25147546normal_izations
novelization2456956no_vel_ization_
nucleation1245966n_uc_le__ation_
numerations13127296__n_ume_rations
obliterations1553456_oblite_rations
occultations1644376_occul__tations
operations12312956_o___pe_rations
orchestrations19113306_orchestrations
oscillations1445126_oscil__lations
osculations1348376_oscul___ations
penetrations1448856___penetrations
perseverations1953246perseve_rations
prelibations16127626__prelib_ations
recalibration1754436_recalibration_
recuperations1746086_recupe_rations
regenerations1447146_regene_rations
relegations1248976___rele_gations
reverberations19113586_reverberations
subgenerations1752516subgene_rations
toleration1048966to___le_ration_
ulcerations1346366_ulc__e_rations
uncelebrated1753396_uncelebrat__ed
venerations14411316___vene_rations
vocalizations2749276vo_cal_izations
vociferation2053186vo_cife_ration_

Search took 8 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 Limit950242136.95013672.5
3Display Results2132130.1601331.3
 (SQL Overall)1786912137.47023921.2
 
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.