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

125 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
limnologists154532(None) 
limnologist1446681limnologist_
limnologies1445532limnologi_es
sinologists1257672si_nologists
biologists1349433bi__ologists
climatologists1983283climatologists
criminologists1952973criminologists
demonologists1755563demonologists
enologists11310623__enologists
ethnologists1647043ethnologists
gemmologists1845233gemmologists
gemologists1577883gem_ologists
histologists1646293histologists
ideologists1346653_ideologists
immunologists18124493immunologists
lichenologists2063033lichenologists
limnologic1553533limnologi__c
limnological1745073limnological
mixologists2145683mi_xologists
monologists14410073_monologists
myologists1648203__myologists
penologists1449593_penologists
phonologists1848773phonologists
pomologists1648983pom_ologists
semiologists1548223semiologists
sinologist11510663si_nologist_
virologists1546633vi_rologists
algologists1346144_algologists
analogists1147314__analogists
anthologists1648034anthologists
apologists1348884__apologists
audiologists1445614audiologists
biologisms1545344bi__ologisms
biologist12412344bi__ologist_
bryologists1745704_bryologists
campanologists2152624campanologists
cetologists1449164_cetologists
chronologists1966114chronologists
climatologist1873944climatologist_
cosmologists1746414cosmologists
criminologist1863644criminologist_
cytologists1748014_cytologists
demonologist1657054demonologist_
deontologists1555924deontologists
dialogists1265604di__alogists
ecologists13310924__ecologists
enologist10314124__enologist_
ethnologist1549264ethnologist_
ethologists1549024_ethologists
etymologists18156494etymologists
fetologists1547994_fetologists
gemmologist1746544gemmologist_
gemologist141010284gem_ologist_
geologists1279164__geologists
glaciologists1753944glaciologists
hematologists19217054hematologists
histologist1547984histologist_
horologists1548964_horologists
hydrologists2046094hydrologists
hymnologies2046104hymnologi_es
ideologist1248534_ideologist_
immunologist17135324immunologist_
iridologists1444684iridologists
lexicologists2374154lexicologists
lichenologist1973914lichenologist_
limnology1544434limnolog___y
lithologies1546834lithologi_es
mammalogists1652164mammalogists
metrologists1588834metrologists
mixologist2047694mi_xologist_
monologist13413614_monologist_
monologuists1553954_monologuists
museologists1544744museologists
mycologists1947734_mycologists
myologist15411094__myologist_
mythologists2146894mythologists
necrologists1547874necrologists
nematologists16166604nematologists
neologists1139774__neologists
neurologists1347644neurologists
numerologists1664014numerologists
oceanologists1654304oceanologists
oinologies1148304oi_nologi_es
ologists939444____ologists
oncologists1448074_oncologists
ontologists1248904_ontologists
oologists1039854___oologists
orologists1149824__orologists
osteologists1346764osteologists
otologists1149634__otologists
palynologists1954994palynologists
pathologists1848374pathologists
pedologists1548274_pedologists
penologist13412844_penologist_
petrologists1559144petrologists
philologists1876684philologists
phonologist17411564phonologist_
phrenologists1956294phrenologists
phycologists2367134phycologists
piccoloists1752774piccolo_ists
pomologist15412044pom_ologist_
primatologists19184354primatologists
prologists13311174__prologists
radiologists1497364radiologists
rheologists1547314_rheologists
seismologists16124194seismologists
selenologists1455334selenologists
semiologist14410714semiologist_
serologists12410124_serologists
sexologists1947254_sexologists
sinologies1148894si_nologi_es
sociologists1547944sociologists
technologists19125704technologists
teleologists1347224teleologists
topologists1447864_topologists
tribologists1546164tribologists
trichologists1955424trichologists
typologists1746814_typologists
ufologists1445424__ufologists
urbanologists1653254urbanologists
urologists1148414__urologists
virologist1448814vi_rologist_
volcanologists20122764volcanologists
vulcanologists2092304vulcanologists
zoologists2047174__zoologists

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901256.64018793.7
3Display Results1251250.0761644.7
 (SQL Overall)1786911257.10625146.5
 
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.