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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
serines7422954(None) 
eserines8413741eserines
seines65029901se_ines
serenes73222901serenes
series64540971seri_es
serine65432671serine_
serins64029671serin_s
shrines104618691shrines
aeries64737782aeri_es
anserines9411292anserines
berimes115216642berimes
berlines102315452berlines
brines85028852_brines
cerises94722252cerises
cerites94823432cerites
defines114118682defines
derides93420852derides
derives114017812derives
eeriness8311872eeriness
ermines9416672_ermines
ernes55224812_er_nes
eserine7415902eserine_
exines135715802_exines
felines104718072felines
ferine96422582ferine_
heroines112916572heroines
kernes104717532ker_nes
marines93928012marines
merinos9311982merinos
merises93421422merises
murines93718222murines
nervines112310462nervines
neurines8311192neurines
perinea9313032perinea
purines94420762purines
refines105426342refines
relines75331322relines
repines94927382repines
rerises73525882rerises
retines75134672retines
rexines144719152rexines
sabines94318482sabines
salines74029412salines
sardines92815562sardines
sarins63932622sarin_s
savines104417632savines
scribes113713202scribes
scries85226822scri_es
scrives124414272scrives
seeings84411292seeings
seine55732872se_ine_
seined74023062se_ined
seiner64622482se_iner
seiners74219272se_iners
seises64026712se_ises
seizes154317532se_izes
semises93916552semises
seniles72618022seniles
serapes95218102serapes
sereins73716122serein_s
serene63522352serene_
serener73415762serener
serenest82717622serenest
seres55448892ser__es
serges74225972ser_ges
sergings10299212sergings
serials73919742serials
seriates82620672seriates
serifed11811462serifed
serifs94017052seri_fs
serin55434442serin__
sering74731812serin_g
seringa83310742seringa
seringas9339002seringas
serious73616282serious
serotines9312072serotines
serries73925352serries
serves94423652ser_ves
services1338572services
servings12249222servings
sestines82717242sestines
setlines8312742setlines
sewings11369172sewings
sexiness1537942sexiness
shines95028912s_hines
shrikes144412392shrikes
shrine94920052shrine_
shrined114112412shrined
shrinks14397912shrinks
shrives134416172shrives
sines55954822s__ines
sordines92414072sordines
sorings83817252sorings
sorites73825242sorites
sozines16611262sozines
spermines13310542spermines
spines85132032s_pines
splines94718892splines
springes114014032springes
springs104415922springs
sprints94113772sprints
sprites94220332sprites
stearines9311282stearines
strides84520392strides
strifes104716582strifes
strikes114719092strikes
strings84617132strings
stripes95320572stripes
strives104119372strives
supines94216382supines
syringes122810212syringes
syrinxes18294422syrinxes
ternes65422902ter_nes
terrines82117552terrines
trines64132562_trines
urines64724122_urines
venines103516612venines
verites103822262verites
versines112213822versines
zebrines1935882zebrines

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711203.04635348.3
3Display Results1201200.0304000.0
 (SQL Overall)1786911203.45251764.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.