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

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

79 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
splenius104603(None) 
splenium1246471splenium
selenious946962selenious
selenium1048202selenium
seleniums1145822seleniums
selenous848972selenous
silenus7369692silen_us
splenia948312spleni_a
splenial1047182splenial
splenic1148662spleni_c
splenii945542spleni_i
splents93912132splen_ts
genius74512923__genius
lenis56326863__leni_s
penis75129323_p_eni_s
plenish1239943_plenish
plenism11310113_plenism
plenisms1237963_plenisms
plenist9314333_plenist
plenists1038253_plenists
plenties10314693_plenties
plenum1039503_plen_um
plenums1136533_plenums
plexus15377283_ple_xus
saphenous1444873saphenous
scalenus1045543scalen_us
scenics1137773s_cenics
sclerous1047913sclerous
selenic9410663seleni_c
selenide9158863selenide
selenides10178193selenides
selenite81713103selenite
selenites91312083selenites
sheenies111411543sheenies
silences10310073silences
sileni63312143sileni__
silents73514493silen_ts
silesias848523silesias
sklents11348163sklen_ts
solanins8310513solanins
soleness8814263soleness
solenoids1045543solenoids
soleus64615613sole__us
spaeings11276253spaeings
species11314133sp_ecies
specious1247483sp_ecious
speils84116223sp_e_ils
speirs85013233sp_e_irs
speiss84311643sp_e_iss
spences113413923sp_ences
spends94714473sp_en_ds
spenses92913573sp_enses
sphenes123013163sphen_es
sphenic1449093spheni_c
sphenoids1544673sphenoids
spherics1537073spherics
spinnies103210543spinnies
spinous9310443sp_inous
spleenful1492173spleenful
spleenier1143863spleenier
spleeniest1264293spleeniest
spleenish1443653spleenish
spleens937103sple_ens
splendid1244643splendid
splendor1143743splendor
splendors1244013splendors
splendour1252223splendour
splendours1351843splendours
splendrous1353183splendrous
splenetics1443413splenetics
splent84720193splen__t
splines94718893splin_es
splining11310773splining
splints94511743splin_ts
splits85416413spl__its
spoonies101911753spoonies
sputniks1462093sputniks
sthenias1178163sthenias
sweenies11148763sweenies

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162798.53317129.0
3Display Results79790.0601316.7
 (SQL Overall)178691798.74920424.2
 
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.