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

310 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
sera4614139(None) 
era35741501_era
sea36161291se_a
sear47353841sear
ser36752401ser_
serac75925201serac
serai56830161serai
seral56336381seral
sere46153471sere
serf76340111serf
sers45746651sers
seta45637311seta
sora45746911sora
sura45740291sura
vera76828841vera
aero45435342aero
aery77231682aery
area45843402area
asea46327182ase_a
aura45836252aura
bear66844642bear
bema85825252bema
berg75425542berg
berk105929842berk
berm86732752berm
beta66234132beta
bora66141632bora
bra56339462_bra
bura66139532bura
ceca84820782ceca
cere66741472cere
ceria75125362ceria
cero66329452cero
dear55343602dear
derat65044082derat
deray95024182deray
dere56845902dere
derm76031892derm
derma84918522derma
deva85720982deva
dura55232112dura
ear36867882_ear
eery76129622eery
er28345142_er_
eras45441502_eras
ere36352772_ere
erg45531072_erg
ern35738362_ern
err35626532_err
ers36046282_ers
eta35834192_eta
eyra76217552eyra
fear75337792fear
fer66646122fer_
feral85424652feral
fere76342232fere
feria85922712feria
fern76129322fern
feta76528902feta
fora75937392fora
gear55934972gear
gerah9315302gerah
germ75428962germ
geta56627442geta
hear76143882hear
her66547812her_
herb94730962herb
herd84933062herd
here76447102here
herl75834552herl
herm95636152herm
herma105318892herma
hern76134892hern
hero74635782hero
hers75844872hers
hora76136562hora
jerk154920132jerk
jura116024892jura
kea76540922ke_a
kerb104322722kerb
kerf115827472kerf
kern85326222kern
kora86431572kora
lea37660182le_a
lear47045952lear
leva77020712leva
lira46928692lira
mara67444582mara
mega77620872mega
merc87225622merc
mere67244442mere
merk106027942merk
merl65830972merl
mesa67025482mesa
meta65932412meta
mora66641272mora
mura65633302mura
near45236502near
nema65522522nema
nerd56624942nerd
okra86413572okra
opera7313572opera
ora37250832_ora
orra46120722orra
osetra667422osetra
para65242182para
pea56657242pe_a
pear69745232pear
per56353092per_
pere66450262pere
perea75026442perea
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
rear45644552rear
reran57329102reran
sabra75317852sabra
sacra74516992sacra
saga55331172saga
saran53730312saran
sard55344242sard
sari45444042sari
sark84938972sark
scar66434202scar
scena74815782scena
sclera838892sclera
scrag85916172scrag
scram910621622scram
scrap97120402scrap
scry96017762scry
seal45654372seal
seam66645972seam
sears54744912sears
seas45755272seas
seat47575562seat
sec55945322se_c
secs65033892secs
sect67443622sect
sedan65620422sedan
see35772262se_e
seed55549482seed
seek85935482seek
seel45042982seel
seem65438562seem
seen46943122seen
seep66540342seep
seer45547042seer
seers55136382seers
sees45361052sees
seg45544882se_g
sego56525182sego
segs54933882segs
sei36048932se_i
seif75638732seif
seis45542392seis
sel38253322se_l
selah8319612selah
self75138292self
sell45840612sell
sels46345982sels
selva83014272selva
seme65836652seme
semi65127222semi
sen36058522se_n
send55237292send
sene46848052sene
senna54617982senna
senora63216162senora
sensa54117472sensa
sent46963012sent
sepal77723002sepal
sepia75318672sepia
sept65844362sept
septa75518082septa
seracs84418572seracs
serail64222672serail
serais64326132serais
serape84818412serape
seraph114011162seraph
serdab937832serdab
sered65737292sered
serer55935512serer
seres55448892seres
serfs84922012serfs
serge64727472serge
serial64625862serial
serif84132132serif
serin55434442serin
serosa6313022serosa
serow86720442serow
serry84824122serry
serum75223472serum
serval93913412serval
serve85425962serve
servo84516682servo
set36681252se_t
setae56026222setae
setal56430902setal
sets45549502sets
sett45949052sett
sew66247262se_w
sewan85921292sewan
sewar85421102sewar
sewn76124332sewn
sews75836022sews
sex107043222se_x
sext117338092sext
sexy146418022sexy
sha69837782s_ha
shea76031572shea
shear85424832shear
sherd96321152sherd
sherpa1138092sherpa
shri76021702shri
shwa106014962shwa
sierra637312sierra
sika86021332sika
sima64730792sima
sir35746682sir_
sire46150422sire
sirra54416322sirra
sirs44338342sirs
ska76925862s_ka
skua86113152skua
smear74416392smear
smerk115412722smerk
soar46838672soar
soba64927922soba
soca66330052soca
soda56329392soda
sofa75625602sofa
soja115619512soja
sola45541862sola
soma65635292soma
soras55041012soras
sorb68333042sorb
sord56237202sord
sore47059532sore
sori46039842sori
sorn46641062sorn
sort46264812sort
sorta57125412sorta
soya75724432soya
spa55730812s_pa
spar65433302spar
spear75821062spear
sperm93216022sperm
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spry96819122spry
sri35634002s_ri
star48037762star
stela54019042stela
stere55328542stere
stern55319122stern
sterna63712762sterna
stoa45425912stoa
strap77925262strap
straw813321292straw
stray88525572stray
stria55723212stria
suba64926602suba
suer45334032suer_
suers55128482suers
supra73614252supra
surah86823252surah
sural55931262sural
suras55336332suras
surd56433812surd
sure45447412sure
surf76039312surf
surra55521342surra
sutra54217932sutra
swear85316852swear
tea37353322te_a
tear45242882tear
tela45532972tela
tepa66021682tepa
terai53525482terai
terga63315642terga
term66233152term
tern46134802tern
terra54419672terra
tetra53417952tetra
tora47545992tora
urea46528062urea
user45023002user_
users55817572users
vara75530892vara
vela75725542vela
vena76126292vena
verb96224872verb
vert77249372vert
very108025642very
wear75836722wear
weka117013872weka
were76238332were
wert79749822wert
yea66445752ye_a
year76534252year
yerba101010762yerba
yerk116222082yerk
zebra1637882zebra
zerk175319252zerk
zero134822472zero
zeta135121642zeta

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298723100.82636164.6
3Display Results3103100.0803875.0
 (SQL Overall)1786913101.172152466.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.