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

126 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
spermines1331054(None) 
spermine12311431spermine_
ermines9416672__ermines
overmines14312682overmines
serines74229542s_er_ines
spearmints1443002spearmints
superminds1547062superminds
superminis1448552superminis
aperies9423203aper_i_es
berlines102315453_berlines
carmines123617873_carmines
dermises112512023_dermises
determines1358433determines
epergnes1156713eper_gnes
ermine8416923__ermine_
ermined10410603__ermined
eserines8413743eser_ines
extermines1947783extermines
germiness1257693_germiness
harmines132715143_harmines
heroines112916573_heroines
kermises14248313_kermises
nervines112310463_nervines
overmine13313663overmine_
overmined1539603overmined
overmixes2137323overmixes
pectines121914683_pectines
pennines103112043_pennines
pepsines1239883_pepsines
perinea9313033_per_inea
perkiness15209163_perkiness
perlites10316363_perlites
perming123416093_permin_g
permits11314003_permi_ts
permutes1238713_permutes
perniones1148593_perniones
perries93226603_perri_es
piperines131610693piper_ines
premies113823063_premi_es
premises123018273_premises
premixes193110083_premixes
primines123013703_primines
promines123018803_promines
purines94420763_pur_ines
purlines103514053_purlines
sardines92815573s_ardines
seaminess11310473s_eaminess
seemings11337643s_eemings
seines65029903s_e__ines
semises93916553s_e_mises
sereins73716123s_erein_s
serenes73222903s_er_enes
sergings10299213s_ergings
series64540973s_er_i_es
serine65432673s_er_ine_
serins64029673s_er_in_s
sermons9311783s_ermon_s
serotines9312073s_erotines
serries73925353s_erri_es
services1338573s_ervices
servings12249223s_ervings
sestines82717243s_estines
setlines8312743s_etlines
sherries111812893sherri_es
sherrises12156863sherrises
shrines104618693s_hr_ines
skerries12168673skerri_es
smarminess1444303smarminess
sordines92414073s_ordines
sourdines1046743sourdines
sparlings12257153sparlings
sparteines12105173sparteines
spartinas1135793spartinas
speakings16345933speakings
spearmint1365983spearmin_t
species11314133spe_ci_es
specimens1543403specimens
speediness1345223speediness
speedings13265403speedings
speerings12276843speerings
speises93813933spe__ises
spellings12296553spellings
spermaries1468063spermaries
spermic1338523spermi__c
spermicides1853313spermicides
spermous1247933sperm_ous
sperms102512603sperm___s
spines85132033sp___ines
splines94718893sp__lines
sportiness1278233sportiness
sprained1138433sp_rained
sprains93013593sp_rain_s
springes114014033sp_r_inges
springs104415923sp_r_ings
sprints94113773sp_r_ints
sprites94220333sp_r_ites
spumones1254953sp_umones
spurries102311323spurri_es
steaminess1236773steaminess
stearines9311283stearines
sterlings10308753sterlings
sternites9310073sternites
storminess1245213storminess
superfine14411443superfine_
superfixes2246823superfixes
supergenes13610933supergenes
superlies11314553superli_es
superliner1249203superliner
superliners1347383superliners
supermales14410053supermales
supermind1449043supermin_d
supermini1348953supermin_i
supersizes2149813supersizes
supervenes15610073supervenes
supervises1549073supervises
superwides1647773superwides
superwives1847153superwives
surmises10310643s_urmises
sycamines1645523sycamines
terminus1037393_terminus
termites10313693_termites
terrines82117553_terrines
thermites1438043thermites
undermines131710663undermines
versines112213823_versines
yperites13310153yper_ites

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.420425454.8
2DLD Change Limit1486411267.75019179.5
3Display Results1261260.0632000.0
 (SQL Overall)1786911268.23321704.2
 
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.