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

336 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
sha6983778(None) 
aha611246641aha
ha510259941_ha
sea36161291sea
sh56828521sh_
shad86230911shad
shag86430561shag
shah105627781shah
sham96436351sham
shat76456591shat
shaw108132551shaw
shay107133341shay
she66837691she
shea76031571shea
shh97121071shh
shwa106014961shwa
shy96728191shy
ska76925861ska
spa55730811spa
wha96422071wha
aa219179952_aa
aah616252962aah
aba512850952aba
aga410447232aga
agha87417302agha
ah513868792ah_
ahi68040232ahi
ahs68644822ahs
ala312463602ala
ama510853302ama
ana39559822ana
asea46327182asea
ash67944602ash_
ashy107717352ashy
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
bah87755352bah
boa56954032boa
bra56339462bra
chad105525502chad
chai95929902chai
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
chi86228652chi
chia96026622chia
dah78148982dah
dhak125512032dhak
dhal86719282dhal
eh58339962eh_
epha9310052epha
era35741502era
eta35834192eta
fa510148452_fa
ghat86435282ghat
ghi77019882ghi
goa47343802goa
had77658762_had
hae67364002_hae
hag77255742_hag
hah910655222_hah
haha107821062haha
haj138140602_haj
ham86363282_ham
hao67251122_hao
hap87360052_hap
has67372652_has
hat67289962_hat
haw97153272_haw
hay97358772_hay
he58151952_he
hi57947582_hi
hm78126732_hm
ho510258272_ho
isba61310872isba
ka69145082_ka
kasha124710722kasha
kea76540912kea
khaf145319602khaf
khan115819142khan
khat116730722khat
khi106318302khi
koa76737772koa
la219261632_la
lea37660182lea
ma410060652_ma
mho86624622mho
moa57249182moa
na28652482_na
nah69847002nah
oba57531552oba
oca56731732oca
oda48133042oda
oh57447002oh_
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oka76926802oka
ora37250832ora
ossa43714162ossa
ova66823792ova
pa410456482_pa
pah88853592pah
pasha105417182pasha
pea56657242pea
phat95837862phat
phi86524202phi
pht86030522pht
pia56848032pia
pshaw13447512pshaw
pya87023752pya
qua124821972qua
rah68052402rah
rhea75017432rhea
rho65924832rho
ria36745502ria
rya67622012rya
sab56563202sab
sac57452862sac
sad47459202sad
sae38365182sae
sag46163402sag
saga55331172saga
sal36462882sal
sap56463232sap
sat36288482sat
sau36356572sau
saw68255352saw
sax107447642sax
say67264762say
scab85926712scab
scad75725762scad
scag76626892scag
scam85932352scam
scan65530452scan
scar66434202scar
scat65848372scat
schav1338312schav
schwa13426842schwa
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
sec55945322sec
see35772262see
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
ser36752402ser
sera46141392sera
set36681252set
seta45637312seta
sew66247262sew
sex107043222sex
shack145321752shack
shade95125582shade
shads95124482shads
shady125416512shady
shaft115725252shaft
shags95123862shags
shahs115919512shahs
shake124726402shake
shako125516082shako
shaky154616842shaky
shale85332832shale
shall85024052shall
shalt85534482shalt
shaly114322862shaly
shame105726702shame
shams105829412shams
shank125422192shank
shape105125112shape
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shaul85418102shaul
shave114425892shave
shawl116217572shawl
shawm135316142shawm
shawn116417612shawn
shaws116226262shaws
shays116021432shays
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
shed86536152shed
shes75734352shes
shew108030762shew
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shiva115915002shiva
shmo95318092shmo
shoal83920262shoal
shoat85633942shoat
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
shri76021692shri
shul75823152shul
shun75122772shun
shut76137582shut
shwas116415102shwas
si29149572s_i
sial45938832sial
sib56850302sib
sic55847872sic
sika86021322sika
sim56553132sim
sima64730782sima
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
skag96321512skag
skas85325712skas
skat87037892skat
ski74925682ski
skua86113152skua
sky106420992sky
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sly66228562sly
snag55827872snag
snap65727032snap
snaw78923072snaw
so28855442s_o
soak87227662soak
soap65831132soap
soar46838672soar
sob57857942sob
soba64927922soba
soca66330052soca
sod46053702sod
soda56329382soda
sofa75625602sofa
soja115619512soja
sol37256622sol
sola45541862sola
som59153802som
soma65635292soma
son37761952son
sop57557862sop
sora45746912sora
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
sox106444192sox
soy67851452soy
soya75724432soya
spae65034322spae
spam85930042spam
span65234662span
spar65433302spar
spas67036722spas
spat66548522spat
spay96631662spay
spaz155626162spaz
spy86023742spy
sri35634002sri
stab67329932stab
stag57332002stag
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
stoa45425912stoa
sty66227312sty
sub55445552sub
suba64926602suba
sue35651462sue
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
sura45740292sura
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
swat77244442swat
sway107128232sway
syn67024122syn
ta211662452_ta
tea37353322tea
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
the67436052the
tho67433962tho
thy97022912thy
twa67721642twa
uh57429852uh_
uta37425582uta
via65636242via
wham125321692wham
whap125119642whap
what105434072what
who95526772who
whoa106615202whoa
why126920012why
wisha114910852wisha
ya510251502_ya
yah99046352yah
yea66445752yea
za1114939202_za
zoa128529992zoa

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140843360.32643202.5
3Display Results3363360.0635333.3
 (SQL Overall)1786913360.452395334.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.