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

108 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
diastrophically2672731diastrophically_
geostrophically2672554geostrophically_
astrophysically2882815__astrophysically_
autotrophically2562815autotrophically_
diachronically2562215diachro_nically_
diastrophic1953595diastrophic_____
diatonically1856025dia_t_o_nically_
digraphically2564275di__graphically_
trophically2147555____trophically_
anisotropically2292316anisotrop_ically_
apotropaically2362986_apotropaically_
astrologically2055436__astrologically_
astronomically2163906__astronomically_
biographically2764416bi_ographically_
demographically2963886demographically_
diabolically2053756dia__bo_lically_
diagnostically2162666dia_gnostically_
dialogically1975836dia__lo_gically_
diametrically2154516diametr___ically_
diastrophism2062636diastrophi____sm
diastrophisms2162326diastrophi___sms
drastically1748946drast____ically_
entropically1977826__entrop_ically_
gastronomically2362276_gastronomically_
geotropically2154926_geotrop_ically_
historically2056466hi_st_o_rically_
histrionically2262526hi_strionically_
iatrogenically20103446_ia_trogenically_
ideographically27113716ideographically_
isentropically2162696isentrop_ically_
isomorphically2662746_i_somorphically_
isotopically1955376_i_sotop_ically_
seraphically2256536___seraphically_
tropically1749846____trop_ically_
acrostically1968397__a_crostically_
aerobically1848117__a_ero_bically_
anaerobically2053377ana_ero_bically_
anarchically2254167__anar_chically_
anatomically1956177ana_t_o_mically_
animatronically2261747animatro_nically_
aseptically1847417__as__eptically_
asthmatically2355647__asthmatically_
astronautically2092647__astronautically_
astrophysical2392667__astrophysica_l__
atomically1749877__a_t_o_mically_
atypically2045747__a_t_yp_ically_
autographically2663807autographically_
cathodically2355417_ca_tho_dically_
catholically2256007_ca_tho_lically_
cationically1956847_ca_tio_nically_
deistically1749047deist____ically_
delphically2254767d____elphically_
despotically2075897d_es_po_tically_
diagenetically2172937dia_genetically_
dialectically2164177dia__lectically_
diatropic1445927dia_trop_ic_____
dichotically2356227di__cho_tically_
didactically2154417didact____ically_
dietetically1856667di_et__etically_
dithyrambically319907dithyrambically_
diuretically18155707di__ur_etically_
dynastically2155727dynast____ically_
dyspeptically2662847d_ys_peptically_
dystrophic2154207d_ystrophic_____
ectopically2047127__ect_op_ically_
edaphically2254937eda____phically_
elastically1649617elast____ically_
electronically2163837electro_nically_
epigraphically2763277_epigraphically_
estrogenically2093247__estrogenically_
geographically2664587_geographically_
graphically2256227____graphically_
hierarchically2762217hierar_chically_
histochemically3092987hi_st_ochemically_
histologically2364317hi_stologically_
holographically2973967holographically_
intrathecally2163197_i_ntrathecally_
intrinsically1854297_i_ntrinsically_
ironically151110547_i___ro_nically_
isotonically1756057_i_soto_nically_
logographically2773477logographically_
megascopically2661847megas_cop_ically_
metamorphically2972037metamor_phically_
miasmically2045057mias____mically_
microphysically32132507mi__crophysically_
mitotically1849127mi__t_o_tically_
oratorically1756377ora_t_o_rically_
orphically2047637____or_phically_
osteopathically2562297__osteopathically_
pantropical1764367_pantrop_ica_l__
parochially2153187_pa__rochi_ally_
patriotically2057017_pa_triotically_
philosophically3072357philosophically_
phototropically2763377phototrop_ically_
plastically1849407plast____ically_
platonically1945907pla_t_o_nically_
polymorphically3271607polymorphically_
saprophytically3062237_sa_prophytically_
spasmodically2351977spas_mo_dically_
spastically1848737spast____ically_
stoically1449677___st_o__ically_
synoptically2256167___synoptically_
telegraphically2673297telegraphically_
theosophically2763167_theosophically_
topically1649537____t_op_ically_
topographically28143697topographically_
typographically31133727typographically_
xerographically3363647xerographically_

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.343520965.0
2DLD Change Limit950241088.68610939.9
3Display Results1081080.0801350.0
 (SQL Overall)1786911089.10919617.0
 
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.