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

153 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
photogeologists2217364(None) 
photogeologist21134671photogeologist_
photobiologists2365172photobiologists
photogeologies2163892photogeologi_es
photobiologist2266223photobiologist_
photogeologic2263733photogeologi__c
photogeological2463103photogeological
protozoologists2763033protozoologists
phonologists1848774ph__o_nologists
photobiologies2265154photobiologi_es
photogeology2263304photogeolog___y
phraseologists2053574ph_raseologists
protozoologist2663884protozoologist_
chronologists1966115ch_ro_nologists
entomologists1655665_ento_mologists
geologists1279165_____geologists
horologists1548965_h__o_rologists
osteologists1346765__o_steologists
otologists1149635__ot___ologists
paleobiologists20115735paleobiologists
paleoecologists20124175paleoecologists
paleontologists1884525paleontologists
paleozoologists2763855paleozoologists
pathologists1848375p_at__hologists
petrologists1559145p_et__rologists
pharmacologists2573645pharmacologists
phenomenologist2382685phenomenologist_
philologists1876685ph___ilologists
phonologist17411565ph__o_nologist_
photobiologic2365205photobiologi__c
photobiological2564455photobiological
photoperiodisms2581935photoperiodisms
photoresists1754455photore___sists
phraseologist1954195ph_raseologist_
phrenologists1956295ph__renologists
phycologists2367135ph___ycologists
physiologists22156015ph__ysiologists
pomologists1648985p___o_mologists
proctologists1856815p__roctologists
protozoologies2663165protozoologi_es
rheologists1547315rh____eologists
teleologists1347225___teleologists
topologists1447865___to_pologists
algologists1346146___alg_ologists
angelologists1553376___angelologists
anthologists1648036_ant__hologists
archaeologists20122816_archaeologists
astrobiologists1873766astrobiologists
bacteriologists2063256bacteriologists
cetologists1449166_cet___ologists
chronobiologist2392796chronobiologist_
chronologist1857626ch_ro_nologist_
conchologists2154566_co_nchologists
cosmetologists1953146_cosmetologists
cosmologists1746416___cosmologists
cryobiologists2254106_cryobiologists
cytologists1748016_cyt___ologists
demonologists1755566_demo_nologists
deontologists1555926__deontologists
entomologist1556976_ento_mologist_
epistemologists2072126epist_emologists
ethnologists1647046__et_hnologists
ethologists1549026__et__hologists
etymologists18156496__et_ymologists
exobiologists2355326__exobiologists
fetologists1547996_fet___ologists
futurologists1773076_fut_urologists
gemologists1577886_____gemologists
geohydrologists2461526geohydrologists
geologist11611786_____geologist_
gerontologists1654856_gerontologists
hematologists19217056_h_ematologists
herpetologists2083636_herpetologists
histologists1646296_h__istologists
horologist14412366_h__o_rologist_
hydrobiologists25134046hydrobiologists
hydrologists2046096_h__ydrologists
ichthyologists2662316icht_hyologists
ideologists1346656____ideologists
liturgiologists17141806liturgiologists
martyrologists2062896mart_yrologists
meteorologists1754186_meteorologists
methodologists2153476_methodologists
metrologists1588836_met__rologists
microbiologists22134816microbiologists
monologists14410076___mo_nologists
morphologists2154266_mo_rphologists
museologists1544746___museologists
mythologists2146896_myt__hologists
neologists1139776_____neologists
neonatologists1584196neo_natologists
neurobiologists18114316neurobiologists
nonbiologists1664726_no_nbiologists
oceanologists1654306__oceanologists
oncologists1448076____oncologists
onomatologists1753336ono_matologists
ontologists1248906____ontologists
oologists1039856____o__ologists
orologists1149826____o_rologists
osteologist1248566__o_steologist_
otologist10412816__ot___ologist_
paleobiologist19156346paleobiologist_
paleoecologist19114726paleoecologist_
paleontologist1765146paleontologist_
paleozoologist2664196paleozoologist_
palynologists1954996p__alynologists
papyrologists2154086p__apyrologists
parasitologists1862806parasitologists
pathologist17410666p_at__hologist_
pedologists1548276p____edologists
penologists1449596p____enologists
petrologist14711886p_et__rologist_
pharmacologist2464176pharmacologist_
phenomenologies2361996phenomenologi_es
philologist1768436ph___ilologist_
phonologies17410006ph__o_nologi_es
photobiology2384016photobiolog___y
photochemists2584816photo__chemists
photochromisms2872926photo_chromisms
photoperiodism2472586photoperiodis_m
photoresist1656416photore___sist_
phototropisms2264686photo__tropisms
photovoltaics2362626photo_voltai_cs
phraseologies1953276ph_raseologi_es
phrenologist1857916ph__renologist_
phycologist2259186ph___ycologist_
physiologist21157326ph__ysiologist_
phytologies2049046phyt___ologi_es
planetologists1763626p_lanetologists
pomologist15412046p___o_mologist_
primatologists19184356p_rimatologists
proctologist1758966p__roctologist_
prologists13311176p_____rologists
protagonists1553686protag___onists
psephologists2155296p__sephologists
psychologists24127476p__sychologists
pteridologists18133726p_teridologists
radiobiologists19174266radiobiologists
rheologist1449536rh____eologist_
rheumatologists2162256rheumatologists
sociobiologists2063626sociobiologists
sociologists1547946___sociologists
speleologists1654326__speleologists
teleologist1249386___teleologist_
thanatologists1852866th_anatologists
theologises15106736___t_heologises
topologist13410646___to_pologist_
toxicologists2353986_to_xicologists
tribologists1546166___tribologists
typologists1746816___t_ypologists
victimologists2262256vict_imologists
volcanologists20122766_volcanologists
zoologists2047176___zo__ologists

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 Filter178691950240.343520965.0
2DLD Change Limit950241538.45311241.5
3Display Results1531530.156980.8
 (SQL Overall)1786911538.95219961.0
 
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.