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

60 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
embryologically2892351embryologically_
embryological2353183embryologica_l__
embryonically2552484embry__onically_
astrologically2055435astr_ologically_
biologically2067055__b_iologically_
bryological1945375__bryologica_l__
ecologically2067725e___cologically_
entomologically2363205entomologically_
etiologically1955995e__tiologically_
etymologically2564125e_tymologically_
hydrologically27104505hydr_ologically_
immunologically2562925immunologically_
morphologically2862905_morphologically_
mycologically2655435_m_ycologically_
mythologically28154955_mythologically_
neurologically2074965neur_ologically_
petrologically2256065petr_ologically_
semiologically2254995sem__iologically_
serologically1957125_ser_ologically_
stereologically2163515stereologically_
virologically2255165_vir_ologically_
axiologically2655276__axiologically_
chronologically2663546chronologically_
cosmologically2454076_cosmologically_
cytologically2455926__cytologically_
embryologies2053166embryologi____es
embryologist2053886embryologi____st
embryologists2153126embryologi___sts
embryology2152806embryolog_____y_
ergonomically2153996e__rgonomically_
geologically1947366___geologically_
histologically2364316_histologically_
homologically2456136__homologically_
ideologically2055036__ideologically_
karyological2274736_karyologica_l__
lithologically2364066_lithologically_
metrological1748376metr_ologica_l__
metronomically2354556metr_onomically_
nonbiologically2383066nonbiologically_
nosologically1955136__nosologically_
ontologically1956126__ontologically_
palynologically26123196palynologically_
pathologically2585556_pathologically_
phenologically2555366_phenologically_
philologically2564306_philologically_
phonologically2555556_phonologically_
physiologically2993606physiologically_
psychologically3194236psychologically_
radiologically2174546_radiologically_
rheologically2255276__rheologically_
sociologically2254756_sociologically_
tautologically2094176_tautologically_
technologically2683266technologically_
teleologically2054706_teleologically_
theologically2256146__theologically_
topologically2165396__topologically_
toxicologically3062556toxicologically_
tropologically2264186_tropologically_
typologically2465166__typologically_
zoologically2755646___zoologically_

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.343520965.0
2DLD Change Limit65874604.61014289.4
3Display Results60600.063952.4
 (SQL Overall)178691605.01635624.2
 
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.