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

73 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
nonbiologically2383041nonbiologically_
nonbiological1855213nonbiologica_l__
biologically2067044___biologically_
nosologically1955124no__sologically_
ontologically1956114_on_tologically_
sociologically2254744so_ciologically_
axiologically2655255__axiologically_
cosmologically2454065co_smologically_
etiologically1955975__etiologically_
homologically2456115ho__mologically_
morphologically2862905morphologically_
neurologically2074955n_eurologically_
nonpolitically2163655non_politically_
phonologically2555525phon__ologically_
physiologically2993575physiologically_
radiologically2174535_radiologically_
semiologically2254995_semiologically_
topologically2165375to__pologically_
toxicologically3062545toxicologically_
zoologically2755645zo___ologically_
abiological1647816__abiologica_l__
analogically18126286_an__alogically_
astrologically2055386_astrologically_
biological15128866___biologica_l__
biologicals16105006___biologica_l_s
chronologically2663526chronologically_
cytologically2455916__cytologically_
dialogically1975836___dialogically_
ecologically2067726___ecologically_
embryologically2892356embryologically_
entomologically2363186entomologically_
etymologically2564126_etymologically_
exobiological2554686exobiologica_l__
genealogically2163126gen_ealogically_
geologically1947346___geologically_
histologically2364296_histologically_
hydrologically27104496_hydrologically_
ideologically2055036__ideologically_
illogically1746376____illogically_
immunologically2562926immunologically_
lithologically2364056_lithologically_
mineralogically2372376mineralogically_
monotonically2055316mon__otonically_
mycologically2655436__mycologically_
mythologically28154946_mythologically_
nomological1648056no__mologica_l__
nonbiologist1555916nonbiologi____st
nonbiologists1664716nonbiologi___sts
nonideological1862496nonideologica_l__
nonlogical1347056non___logica_l__
nontheological2063186nontheologica_l__
nosological1447346no__sologica_l__
nostalgically1962536no_stal_gically_
oncological1647236_on_cologica_l__
ontological1448286_on_tologica_l__
palynologically26123186palynologically_
pathologically2585516_pathologically_
petrologically2256026_petrologically_
phenologically2555346_phenologically_
philologically2564286_philologically_
prebiological2055936prebiologica_l__
psychologically3194236psychologically_
rheologically2255266__rheologically_
serologically1957106__serologically_
sociological1747476so_ciologica_l__
stereologically2163496stereologically_
tautologically2094156_tautologically_
technologically2683266technologically_
teleologically2054696_teleologically_
theologically2256136__theologically_
tropologically2264186_tropologically_
typologically2465166__typologically_
virologically2255156__virologically_

Search took 6 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 Filter178691658740.0961861364.6
2DLD Change Limit65874735.25012547.4
3Display Results73730.0601216.7
 (SQL Overall)178691735.40633054.2
 
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.