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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
sclerites113944(None) 
sclerite10410711sclerite_
scleritis1146411scleritis
cerites94823432_c_erites
dolerites101410892dolerites
scleritic1345752scleritic
scleritises1344592scleritises
scleroses1146372scleroses
scolecites1445182scolecites
selenites91312082selenites
siderites10410422siderites
acierates11310793acierates
ankerites1348523ankerites
celeries10316313celeri_es
celerities1289773celerities
cerates95428233_c_erates
cerises94722253_c_erises
cerite84724873_c_erite_
certes84623083_c_er_tes
chedites1438263_chedites
chlorites142311963chlorites
claries93422203_clari_es
clarities11312483_clarities
clergies1137903_clergies
clerics1149333_cleri_cs
clerids1049083_cleri_ds
clerihew1642683_clerihew
clerihews1741553_clerihews
clerisies1147253_clerisies
cleveites1443703_cleveites
clevises1336903_clevises
coesites101313093_coesites
cowrites133011593_cowrites
cuprites1259023_cuprites
curites93919863_c_urites
cycleries1647033cycleri_es
dolerite9611773dolerite_
eclogites1245263eclogites
galenites10129183galenites
laterites9715043laterites
lenites7818443__lenites
millerites1247933millerites
pelerines11311833pelerines
salaries8319573salari_es
saleratus944813saleratus
sceneries1149393sceneri_es
scheelites1543253scheelites
sciurines1144683sciurines
sclerae937933scler_ae_
scleras948223scler__as
sclereids1243853sclereids
scleromas1364313scleromas
sclerose1046213sclerose_
sclerosed1244013sclerosed
sclerosis1145363sclerosis
sclerotia1143993sclerotia
sclerotic1345753sclerotic
sclerotics1443973sclerotics
sclerotin1144973sclerotin
sclerotins1244433sclerotins
sclerous1047913scler_ous
scolecite1345643scolecite_
scribes113713203sc__ribes
scries85226823sc__ri_es
scrives124414273sc__rives
sculleries1244833sculleri_es
scurries102911483scurri_es
sealeries9313123sealeri_es
selenates91611343selenates
selenides10178193selenides
selenite81713103selenite_
seriates82620663s__eriates
series64540973s__eri_es
serines74229543s__erines
severities1348513severities
siderite9411363siderite_
sienites8311913s_ienites
skywrites1952763skywrites
soberizes2098963soberizes
solarises9512703solarises
solarizes18511613solarizes
solecises1189103solecises
solecizes2087863solecizes
solerets839693soleret_s
sorites73825243s__orites
sphalerites1652803sphalerites
sprites94220333s__prites
stellites938103stellites
sternites9310073s_ternites
suberises11813453suberises
suberizes20811823suberizes
sulfites1139903sul_fites
sulphites1445683sulphites
sybarites1465933sybarites
syenites1138943s_yenites
sylvites14225843syl_vites
tolerates9312113tolerates
ulcerates1148843ulcerates
ulexites1534943_ulexites
valerates12310533valerates
verites103822253__verites
voleries11313233voleri_es
yperites13310153_yperites

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 Filter1786911486410.1601116818.8
2DLD Change Limit1486411038.15318231.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.