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

114 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
splenia94831(None) 
splenial1047181splenial
splenic1148661splenic
splenii945541splenii
plena75816392_plen_a
selenic9410662selenic
sileni63312142sileni_
silesia739082silesia
sphenic1449092sphenic
splendid1244642splendid
splenium1246472splenium
splenius1046032splenius
splent84720192splen_t
splents93912132splents
sthenia1058502sthenia
alexia132910463_alexia
aphelia1249423aphelia
aphonia122711883aphonia
aplasia92510803aplasia
aplenty1237173aplenty
apteria9312913apteria
asthenia1167713asthenia
diplegia1244053diplegia
eugenia847713eugenia
galena74911093galen_a
galenic1038693galenic
hymenia1546393hymenia
lenis56326863__lenis
melena81110473melen_a
penial84120893_p_enial
penis75129323_p_enis
penna74520203_p_enna
pennia84412973_pennia
phenix1837133_phenix
plea66830603_ple__a
pleiad947833_ple_iad
plench134010813_plench
plenish1239943_plenish
plenism11310113_plenism
plenist9314333_plenist
plenty11311413_plenty
plenum1039503_plenum
pleonic1139433_pleonic
pleura837533_pleura
polenta9310093polenta
pyemia1337553_pyemia
salina64221123salin_a
salvia93310753sal_via
saphena1235863saphen_a
sapremia1245203sapremia
scaleni936883scaleni_
scena74815783s_cen_a
scenic10510513s_cenic
sclera838883scle_ra
selenide9158863selenide
selenite81713103selenite
selenium1048203selenium
senna54617983s__enna
sensa54117473s__ensa
sepia75318673s__epia
sheenie10159483sheenie
sienna647193s_ienna
silence9310213silence
silent64125843silen_t
silents73514493silents
silenus7369693silenus
silesias848523silesias
sirenian845783sirenian
sklent103614353sklen_t
sklents11348163sklents
solanin7311943solanin
solaria7312493solaria
solatia7312243solatia
solei55624333sole_i_
solenoid947873solenoid
spaeing103413543spaeing
special11310303sp_ecial
specie10412223sp_ecie
speil75618643sp_e_il
speir75315363sp_e_ir
spence103813793sp_ence
spend85619333sp_en_d
spends94714473sp_ends
spendy124911143sp_endy
spense83912433sp_ense
spent75532833sp_en_t
sphene113412403sphen_e
sphenes123013163sphenes
sphenoid1446323sphenoid
spheric14510073spheric
spleen8310263sple_en
spleenier1143863spleenier
spleenish1443653spleenish
spleens937103spleens
spleeny1234553spleeny
splendor1143743splendor
splenetic1345073splenetic
spline86020533splin_e
splined105013113splined
splines94718893splines
splining11310773splining
splint85223283splin_t
splints94511743splints
split75729013spl__it
sprent84522383spren_t
sputnik1372263sputnik
sthenias1178163sthenias
sthenic1268903sthenic
syconia1248293syconia
taenia6313193_taenia
tenia55324483__tenia
valencia1343763valencia
valonia1048303valonia
xenia124814773__xenia

Search took 7 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.1561145455.1
2DLD Change Limit1340271146.32621186.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.52827373.0
 
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.