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

137 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
protozoologists2763031protozoologists_
protozoologist2663882protozoologist__
protozoologies2663163protozoologi_es_
paleozoologists2763854paleozoologists_
photobiologists2365174photobiologists_
photogeologists22173644photogeologists_
cryptozoologist3271795cryptozoologist__
paleozoologist2664195paleozoologist__
photobiologist2266225photobiologist__
photogeologist21134675photogeologist__
proctologists1856815pr__octologists_
protozoology2762665protozoolog____y
cryobiologists2254106cr_yobiologists_
cryptozoologies3271456cryptozoologi_es_
entomologists1655666_ento_mologists_
otologists1149636__ot___ologists_
paleobiologists20115736paleobiologists_
paleoecologists20124176paleoecologists_
paleontologists1884526paleontologists_
paleozoologies2663186paleozoologi_es_
pathologists1848376p_at__hologists_
petrologists1559146p_et__rologists_
phonologists1848776p__ho_nologists_
photobiologies2265156photobiologi_es_
photogeologies2163896photogeologi_es_
pomologists1648986p___o_mologists_
primatologists19184356pr_imatologists_
proctologist1758966pr__octologist__
prologists13311176pr_____ologists_
topologists1447866___to_pologists_
zoologists2047176_____zoologists_
anthologists1648037_ant__hologists_
anthropologists2183417_anthropologists_
archaeologists20122817ar_chaeologists_
astrobiologists1873767astrobiologists_
bacteriologists2063257bacteriologists_
bryologists1745707br____yologists_
cetologists1449167_cet___ologists_
chronobiologist2392797chronobiologist__
chronologists1966117_chro_nologists_
conchologists2154567_co_nchologists_
cosmetologists1953147_cosmetologists_
cosmologists1746417___cosmologists_
criminologists1952977cr_iminologists_
cryobiologist2154527cr_yobiologist__
cryptologists2155237cr__yptologists_
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_
geohydrologists2461527geohydrologists_
gerontologists1654857_gerontologists_
graphologists20123837gr__aphologists_
histologists1646297hist___ologists_
horologists1548967___ho_rologists_
hydrobiologists25134047hydrobiologists_
ichthyologists2662317icht_hyologists_
iridologists1444687ir___idologists_
kremlinologists22141397kremlinologists_
martyrologists2062897mart_yrologists_
meteorologists1754187_meteorologists_
methodologists2153477_methodologists_
metrologists1588837_met__rologists_
microbiologists22134817microbiologists_
monologists14410077___mo_nologists_
morphologists2154267_mo_rphologists_
mythologists2146897_myt__hologists_
neonatologists1584197neo_natologists_
neurobiologists18114317neurobiologists_
nonbiologists1664727_no_nbiologists_
oceanologists1654307__oceanologists_
oncologists1448077____oncologists_
onomatologists1753337ono_matologists_
ontologists1248907____ontologists_
oologists1039857______oologists_
ornithologists1852597or_nithologists_
orologists1149827____o_rologists_
osteologists1346767__o_steologists_
otologist10412817__ot___ologist__
paleobiologist19156347paleobiologist__
paleoecologist19114727paleoecologist__
paleontologist1765147paleontologist__
paleozoological2963267paleozoologi_cal
palynologists1954997p__alynologists_
papyrologists2154087p__apyrologists_
parasitologists1862807parasitologists_
pathologist17410667p_at__hologist__
pedologists1548277p____edologists_
penologists1449597p____enologists_
petrologist14711887p_et__rologist__
pharmacologists2573647pharmacologists_
philologists1876687p___hilologists_
phonologist17411567p__ho_nologist__
photobiologic2365207photobiologi___c
photobiological2564457photobiologi_cal
photogeologic2263737photogeologi___c
photogeological2463107photogeologi_cal
phraseologists2053577p_hraseologists_
phrenologists1956297p__hrenologists_
phycologists2367137p___hycologists_
physiologists22156017p__hysiologists_
planetologists1763627p_lanetologists_
pomologist15412047p___o_mologist__
primatologist18175317pr_imatologist__
proctologies1746317pr__octologi_es_
prologist12315087pr_____ologist__
protagonists1553687prot___agonists_
protectionists18105147prot_ectionists_
protoplasts1566057prot__opl__asts_
protozoons2154367protoz_o_o___ns_
psephologists2155297p__sephologists_
psychologists24127477p__sychologists_
pteridologists18133727p_teridologists_
radiobiologists19174267radiobiologists_
radiologists1497367_r__adiologists_
rheologists1547317_r___heologists_
sociobiologists2063627sociobiologists_
sociologists1547947___sociologists_
teleologists1347227___teleologists_
teratologists1496597terat___ologists_
topologist13410647___to_pologist__
toxicologists2353987_to_xicologists_
tribologists1546167___tribologists_
trichologists1955427tr__ichologists_
typologists1746817___t_ypologists_
urbanologists1653257ur__banologists_
urologists1148417ur_____ologists_
victimologists2262257vict_imologists_
volcanologists20122767_volcanologists_
zoologist1949697_____zoologist__

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.360496363.9
2DLD Change Limit950241378.37611344.8
3Display Results1371370.1061292.5
 (SQL Overall)1786911378.84220209.3
 
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.