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

77 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
palynologically26123191palynologically_
palynological2154673palynologica_l__
pathologically2585554pa_thologically_
phenologically2555364p_henologically_
phonologically2555554p_honologically_
analogically18126285_a__nalogically_
astrologically2055435_astrologically_
axiologically2655275_a_xiologically_
chronologically2663545chronologically_
cytologically2455925__cytologically_
etymologically2564125_etymologically_
immunologically2562925immunologically_
mycologically2655435__mycologically_
palynologic1953665palynologic_____
petrologically2256065p_etrologically_
philologically2564305p_hilologically_
physiologically2993605physiologically_
psychologically3194235psychologically_
radiologically2174545ra_diologically_
tautologically2094175ta_utologically_
technologically2683265technologically_
teleologically2054705tel_eologically_
typologically2465165__typologically_
alcoholically2353456_al_coholically_
algological1545976_al_gologica_l__
alogically1648796_a____logically_
anagogically19114546_a__nagogically_
biologically2067056___biologically_
cosmologically2454076_cosmologically_
ecologically2067726___ecologically_
embryologically2892356embryologically_
entomologically2363206entomologically_
etiologically1955996__etiologically_
geologically1947366___geologically_
histologically2364316_histologically_
homologically2456136__homologically_
hydrologically27104506_hydrologically_
ideologically2055036__ideologically_
illogically1746386_il___logically_
karyological2274736kary_ologica_l__
lithologically2364066_lithologically_
malacological2053976malacologica_l__
morphologically2862906morphologically_
mythologically28154956_mythologically_
neurologically2074966_neurologically_
nonbiologically2383066nonbiologically_
nosologically1955136__nosologically_
ontologically1956126__ontologically_
paleontological2063846paleontologica_l__
palynologies1844876palynologi____es
palynologist1856306palynologi____st
palynologists1954996palynologi___sts
palynology1943666palynolog_____y_
panoramically2274606pa__noramically_
parabolically2254006parabol__ically_
paranoically1956556paran__o_ically_
pathological2047986pa_thologica_l__
penological1648876p__enologica_l__
phenological2068056p_henologica_l__
phonological2058376p_honologica_l__
phrenological2156336phrenologica_l__
phycological2546946p_hycologica_l__
polymorphically3271606polymorphically_
polyphonically2962166poly_phonically_
pyrolytically2256096p__yrolytically_
rheologically2255276__rheologically_
selenological1654666selenologica_l__
semiologically2254996_semiologically_
serologically1957126__serologically_
sociologically2254756_sociologically_
stereologically2163516stereologically_
theologically2256146__theologically_
topologically2165396__topologically_
toxicologically3062556toxicologically_
tropologically2264186_tropologically_
virologically2255166__virologically_
zoologically2755646___zoologically_

Search took 5 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.326548131.9
2DLD Change Limit65874774.14015911.6
3Display Results77770.0631222.2
 (SQL Overall)178691774.52939454.8
 
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.