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

130 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
semiological174778(None) 
etiological1448412_etiological
gemological1747022gem_ological
semasiological1983012semasiological
semiologically2254992semiologically
serological1468772se_rological
sociological1747502sociological
abiological1647833_abiological
audiological1665663audiological
axiological2146873_axiological
biological15128883__biological
demonological1954963demonological
ecological1548703_e_cological
enological1348883_e_nological
ethological1748193_ethological
geological1448073ge__ological
hagiological1955813hagiological
hematological2155943hematological
homological1948443hom_ological
limnological1745073limnological
metrological1748373metrological
necrological1747283necrological
nematological1855663nematological
neurological1547333neurological
nomological1648073nom_ological
pedological1757613pe_dological
penological1648873pe_nological
petrological1758593petrological
pomological1848033pom_ological
prebiological2055973prebiological
psephological2354983psephological
radiological1646983radiological
scatological1745543scatological
seismological1873963seismological
selenological1654663selenological
semicolonial1663053semicoloni_al
semiologies1448803semiologi_es
semiologist14410713semiologi_st
semiologists1548223semiologists
semipolitical1962133semipolitical
semitropical1872463semitropical
sinological1447133s_inological
somatological1854883somatological
soteriological1763893soteriological
speleological1853913speleological
stereological1655673stereological
teleological1546573teleological
terminological1953643terminological
aerobiological1955134aerobiological
algological1545974_algological
anthological1847514anthological
antilogical1447274anti_logical
astrological1547024astrological
biologicals16105024__biologicals
bryological1945374_bryological
cardiological1954974cardiological
codicological1853894codicological
cosmological1946084cosmological
criminological21102774criminological
cytological1947454_cytological
demiurgical1791514demi_urgical
dendrological1853834dendrological
deontological1755174deontological
dermatological2053854dermatological
dialogical1445514__dialogical
embryological2353184_embryological
epidemiological23172604epidemiological
ethnological1846814ethnological
etiologic1246784_etiologic__
etiologically1955994_etiologically
etymological2045874etymological
exobiological2554724exobiological
genealogical1652714genealogical
glaciological1963914glaciological
histological1846084histological
horological1748284_horological
hydrological2246484hydrological
iconological1756024iconological
ideological15106644_ideological
illogical1245414___illogical
immunological2054014immunological
karyological2274734karyological
lithological1845894lithological
museological1754784museological
musicological2053544musicological
mycological2147114_mycological
mythological2346904mythological
nonbiological1855264nonbiological
nosological1447374_nosological
numerological1854014numerological
oncological1647254_oncological
ontological1448314_ontological
oological1248324___oological
osteological1546374osteological
pathological2047984pathological
phenological2068054phenological
philological2046374philological
phonological2058374phonological
phycological2546944phycological
physiological2455574physiological
psychological2656594psychological
pteridological2053594pteridological
rheological17127474_rheological
semeiologies1545304semeiologi_es
semiclassical1971504semiclassical
semimystical2161684semimystical
semiofficial2261254semio_fficial
semiology1546894semiolog___y
serologic1248674se_rologic__
serologically1957124se_rologically
sexologic1945604se_xologic__
sociologic1555924sociologic__
sociologically2254754sociologically
symbolical1953244symbol__ical
synecological21104114synecological
tautological1555484tautological
technological2155144technological
teratological1656114teratological
theological1798264_theological
topological1647434_topological
toxicological2553984toxicological
tribological1745984tribological
tropological1746634tropological
typological1946684_typological
ufological1644904__ufological
unecological1745824unecological
urological1347754__urological
vexillological2761684vexillological
virological1746304_virological
zoological2246444__zoological

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901307.56316500.1
3Display Results1301300.0801625.0
 (SQL Overall)1786911308.03322244.6
 
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.