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

170 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
algologists134614(None) 
algologist1248241algologist_
algologies1246792algologi_es
apologists1348882a_pologists
algological1545973algological
analogists1147313a_nalogists
angelologists1553373angelologists
anthologists1648033anthologists
apologises1347303a_pologises
apologist12412403a_pologist_
audiologists1445613audiologists
biologists1349433_biologists
bryologists1745703bryologists
cetologists1449163cetologists
cytologists1748013cytologists
ecologists13310923_ecologists
enologists11310623_enologists
ethologists1549023ethologists
fetologists1547993fetologists
gemologists1577883gemologists
geologists1279163_geologists
horologists1548963horologists
ideologists1346653ideologists
malacologists1854403malacologists
mixologists2145683mixologists
monologists14410073monologists
mycologists1947733mycologists
myologists1648203_myologists
neologists1139773_neologists
ologists939443___ologists
oncologists1448073oncologists
ontologists1248903ontologists
oologists1039853__oologists
orologists1149823_orologists
otologists1149633_otologists
palynologists1954993palynologists
pathologists1848373pathologists
pedologists1548273pedologists
penologists1449593penologists
pomologists1648983pomologists
prologists13311173_prologists
radiologists1497363radiologists
rheologists1547313rheologists
serologists12410123serologists
sexologists1947253sexologists
sinologists1257673sinologists
teleologists1347223teleologists
topologists1447863topologists
typologists1746813typologists
ufologists1445423_ufologists
urologists1148413_urologists
virologists1546633virologists
zoologists2047173_zoologists
absolutists1351944absolutists
aerologies11312024aerologi_es
aeronomists1355634aeronomists
agonists9289834a_g__onists
agrologies1237694agrologi_es
agronomists1453794agronomists
alcoholisms1852494alcoholisms
algebraists1491364algebraists
algolagniacs166814algolagniacs
algolagnias1361324algolagnias
algology1345274algolog___y
algorisms1246174alg__orisms
allegorists1283404allegorists
allergists1144214al_lergists
altoists848754al__to_ists
analogisms1345214a_nalogisms
analogist10410234a_nalogist_
angelologist1454164angelologist_
angiologies1346134angiologi_es
anthologist15410464anthologist_
apiologies1339064apiologi_es
apologias1247504a_pologi_as
apologies12311194a_pologi_es
apologise1248304a_pologis_e
apologised1444324a_pologised
apologizes2246204a_pologizes
areologies1139824areologi_es
audiologist1347244audiologist_
autonomists1355164autonomists
axiologies1837484axiologi_es
balloonists1353024ballo_onists
biologisms1545344_biologisms
biologist12412344_biologist_
bryologist1647384bryologist_
cardiologists1765144cardiologists
cetologist13412254cetologist_
colonists112512504__colonists
colorists112313594__colorists
cosmologists1746414cosmologists
cytologist16410534cytologist_
dialogists1265604_dialogists
ecologist12314144_ecologist_
enologist10314124_enologist_
ergonomists1473514ergonomists
ethnologists1647044ethnologists
ethologist14411894ethologist_
etymologists18156494etymologists
eulogists1046654__eulogists
fetologist14410404fetologist_
gemmologists1845234gemmologists
gemologist141010284gemologist_
geologist11611784_geologist_
glaciologists1753944glaciologists
graphologists20123834graphologists
histologists1646294histologists
horologist14412364horologist_
hydrologists2046094hydrologists
ideologist1248534ideologist_
iridologists1444684iridologists
limnologists1545324limnologists
lookists1245714_l_o_okists
malacologist1755634malacologist_
malariologists1773354malariologists
mammalogists1652164mammalogists
metrologists1588834metrologists
mixologist2047694mixologist_
monologist13413614monologist_
monologuists1553954monologuists
museologists1544744museologists
mycologist18410354mycologist_
myologist15411094_myologist_
mythologists2146894mythologists
necrologists1547874necrologists
neologisms1345484_neologisms
neologist10712814_neologist_
neurologists1347644neurologists
ologist8313834___ologist_
oncologist13410414oncologist_
ontologist11411364ontologist_
oologist9313494__oologist_
orologist10313104_orologist_
osteologists1346764osteologists
otologist10412814_otologist_
paleologies1448584paleologi_es
palynologist1856304palynologist_
papyrologists2154084papyrologists
pathologist17410664pathologist_
pedologist14410864pedologist_
penologist13412844penologist_
petrologists1559144petrologists
philologists1876684philologists
phonologists1848774phonologists
phycologists2367134phycologists
poloists10910524__polo_ists
pomologist15412044pomologist_
prologist12315084_prologist_
radiologist1399494radiologist_
rheologist1449534rheologist_
selenologists1455334selenologists
semiologists1548224semiologists
serologist11413154serologist_
sexologist1849514sexologist_
sinologist11510664sinologist_
slalomists1283314sl_alomists
sociologists1547944sociologists
soloists869154__solo_ists
speleologists1654324speleologists
syllogists14175174_syllogists
teleologist1249384teleologist_
theologises15106734theologises
topologist13410644topologist_
tribologists1546164tribologists
typologist1648894typologist_
ufologist1347054_ufologist_
urologist10411054_urologist_
virologist1448814virologist_
zoologist1949694_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 Filter1786911488190.453394461.4
2DLD Change Limit1488191708.23318075.9
3Display Results1701700.1101545.5
 (SQL Overall)1786911708.79620315.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.