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

173 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
spermine1231143(None) 
spermines13310541spermines
ermine8416922__ermine
overmine13313662overmine
perming123416092_perming
serine65432672s_er_ine
spearmint1365982spearmint
spermic1338522spermi_c
superfine14411442superfine
supermind1449042supermind
supermini1348952supermini
aspersing1237603aspersing
aspersive1445893aspersive
berline93716853_berline
berming123614833_berming
carmine112918483_carmine
cervine122610803_cervine
deperming1537113deperming
determine1249033determine
epergne1046143eper_gne
ermined10410603__ermined
ermines9416673__ermines
eserine7415903eser_ine
extermine1848283extermine
ferine96422583_fer_ine
germane1049663_germane
germina1038503_germina
harmine122816193_harmine
heroine103517493_heroine
hyperfine2045913hyperfine
nervine102510633_nervine
overmined1539603overmined
overmines14312683overmines
pardine103616733_pardine
pennine93712953_pennine
pepsine11310603_pepsine
perdie94718513_perdi_e
perinea9313043_per_inea
perking143716463_perking
perlite9317323_perlite
permian112612283_permian
permit10321683_permi_t
permits11314003_permits
permute1138793_permute
piperine122011833piper_ine
porcine11312843_porcine
premie103617993_premi_e
premise113818553_premise
premune1138933_premune
primine113214823_primine
promine112819443_promine
purine85321893_pur_ine
purline93516533_purline
quercine1964863quercine
sardine83317393s_ardine
seaming103222113s_eaming
seeming103216263s_eeming
seine55732873s_e__ine
semina8915573s_e_mina
sepaline10311343sepaline
serein63318463s_erein_
sereins73716123s_ereins
serene63522353s_er_ene
serging93416673s_erging
serin55434443s_er_in_
serines74229543s_er_ines
sering74731813s_er_ing
serins64029673s_er_ins
sermon8413553s_ermon_
sermons9311783s_ermons
serotine8313573s_erotine
service1239093s_ervice
servile10310643s_ervile
serving113014983s_erving
sestine73017923s_estine
setline7313923s_etline
shrine94920053s_hr_ine
smerking15258473smerking
sordine82515233s_ordine
sourdine936893sourdine
spamming15317603spamming
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparlike1437673sparlike
sparling112714533sparling
sparring113112223sparring
sparteine1185483sparteine
spartina1037983spartina
spasming13227203spasming
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
spearlike1544143spearlike
spearman1244943spearman_
spearmen1234853spearmen_
spearmints1443003spearmints
speccing15306643speccing
specie10412223spe_ci_e
specimen1444423specimen
specking17359733specking
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
speise84614253spe__ise
spelling113315233spelling
spending122712433spending
sperm93216023sperm___
spermary1545043spermary
spermicide1753493spermicide
spermous1247933spermous
sperms102512603sperm__s
spewing133110453spe_wing
sphering142811943spher_ing
spiering112713353spier_ing
spine76534423sp___ine
spiring103918183spir_ing
spirting112913633spirting
spline86020533sp__line
sporing104319413spor_ing
sporting112415463sporting
sportive1348333sportive
sprain83614863sp_rain_
sprained1138433sp_rained
sprains93013593sp_rains
spring94526013sp_r_ing
springe103913983sp_r_inge
sprint84526793sp_r_int
sprite84421773sp_r_ite
spuming1248523sp_uming
spumone1154383sp_umone
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
steaming114013213steaming
stearine8311903stearine
stemming13408203stemming
sterile7316603ster_ile
sterling93615553sterling
sternite8310543sternite
storming11209423storming
supergene12510233supergene
supering11317683super_ing
superlie10312123superli_e
superliner1249203superliner
supermale1349983supermale
superman12310233superman_
supermen12311303supermen_
superminds1547063superminds
superminis1448553superminis
supersize20410203supersize
supervene1469443supervene
supervise1449283supervise
superwide1548203superwide
superwife1746733superwife
surmise9311083s_urmise
swarming1458223swarming
swerving1546113swerving
sycamine1545723sycamine
terming104016003_terming
termini93410813_termini
termite9313893_termite
terrine72517573_terrine
thermite1339033thermite
undermine122012233undermine
uterine7315193uter_ine
vermin113414523_vermin_
versine102515173_versine
vespertine1544663vespertine
viperine13189713viper_ine
yperite1249893yper_ite

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.420425454.8
2DLD Change Limit1461621737.59619242.0
3Display Results1731730.0762276.3
 (SQL Overall)1786911738.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.