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

157 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
scintillations166275(None) 
scintillation1593001scintillation_
cantillations1545732_cantillations
scintillating1662192scintillati_ng
scintillators1562012scintillat_ors
cantillation1446693_cantillation_
distillations1446943_distillations
instillations1344923__instillations
scintillates1482883scintillat__es
scintillator1462103scintillat_o_r
titillations1244443_ti_tillations
cancellations1754394_cancellations
cantillating1565044_cantillati_ng
centillions1353974_centill__ions
conciliations1747204_conciliations
constellations1654404_constellations
continuations1547144_continuations
distillation1347734_distillation_
fibrillations1853104_fibrillations
installations1354224__installations
instillation1245844__instillation_
intimations13411884__inti_mations
oscillations1445114osc___illations
quintillions2152314quintill__ions
redistillations1672914redistillations
reinstallations1562154reinstallations
sanitizations2248554saniti_zations
scintillant1352954scintilla___nt
scintillas1263364scintilla____s
scintillate1363094scintillat___e
scintillated1562424scintillat__ed
sibilations13127934s_i_bi_lations
titillation1145044_ti_tillation_
ventilations1547404_venti_lations
acetylations1743545ac_et_ylations
acidulations15104815aci__dulations
activations1669265ac__ti_vations
annihilations1653995annihi_lations
antiquations2146245__antiquations
assimilations1555205assi_mi_lations
canalizations24410435_canalizations
cancelations1657095_can_celations
cancellation1655015_cancellation_
cantillates1346635_cantillat__es
capitulations1754065_capitulations
captivations1945345_capti_vations
castigations1547205_casti_gations
centillion1254465_centill__ion_
ciliations121111005_c___iliations
circulations1648485_ci_rculations
citations11312505_ci_t___ations
citifications2048545_ci_tifications
civilisations1853645_ci_vilisations
civilizations2747275_ci_vilizations
collations12312855_c___ollations
compellations1954815_compellations
compilations1848685_compi_lations
conciliation1648235_conciliation_
confirmations2055675_confirmations
confiscations2044955_confiscations
conflations16411145_con__flations
congelations1549735_con_gelations
consignations16105935_consignations
consolations1449745_con_solations
constellation1554795_constellation_
constipations1747685_consti_pations
consultations1546935_consultations
contemplations2074735_contemplations
contestations1547735_contestations
continuation1448195_continuation_
cotillions1244785_c_otill__ions
crenellations1553575_crenellations
cultivations1745595_culti_vations
cupellations1643805_c_upellations
defibrillations2161695defibrillations
denticulations1753915_denticulations
etiolations1147395___etiolations
fibrillation1753525_fibrillation_
finalizations2549255_finalizations
illations9311395_____illations
incitations13310885__inci_tations
inclinations1448755__inclinations
inculcations1666315__inculcations
inculpations1675965__inculpations
indications14310975__indi_cations
indignations1446045__indignations
infiltrations1653905__infiltrations
infixations2146695__infi_xations
inflations13310325__in__flations
inhalations14126745__in_halations
initiations11410725__in_itiations
inoculations1457685__inoculations
insinuations12136425__insinuations
insolations1149185__in_solations
installation1254905__installation_
instigations1348245__insti_gations
insulations11310235__in_sulations
integrations13129475__integrations
intellections1565395__intellections
intimation12413045__inti_mation_
intimidations1686665__intimidations
intinctions1347005__inti_nctions
intonations1149525__int_onations
intubations1346835__int_ubations
invigilations1764485__invigilations
invitations1449055__invi_tations
laciniations1445915lacin_i__ations
litigations1247335_li_ti_gations
mitigations1447625_mi_ti_gations
mutilations1348645__muti_lations
octillions1243615oc__till__ions
oscillation1345495osc___illation_
pixilations2045335_pi_xi_lations
quantitations2263365quanti_tations
quantizations3164575quanti_zations
quintillion2052655quintill__ion_
reconciliations1953745reconciliations
redistillation1563035redistillation_
reinflations1546645rein__flations
reinoculations1653925reinoculations
reinstallation1462435reinstallation_
reintegrations15164785reintegrations
salinizations2258425salin_i_zations
sanitations11410845s_an_i_tations
sanitization2149155saniti_zation_
satiations10312115s__ati__ations
scalations1239785sc____alations
scatterations1552545sc_atterations
scintilla1153755scintilla_____
scintillae1272815scintilla____e
scintillantly18101405scintilla_ntly
septillions1352725s_eptill__ions
sextillions1852355s_extill__ions
sibilation12128775s_i_bi_lation_
signalizations2456735signalizations
siltations1038555s____iltations
simulations1368395s_i__mulations
sinuations1039415s_in___uations
situations1038435s_i_t__uations
socializations2548485sociali_zations
sonications1349955s_on_i_cations
sovietizations2664435sovieti_zations
spallations1356105s___pallations
spiculations1646175spi__culations
stimulations1456205sti__mulations
stipulations1455445sti__pulations
strobilations1553885strobi_lations
subtilizations2556065s_ubtilizations
syndications18104475s_yndi_cations
titillating1243705_ti_tillati_ng
titivations1446265_ti_ti_vations
unitizations2147455uni_ti_zations
vacillations1744875__vacillations
ventilation1448165_venti_lation_
vigintillions1771065vigintill__ions
vindications1845685_vindi_cations
vitiations1338745_vi_ti__ations

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.343520965.0
2DLD Change Limit950241576.67314240.1
3Display Results1571570.1101427.3
 (SQL Overall)1786911577.12625075.9
 
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.