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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

46 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
semasiologies165299(None) 
semeiologies1545302sem_eiologies
semiologies1448802sem__iologies
hematologies1847563hema_tologies
nematologies1546693nema_tologies
seismologies1543903se_ismologies
semasiological1983013semasiological
semasiology1752673semasiolog__y
somatologies1546233soma_tologies
aerobiologies1655054aerobiologies
aetiologies1248984ae__tiologies
apiologies1339064___apiologies
axiologies1837484___axiologies
craniologies1545374_craniologies
demonologies1645504dem_onologies
dermatologies1755254derma_tologies
embryologies2053164_embryologies
escapologies1753224esca_pologies
etiologies1139414_e__tiologies
exobiologies2254404_exobiologies
gemmologies1745244gem__mologies
gemologies1449004gem___ologies
glaciologies1663694_glaciologies
hagiologies1645344__hagiologies
kinesiologies1851834kinesiologies
malariologies1652744malariologies
misologies13139064__mis_ologies
missiologies1553314_missiologies
museologies1444544__museologies
musicologies1753384__musicologies
parasitologies1782364parasitologies
phraseologies1953274phraseologies
physiologies2155364_physiologies
radiologies1347804__radiologies
sarcologies1446434s__arcologies
scatologies1446864s_ca_tologies
selenologies1345284se_lenologies
semicolonies1653564sem_icolonies
semiologist14410714sem__iologist
semiologists1548224sem__iologists
serologies11311334se___rologies
sexologies1837714se___xologies
sociologies1447804s__ociologies
soteriologies1453874soteriologies
symbologies1945174sym__bologies
teratologies1346874tera_tologies

Search took 6 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 Limit95024464.68620278.3
3Display Results46460.0162875.0
 (SQL Overall)178691465.06235300.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.