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

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

88 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
biomechanically2971861biomechanically_
biomechanical2462333biomechanica_l__
mechanically2455594___mechanically_
biochemically2754385bio__chemically_
biomechanics2372135biomechanic____s
biotechnical2162865biotech_nica_l__
abiogenically2163846abioge___nically_
biogenetically2263476bioge_netically_
botanically1847016b_o___tanically_
geotectonically23111606geotectonically_
immethodically2791816_immethodically_
mechanical19115736___mechanica_l__
mechanicals2093756___mechanica_l_s
nonmechanical2273026nonmechanica_l__
pyrotechnically3072166pyrotech_nically_
technically2146446___tech_nically_
volcanically2253346_vo_lc_anically_
apomictically2464367apomic__tically_
aposematically2363807apose_matically_
archaically2145827___archa_ically_
aromatically19410667arom___atically_
axiomatically2756097axiom___atically_
barometrically2353927barome__trically_
biennially1553527bi__e__nni_ally_
bimanually1752287bi_m___an_ually_
biochemical2254357bio__chemica_l__
biochemicals2363227bio__chemica_l_s
bioethical1753747bio_eth__ica_l__
biogeochemical2672227biogeochemica_l__
biogeochemicals2781807biogeochemica_l_s
biographically2764417bio_graphically_
biologically2067057bio___logically_
biomedical1753817biome___dica_l__
biometrical1755487biome__trica_l__
biosocially1852747biosoc___i_ally_
bolometrically2363677bolome__trically_
bombastically2453537b_om_bastically_
bronchially2152507bro_nch__i_ally_
cephalically2453877___cephalically_
cinematically2265757ci_ne_matically_
comedically2156997_come___dically_
democratically2454067_democratically_
diachronically2562217di__achronically_
dialectically2164177dialec__tically_
diametrically2154517diame__trically_
dichotically2356227di___chotically_
domestically2057597_dome__stically_
ecumenically2154397ecume___nically_
egomaniacally2161637egom___aniacally_
emphatically2456437__em_phatically_
ethnically1847837____eth_nically_
geochemically2654847geo__chemically_
geometrically2155517geome__trically_
geotechnical2082387geotech_nica_l__
hieratically2048177hi__e_ratically_
histochemically3092987histochemically_
homeopathically3072197_homeopathically_
hydromechanical3181617hydromechanica_l__
iconically1769277_i___c_onically_
idiomatically2155557idiom___atically_
inorganically1954367_i_norganically_
irenically15710317_i_re___nically_
isometrically2054967isome__trically_
kinematically2454727ki_ne_matically_
lymphatically2853917_lym_phatically_
manically16311707___m___anically_
mechanistically2782767___mechanistically_
mechanizable3062377___mechanizabl_e
methodically2356157___methodically_
mimetically2048307mi_me___tically_
monophonically2663417_monophonically_
operatically1949327__ope_ratically_
organically1746347__o__rganically_
photochemically3264097photochemically_
photomechanical2971897photomechanica_l__
polyphonically2962167_polyphonically_
postcranially2061717_postcrani_ally_
romantically1948017_rom___antically_
somatically18411157_som___atically_
stochastically2463817sto__chastically_
symphonically2854137_sym_phonically_
tectonically1946327___tectonically_
telephonically2462467_telephonically_
tetanically1648067___te_tanically_
titanically1646577ti____tanically_
unemphatically2673057unem_phatically_
vocalically2144807_vo__c_alically_
zootechnical2861957zootech_nica_l__

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.470380193.6
2DLD Change Limit95024889.09310450.2
3Display Results88880.0631396.8
 (SQL Overall)178691889.62618563.4
 
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.