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

130 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
serine6543267(None) 
eserine7415901eserine
ferine96422581ferine
seine55732871se_ine
serene63522351serene
serin55434441serin_
serines74229541serines
sering74731811sering
serins64029671serins
shrine94920051shrine
aedine73218392aedine
aerie54634602aeri_e
anserine8313082anserine
berime105317332berime
berline93716852berline
brine75132272_brine
cering94522532cering
cerise84822042cerise
cerite84724872cerite
cervine122610802cervine
define104718142define
deride84420032deride
derive103817042derive
eerie55228532eeri_e
ermine8416922_ermine
erne46727422_er_ne
eserines8413742eserines
exine125518492_exine
feline94820142feline
feriae95618602feriae
heroine103517482heroine
kerne94718212ker_ne
larine63927042larine
marine84230402marine
merino8315092merino
murine84220022murine
narine63422552narine
nervine102510622nervine
neurine7311682neurine
perinea9313032perinea
purine85321892purine
refine95225692refine
reline65434352reline
repine85627812repine
rerise64325632rerise
retine66237332retine
rexine134719442rexine
sabine84020392sabine
saline65132702saline
sardine83317392sardine
sarin55239252sarin_
sarins63932622sarins
savine94220282savine
scribe104613532scribe
scrive115414942scrive
searing83330922searing
sedile73517232sedile
seeing74222142seeing
seined74023062se_ined
seiner64622482se_iner
seines65029902se_ines
seise54727852se_ise
seize143819502se_ize
semina8915562semina
sene46848052se__ne
senile63420212senile
serape84818412serape
sere46153472ser__e
serein63318462serein_
sereins73716112sereins
serener73415752serener
serenes73222902serenes
serge64727462ser_ge
serging93416672serging
serial64625862serial
seriate73722472seriate
series64540972series
serif84132132seri_f
serifed11811462serifed
serifs94017052serifs
seringa83310742seringa
serotine8313572serotine
serve85425962ser_ve
service1239082service
servile10310642servile
serving113014982serving
sestine73017922sestine
setline7313922setline
sewing103819622sewing
sexing144313892sexing
shine85533092s_hine
shrike134513242shrike
shrined114112412shrined
shrines104618692shrines
shrink134511732shrink
shrive125216952shrive
sine46560622s__ine
siring75128312siring
sordine82515232sordine
soring74731882soring
sozine15712352sozine
spermine12311432spermine
spine76534422s_pine
spline86020532spline
spring94526012spring
springe103913982springe
sprint84526792sprint
sprite84421772sprite
stearine8311902stearine
sterile7316602sterile
striae65422272striae
stride75420962stride
strife95318362strife
strike105619732strike
string75327562string
stripe85822442stripe
strive95020962strive
supine84216692supine
swine85625302s_wine
syringe11349472syringe
syrinx1637142syrinx
terne56426152ter_ne
terrine72517572terrine
trine54734602_trine
urine55026592_urine
uterine7315192uterine
venine93718432venine
verite94323442verite
versine102515172versine
zebrine1836462zebrine

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit825511302.56332208.7
3Display Results1301300.0462826.1
 (SQL Overall)1786911302.73565334.9
 
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.