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

(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
photogeologists22173641photogeologists_
photogeologist21134672photogeologist__
photobiologists2365173photobiologists_
photogeologies2163893photogeologi_es_
photobiologist2266224photobiologist__
photogeologic2263734photogeologi___c
photogeological2463104photogeologi_cal
protozoologists2763034protozoologists_
phonologists1848775ph__o_nologists_
photobiologies2265155photobiologi_es_
photogeology2263305photogeolog____y
phraseologists2053575ph_raseologists_
protozoologist2663885protozoologist__
chronologists1966116ch_ro_nologists_
entomologists1655666_ento_mologists_
geologists1279166_____geologists_
horologists1548966_h__o_rologists_
osteologists1346766__o_steologists_
otologists1149636__ot___ologists_
paleobiologists20115736paleobiologists_
paleoecologists20124176paleoecologists_
paleontologists1884526paleontologists_
paleozoologists2763856paleozoologists_
pathologists1848376p_at__hologists_
petrologists1559146p_et__rologists_
pharmacologists2573646pharmacologists_
phenomenologist2382686phenomenologist__
philologists1876686ph___ilologists_
phonologist17411566ph__o_nologist__
photobiologic2365206photobiologi___c
photobiological2564456photobiologi_cal
photoperiodisms2581936photoperiodisms_
photoresists1754456photore___sists_
phraseologist1954196ph_raseologist__
phrenologists1956296ph__renologists_
phycologists2367136ph___ycologists_
physiologists22156016ph__ysiologists_
pomologists1648986p___o_mologists_
proctologists1856816p__roctologists_
protozoologies2663166protozoologi_es_
rheologists1547316rh____eologists_
teleologists1347226___teleologists_
topologists1447866___to_pologists_
algologists1346147___alg_ologists_
angelologists1553377___angelologists_
anthologists1648037_ant__hologists_
archaeologists20122817_archaeologists_
astrobiologists1873767astrobiologists_
bacteriologists2063257bacteriologists_
cetologists1449167_cet___ologists_
chronobiologist2392797chronobiologist__
chronologist1857627ch_ro_nologist__
conchologists2154567_co_nchologists_
cosmetologists1953147_cosmetologists_
cosmologists1746417___cosmologists_
cryobiologists2254107_cryobiologists_
cytologists1748017_cyt___ologists_
demonologists1755567_demo_nologists_
deontologists1555927__deontologists_
entomologist1556977_ento_mologist__
epistemologists2072127epist_emologists_
ethnologists1647047__et_hnologists_
ethologists1549027__et__hologists_
etymologists18156497__et_ymologists_
exobiologists2355327__exobiologists_
fetologists1547997_fet___ologists_
futurologists1773077_fut_urologists_
gemologists1577887_____gemologists_
geohydrologists2461527geohydrologists_
geologist11611787_____geologist__
gerontologists1654857_gerontologists_
hematologists19217057_h_ematologists_
herpetologists2083637_herpetologists_
histologists1646297_h__istologists_
horologist14412367_h__o_rologist__
hydrobiologists25134047hydrobiologists_
hydrologists2046097_h__ydrologists_
ichthyologists2662317icht_hyologists_
ideologists1346657____ideologists_
liturgiologists17141807liturgiologists_
martyrologists2062897mart_yrologists_
meteorologists1754187_meteorologists_
methodologists2153477_methodologists_
metrologists1588837_met__rologists_
microbiologists22134817microbiologists_
monologists14410077___mo_nologists_
morphologists2154267_mo_rphologists_
museologists1544747___museologists_
mythologists2146897_myt__hologists_
neologists1139777_____neologists_
neonatologists1584197neo_natologists_
neurobiologists18114317neurobiologists_
nonbiologists1664727_no_nbiologists_
oceanologists1654307__oceanologists_
oncologists1448077____oncologists_
onomatologists1753337ono_matologists_
ontologists1248907____ontologists_
oologists1039857____o__ologists_
orologists1149827____o_rologists_
osteologist1248567__o_steologist__
otologist10412817__ot___ologist__
paleobiologist19156347paleobiologist__
paleoecologist19114727paleoecologist__
paleontologist1765147paleontologist__
paleozoologist2664197paleozoologist__
palynologists1954997p__alynologists_
papyrologists2154087p__apyrologists_
parasitologists1862807parasitologists_
pathologist17410667p_at__hologist__
pedologists1548277p____edologists_
penologists1449597p____enologists_
petrologist14711887p_et__rologist__
pharmacologist2464177pharmacologist__
phenomenologies2361997phenomenologi_es_
philologist1768437ph___ilologist__
phonologies17410007ph__o_nologi_es_
photobiology2384017photobiolog____y
photochemists2584817photo__chemists_
photochromisms2872927photo_chromisms_
photoperiodism2472587photoperiodi__sm
photoresist1656417photore___sist__
phototropisms2264687photo__tropisms_
photovoltaics2362627photo_voltai_cs_
phraseologies1953277ph_raseologi_es_
phrenologist1857917ph__renologist__
phycologist2259187ph___ycologist__
physiologist21157327ph__ysiologist__
phytologies2049047phyt___ologi_es_
planetologists1763627p_lanetologists_
pomologist15412047p___o_mologist__
primatologists19184357p_rimatologists_
proctologist1758967p__roctologist__
prologists13311177p_____rologists_
protagonists1553687protag___onists_
psephologists2155297p__sephologists_
psychologists24127477p__sychologists_
pteridologists18133727p_teridologists_
radiobiologists19174267radiobiologists_
rheologist1449537rh____eologist__
rheumatologists2162257rheumatologists_
sociobiologists2063627sociobiologists_
sociologists1547947___sociologists_
speleologists1654327__speleologists_
teleologist1249387___teleologist__
thanatologists1852867th_anatologists_
theologises15106737___t_heologises_
topologist13410647___to_pologist__
toxicologists2353987_to_xicologists_
tribologists1546167___tribologists_
typologists1746817___t_ypologists_
victimologists2262257vict_imologists_
volcanologists20122767_volcanologists_
zoologists2047177___zo__ologists_

Search took 11 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.376475242.0
2DLD Change Limit9502415310.1869328.9
3Display Results1531530.1261214.3
 (SQL Overall)17869115310.68816718.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.