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

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

129 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
photogeological246310(None) 
photobiological2564452photobiological
photogeologic2263732photogeologic__
photogeologies2163893photogeologi_es
photogeologist21134673photogeologi_st
photogeologists22173643photogeologists
phonological2058374ph__o_nological
photobiologic2365204photobiologic__
photogeology2263304photogeolog___y
phraseological2283694ph_raseological
chronological2175955ch_ro_nological
cohomological2354085_coho_mological
entomological1855035_ento_mological
geological1448075_____geological
hagiological1955815_h__agiological
homological1948445_h__o_mological
horological1748285_h__o_rological
nonideological1862525_nonideological
nontheological2063215_nontheological
osteological1546375__o_steological
paleobiological2264735paleobiological
paleoecological2263555paleoecological
paleontological2063845paleontological
paleozoological2963265paleozoological
pathological2047985p_at__hological
petrological1758595p_et__rological
pharmacological2793545pharmacological
phenological2068055ph___enological
philological2046375ph___ilological
photobiologies2265155photobiologi_es
photobiologist2266225photobiologi_st
photobiologists2365175photobiologists
photomechanical2971895photomechanical
phrenological2156335ph__renological
phycological2546945ph___ycological
physiological2455575ph__ysiological
pomological1848035p___o_mological
praxeological2554435p__raxeological
proctological2055825p__roctological
rheological17127475rh____eological
soteriological1763895_soteriological
stereological1655675__stereological
teleological1546575___teleological
theological1798265___t_heological
topological1647435___to_pological
aerobiological1955136_aerobiological
algological1545976___alg_ological
anthological1847516_ant__hological
archaeological22152936_archaeological
astrological1547026_ast__rological
autecological1854436_aut_ecological
bacteriological2282866bacteriological
codicological1853896_co_dicological
cosmological1946086___cosmological
cryobiological2463926_cryobiological
cytological1947456_cyt___ological
demonological1954966_demo_nological
deontological1755176__deontological
epistemological22101946epist_emological
ethnological1846816__et_hnological
ethological1748196__et__hological
etiological1448416__et__iological
etymological2045876__et_ymological
exobiological2554726__exobiological
futurological1952986_fut_urological
gemological1747026_____gemological
gerontological1854176_gerontological
hematological2155946_h_ematological
herpetological2253326_herpetological
histological1846086_h__istological
hydrobiological2763586hydrobiological
hydrological2246486_h__ydrological
ichthyological2882456icht_hyological
iconological1756026__ico_nological
ideological15106646____ideological
lithological1845896_lit__hological
meteorological1953786_meteorological
methodological2353306_methodological
metrological1748376_met__rological
microbiological2464376microbiological
morphological2353966_mo_rphological
museological1754786___museological
mythological2346906_myt__hological
neurobiological20123926neurobiological
nomological1648076___no_mological
nonbiological1855266_no_nbiological
nosological1447376___no_sological
oncological1647256____oncological
ontological1448316____ontological
oological1248326____o__ological
orismological1853626__orismological
palynological2154676p__alynological
parasitological2062776parasitological
pedological1757616p____edological
penological1648876p____enological
phonologic1857946ph__o_nologic__
phonologically2555556ph__o_nologically
photobiology2384016photobiolog___y
photochemical27124986photo__chemical
photogenic1848296photoge___nic__
photogenically2564816photoge___nically
photoperiodic2362906photoperiodic__
photovoltaic2263086photo_voltaic__
photovoltaics2362626photo_voltaic_s
planetological1953176p_lanetological
prebiological2055976p__rebiological
prelogical1546696p____re_logical
primatological2183216p_rimatological
protozoologies2663166protozoologi_es
protozoologist2663886protozoologi_st
protozoologists2763036protozoologists
psephological2354986p__sephological
psychological2656596p__sychological
pteridological2053596p_teridological
radiobiological2163346radiobiological
scatological1745546scat___ological
sociobiological2273516sociobiological
sociological1747506___sociological
somatological1854886_so_matological
speleological1853916__speleological
tautological1555486___tautological
thanatological2062506th_anatological
toxicological2553986_to_xicological
tribological1745986___tribological
tropological1746636___tropological
typological1946686___t_ypological
unideological1763336__unideological
volcanological2262226_volcanological
zoological2246446___zo__ological

Search took 8 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.343520965.0
2DLD Change Limit950241296.75014077.6
3Display Results1291290.0961343.8
 (SQL Overall)1786911297.18924856.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.