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 “ionospherically” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
ionospherically258190(None) 
atmospherically2791513atmospherically
ionospheric1853474ionospheric____
monophonically2663404mono_phonically
nonspherical1963594non_spherica_l_
spherically2146934____spherically
allosterically1962735allos_terically
anaphorically2353915_an_aphorically
anesthetically2254265_anesthetically
isomorphically2662725isomorph__ically
kinesthetically2761905kinesthetically
microspherical2582445microspherica_l_
monogenically2154715mono__genically
morphemically2753805__morphemically
prophetically2577455_pro_phetically
prosthetically2454605_prosthetically
xenophobically3362195xeno_phobically
aesthetically2156436__aesthetically
allopatrically2173286allo_patrically
antithetically2264496_antithetically
aphetically2159246____aphetically
aspherical1754456___aspherica_l_
biochemically2754376_bio_chemically
biographically2764396biograph__ically
bolometrically2363666bolo_metrically
cholerically2256156_cho__lerically
concentrically2063756con_centrically
cosmetically2147916__cos_metically
econometrically24133346econo_metrically
esoterically17126106___esoterically
euphorically2254606___euphorically
exoterically24135756_exo__terically
exothermically3172396_exo_thermically
generically1747386gen____erically
geochemically2654836_geo_chemically
geophysically2763216_geo_physically
graphemically2653746__graphemically
hemispherical2561636hemispherica_l_
histochemically3092976histo_chemically
honorifically2453766hono__rifically
hypothetically3064386hypo_thetically
hysterically2354896__hys_terically
idiopathically2592956idio_pathically
imperially1746846i___mp_eri_ally
inorganically1954356i_no_rganically
ionosphere1553966ionospher_____e
ionospheres1654016ionospher____es
isometrically2054956i_so_metrically
isosmotically2053936i_sos_motically
isostatically1854986i_sos_tatically
isothermally2061546i_so_ther_mally
isotopically1955346isoto_p___ically
manometrically2354016mano_metrically
mesmerically2154816__mes_merically
metaphorically2673276_metaphorically
microphysically32132496micro_physically
ministerially1862176minis_teri_ally
monarchically2553526monarch__ically
monastically1948336monas___tically
monodically1946776mono____dically
monolithically2462796mono_lithically
monopodially2062116mono_p_odi_ally
monotonically2055306mono__tonically
motorically1849416moto____rically
nonsensically1853156non_s_ensically
nonspecifically2771246non_specifically
nosologically1955126__nosologically
nostalgically1962536__nostalgically
numerically1845896__n__umerically
obstetrically2053056_o_bstetrically
oneirically1646256_on___eirically
onomastically20116496_ono_mastically
ontogenetically2162636_ontogenetically
orphically2047616___orph__ically
photochemically3264086photo_chemically
polyphonically2962166po_lyphonically
spherical1645806____spherica_l_
spheroidally2171886____spheroidally
sterically15410466____s_terically
synoptically2256146syno_p__tically
synthetically2455036syn__thetically
theosophically2763146theosoph__ically
tonetically16410796ton____etically
trophically2147526_tro_ph__ically
unemphatically2673056_unemphatically
unhysterically2562056_unhysterically

Search took 7 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.1261418182.5
2DLD Change Limit95024866.57614450.1
3Display Results86860.0631365.1
 (SQL Overall)178691866.76526414.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.