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

154 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
serins6402967(None) 
sarins63932621sarins
sereins73716121sereins
series64540971series
serifs94017051serifs
serin55434441serin_
serine65432671serine
serines74229541serines
sering74731811sering
aeries64737782aeries
begins94415302begins
berlins93216012berlins
brins75533972_brins
burins84221892burins
cerias83321982cerias
cering94522532cering
erns45428232_er_ns
eserine7415902eserine
eserines8413742eserines
estrins7315852estrins
ferias95020392ferias
ferine96422582ferine
ferns85220082fer_ns
grins65427222_grins
hemins113417572hemins
herns84825582her_ns
heroins103518012heroins
herons94820542herons
jerids142810942jerids
jerkins18358252jerkins
kerns94719562ker_ns
levins94514652levins
merino8315092merino
merinos9311982merinos
merits8320872merits
merlins93015812merlins
mirins83918902mirins
peins76128062pe_ins
pekins121812232pekins
perils84121852perils
peris75537072peri_s
pterins9812992pterins
purins83722652purins
reins56234562re_ins
renins64526452renins
repins84924312repins
rerigs74014792rerigs
reruns66413742reruns
resins64528772resins
rewins95020822rewins
rins46153202__rins
sabins85521982sabins
sains55639972s_ains
sarans64224432sarans
sarin55239252sarin_
saris54544952sari_s
sasins64923102sasins
satins64930482satins
savins93923132savins
scries85226822scries
scrims104615932scrims
scrips105316032scrips
searing83330922searing
sedans74816092sedans
seeing74222142seeing
seeings84411292seeings
seifs85019332se_ifs
seine55732872se_ine
seines65029902se_ines
seis45542392se_i_s
seisins73614392seisins
seizins164010132seizins
semens84616972semens
semina8915572semina
semis74623532semi_s
sepias83616102sepias
sequins1637862sequins
seracs84418572seracs
serails73318362serails
serais64326132serais
serein63318462serein_
serene63522352serene
serenes73222902serenes
seres55448892ser_es
serfs84922012ser_fs
serges74225972serges
serging93416672serging
sergings10299212sergings
serial64625862serial
serials73919752serials
sericins10312462sericins
serif84132132seri_f
seringa83310742seringa
seringas9339002seringas
serious73616282serious
sermons9311782sermons
serous65023562serous
serows96016392serows
serries73925352serries
sers45746652ser__s
serums83916302serums
serves94423652serves
serving113014982serving
servings12249222servings
servos93812722servos
setons64620172setons
sevens93813662sevens
sewans95215902sewans
sewing103819622sewing
sewings11369172sewings
sexing144313892sexing
sferics1236132sferics
sherifs13299682sherifs
shins85131042s_hins
shrine94920052shrine
shrines104618692shrines
shrink134511732shrink
shrinks14397912shrinks
shris84221452shri_s
sins46755282s__ins
sirens65318152sirens
siring75128312siring
skeins103911902skeins
skins94723472s_kins
soring74731882soring
sorings83817252sorings
sorns55028422sor_ns
sozins15510792sozins
spins75327982s_pins
sprains93013592sprains
sprigs94814772sprigs
spring94526012spring
springs104415922springs
sprint84526792sprint
sprints94113772sprints
sprits85122532sprits
sris45434152s_ri_s
stains64923652stains
stearins8312142stearins
steins64818342steins
sterns64616762ster_ns
strains74218152strains
string75327562string
strings84617132strings
strips85719652strips
suberins10315092suberins
swains94513952swains
syrens94911992syrens
syrinx1637142syrinx
terns55226872ter_ns
veins84620492ve_ins
venins93816702venins
verdins112812332verdins
zeins144715392ze_ins

Search took 5 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.360496363.9
2DLD Change Limit825511543.57623084.7
3Display Results1541540.0463347.8
 (SQL Overall)1786911543.98244874.7
 
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.