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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
geologically194733(None) 
biologically2067042biologically
ecologically2067712ecologically
geological1448052geologica_l_
ideologically2055032ideologically
rheologically2255262rheologically
serologically1957092serologically
theologically2256122theologically
zoologically2755642zoologically
alogically1648773__alogically
analogically18126273analogically
axiologically2655253axiologically
cytologically2455903cytologically
dialogically1975823dialogically
etiologically1955963etiologically
gemological1747013gemologica_l_
genealogically2163113genealogically
geotropically2154893geotropically
homologically2456103homologically
illogically1746373_illogically
logically1548963___logically
melodically1946623me_lodically
mycologically2655423mycologically
neurologically2074943neurologically
nosologically1955123nosologically
ontologically1956103ontologically
petrologically2256013petrologically
phenologically2555343phenologically
semiologically2254983semiologically
teleologically2054683teleologically
topologically2165363topologically
typologically2465153typologically
virologically2255153virologically
aerobically1848084ae_robically
agronomically2184654agronomically
anagogically19114524anagogically
apolitically1948014apolitically
apologetically2254144apologetically
astrologically2055374astrologically
biological15128864biologica_l_
biologicals16105004biologica_ls
calorically1847754_calorically
cholerically2256154cholerically
colonially1546684_coloni_ally
cosmologically2454054cosmologically
cyclonically2164984cyclonically
delphically2254754de_lphically
demagogically2352834demagogically
demonically1947834de_monically
despotically2075884despotically
ecological1548704ecologica_l_
economically2156764economically
ectopically2047114_ectopically
egoistically1867374egoistically
elegiacally1752264_e_legiacally
enological1348884enologica_l_
erotically15414294_e_rotically
etymologically2564114etymologically
exotically2249474_e_xotically
generically1747384ge_nerically
genetically1759194ge_netically
genically151110174ge___nically
genotypically2452874genotypically
geochemically2654834geochemically
geologic1247794geologic____
geometrically2155494geometrically
geophysically2763214geophysically
geopolitically22113604geopolitically
georgical1344024geo_rgica_l_
gothically1946694g_o_thically
hedonically2046874he_donically
helically1749434he_l__ically
heroically18410614he_ro_ically
histologically2364294histologically
hydrologically27104494hydrologically
ideological15106634ideologica_l_
isotonically1756034isotonically
isotopically1955344isotopically
lithologically2364044lithologically
meiotically1849754me_iotically
meteorically1956804meteorically
methodically2356144methodically
monodically1946774_monodically
moronically1849074_moronically
motorically1849414_motorically
mythologically28154934mythologically
neurotically1747714neurotically
oological1248304_oologica_l_
pathologically2585504pathologically
pedagogically2353164pedagogically
pedological1757594pedologica_l_
penological1648854penologica_l_
periodically2047574periodically
philologically2564284philologically
phonologically2555514phonologically
polemically2047634_polemically
politically18411464_politically
prolifically2255474prolifically
prosodically2056574prosodically
radiologically2174534radiologically
rheological17127444rheologica_l_
robotically1868494_robotically
serological1468774serologica_l_
sociologically2254744sociologically
stereologically2163484stereologically
tautologically2094144tautologically
technologically2683254technologically
tectonically1946304tectonically
telically1449854te_l__ically
theological1798234theologica_l_
tropologically2264184tropologically
ufological1644904ufologica_l_
urological1347754urologica_l_
zoological2246424zoologica_l_

Search took 9 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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901148.01615567.6
3Display Results1141140.0631809.5
 (SQL Overall)1786911148.21921741.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.