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

49 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
semicolonies165356(None) 
semicolonial1663052semicolonial
semicolons1454032semicolon__s
semiologies1448802semi_ologies
lexicologies2253633lexicologies
semeiologies1545303semeiologies
semicolon1353943semicolon___
semicolony1753133semicolon__y
subcolonies1553763s_ubcolonies
aetiologies1248984aeti_ologies
codicologies1853674codicologies
colonies103620014____colonies
decolonizes2345534de__colonizes
demonologies1645504demonologies
ecologies12312354_e__cologies
etiologies1139414_eti_ologies
gemmologies1745244gem_mologies
gemologies1449004gem__ologies
hematologies1847564hematologies
misologies13139064__misologies
mixologies20136584__mixologies
musicologies1753384musicologies
mycologies1848864__mycologies
nematologies1546694nematologies
oecologies1339464oe__cologies
recolonizes2245664re__colonizes
sarcologies1446434s_arcologies
schizogonies2761764schizogonies
seismologies1543904seismologies
selenologies1345284selenologies
semasiologies1652994semasiologies
semicolonialism2181494semicolonialism
semiglosses1452014semi_glosses
semihoboes17132614semihobo__es
semillons1145094semi_llon__s
semiologist14410714semi_ologist
semiologists1548224semi_ologists
semisolids1353114semisol__ids
semitones1148944semi__ton_es
serologies11311334se__rologies
sexologies1837714se__xologies
sinologies1148894s__inologies
sitologies1148704s__itologies
sociologies1447804soci_ologies
somatologies1546234somatologies
symbologies1945174sym_bologies
synecologies1844164synecologies
terminologies1653444terminologies
toxicologies2263754toxicologies

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 Limit124790497.65616299.6
3Display Results49490.0301633.3
 (SQL Overall)178691498.07622126.2
 
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.