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

148 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
splenic114866(None) 
selenic9410661selenic
sphenic1449091sphenic
splenia948311splenia
splenii945541splenii
galenic1038692galenic
pleonic1139432_pleonic
scenic10510512s_cenic
sileni63312142sileni_
spheric14510072spheric
splendid1244642splendid
splenetic1345072splenetic
splenial1047182splenial
splenium1246472splenium
splenius1046032splenius
splent84720192splen_t
splents93912132splents
sthenic1268902sthenic
aclinic11188973aclinic
allelic9118173allelic
aphetic142912853aphetic
aphonic142713393aphonic
aplenty1237173aplenty
aplitic11311743aplitic
apneic1078623apne_ic
arsenic939323arsenic
aspheric1547983aspheric
asthenic1378633asthenic
axenic154210003_axenic
cleric10612133_cleric
clinic104312793_clinic
clonic104914673_clonic
colonic115015713colonic
diplegic1444793diplegic
dolmenic1344843dolmenic
edenic9310223_edenic
eirenic939003eirenic
ephebic1646513ephebic
epigenic1347483epigenic
eugenic1038603eugenic
euphenic1557203euphenic
genic85119393__genic
haptenic1545763haptenic
hyaenic1545993hyaenic
hyenic1438723_hyenic
hyphenic2147003hyphenic
irenic8311103_irenic
isogenic11178143isogenic
lenis56326863__lenis
lentic83515743__lentic
malefic1486323malefic
melanic11310403melanic
oleic7313333_ole_ic
opsonic1137253opsonic
panic93923903_p_anic
pelvic13307553_pelvic
penis75129323_p_enis
phenix1837133_phenix
phonic133315213_phonic
phrenic1438773phrenic
pianic103714123_pianic
picnic123410263_picnic
pionic103515953_pionic
plena75816393_plen_a
plench134010813_plench
plenish1239943_plenish
plenism11310113_plenism
plenist9314333_plenist
plenty11311413_plenty
plenum1039503_plenum
poetic10416843_poetic
polemic13311253polemic
polyenic1547673polyenic
pyemic1537893_pyemic
pyknic1734893_pyknic
salic73424713sal__ic
sapremic1445333sapremic
satanic939933satanic
scaleni936883scaleni_
scenics1137773s_cenics
selenide9158863selenide
selenite81713103selenite
selenitic1156913selenitic
selenium1048203selenium
sememic1336503sememic
sepic94617053s__epic
sheenie10159493sheenie
silence9310213silence
silent64125843silen_t
silents73514493silents
silenus7369693silenus
silesia739083silesia
silicic1147603silicic
siphonic1547983siphonic
sklent103614353sklen_t
sklents11348163sklents
solanin7311943solanin
solei55624343sole_i_
solenoid947873solenoid
sonic75225293s__onic
spaeing103413543spaeing
spastic11310383spastic
spathic1437543spathic
spec85821973sp_e__c
specie10412223sp_ecie
speil75618643sp_e_il
speir75315363sp_e_ir
spence103813793sp_ence
spend85619333sp_en_d
spends94714473sp_ends
spendy124911143sp_endy
spense83912433sp_ense
spent75532833sp_en_t
spermic1338523spermic
sphene113412403sphen_e
sphenes123013163sphenes
sphenoid1446323sphenoid
spherics1537073spherics
spic85227433sp___ic
spleen8310263sple_en
spleenier1143863spleenier
spleenish1443653spleenish
spleens937103spleens
spleeny1234563spleeny
splendor1143753splendor
splenetics1443413splenetics
splice104915103spl__ice
spline86020533splin_e
splined105013113splined
splines94718893splines
splining11310773splining
splint85223283splin_t
splints94511743splints
split75729013spl__it
sprent84522383spren_t
sputnik1372273sputnik
stannic936663stannic
stelic8313083s_telic
steric8317063s_teric
sthenia1058503sthenia
stolonic1047583stolonic
suberic11312213suberic
sulfonic1344703sulfonic
sultanic1046173sultanic
sylphic1745883sylphic
syngenic1445823syngenic
valeric1238303valeric
xenic144114643__xenic

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271486.83019623.3
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.28024545.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.