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

284 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
shad8623091(None) 
chad105525501chad
had77658761_had
sad47459201s_ad
scad75725761scad
sha69837781sha_
shade95125581shade
shads95124481shads
shady125416511shady
shag86430561shag
shah105627781shah
sham96436351sham
shard96125961shard
shat76456591shat
shaw108132551shaw
shay107133341shay
shed86536151shed
shod86225051shod
ad311975032__ad
aha611246642aha_
ahead96817052ahead
ahed89536252ahed
ashed97829772ashed
bad67763152_bad
bead75937922bead
brad75234342brad
cad67456362_cad
chads116122232chads
chai95929902chai
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chard116124742chard
chat95546132chat
chaw126224632chaw
chay124924872chay
chid106626402chid
clad76225822clad
dad58456162_dad
dead65434242dead
dhak125512032dhak
dhal86719282dhal
duad66521412duad
dyad96415452dyad
egad64215412egad
fad77452412_fad
gad57556652_gad
ghat86435282ghat
glad65624012glad
goad66830982goad
grad66829862grad
ha510259942_ha_
hade85440192_hade
hadj155818672_hadj
hae67364002_hae
haed86338582_haed
hag77255742_hag
hah910655222_hah
haj138140602_haj
ham86363282_ham
hand86833702_hand
hao67251122_hao
hap87360052_hap
hard85443502_hard
has67372652_has
hat67289962_hat
haw97153272_haw
hay97358772_hay
head87137172head
hid76248362_hid
hod76852462_hod
jehad1637682jehad
jihad1635912jihad
khadi1367602khadi
khaf145319602khaf
khan115819142khan
khat116730722khat
lad48165702_lad
lead56038852lead
load56730602load
mad68958702_mad
mead75531602mead
ohed87825182ohed
orad56031692orad
pad68057322_pad
phat95837862phat
pshaw13447512pshaw
quad144618702quad
rad47662002_rad
read55942532read
road56332112road
sab56563202s_ab
sac57452862s_ac
sade55544472s_ade
sadi55834642s_adi
sae38365182s_ae
sag46163402s_ag
said55742112said
sal36462882s_al
salad65321832salad
sand55338462sand
sap56463232s_ap
sard55344242sard
sat36288482s_at
sau36356572s_au
saw68255352s_aw
sax107447642s_ax
say67264762s_ay
scab85926712scab
scads85419952scads
scag76626892scag
scald84818122scald
scam85932352scam
scan65530452scan
scar66434202scar
scat65848372scat
schav1338312schav
scud76221282scud
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
seed55549482seed
send55237292send
sh56828522sh__
shack145321752shack
shaded114518872shaded
shader104218762shader
shades105924532shades
shadow1337252shadow
shaduf1337062shaduf
shaft115725252shaft
shags95123862shags
shahs115919512shahs
shaird10288702shaird
shake124726402shake
shako125516082shako
shaky154616842shaky
shale85332832shale
shaled105023952shaled
shall85024052shall
shalt85534482shalt
shaly114322862shaly
shame105726702shame
shamed125120212shamed
shams105829412shams
shandy134710032shandy
shank125422192shank
shape105125112shape
shaped125020102shaped
shards104319172shards
share86437082share
shared105829062shared
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shaul85418102shaul
shave114425892shave
shaved135118382shaved
shawed134817232shawed
shawl116217572shawl
shawm135316142shawm
shawn116417612shawn
shaws116226262shaws
shays116021432shays
she66837692sh_e
shea76031572shea
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
sheds96122702sheds
shend94719972shend
sherd96321152sherd
shes75734352shes
shew108030762shew
shh97121072sh_h
shied96125492shied
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shmo95318092shmo
shoal83920262shoal
shoat85633942shoat
shoe75933432shoe
shoed95723002shoed
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
shred98125612shred
shri76021692shri
shul75823152shul
shun75122772shun
shut76137582shut
shwa106014962shwa
shwas116415102shwas
shy96728192sh_y
sial45938832sial
sild55030582sild
ska76925862ska_
skag96321512skag
skald104210172skald
skas85325712skas
skat87037892skat
skid95720912skid
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slid55828982slid
snag55827872snag
snap65727032snap
snaw78923072snaw
sned56026052sned
soak87227662soak
soap65831132soap
soar46838672soar
sod46053702s_od
soda56329382soda
sold54837412sold
sord56237202sord
spa55730812spa_
spade84423322spade
spado83713702spado
spae65034322spae
spaed85522272spaed
spam85930042spam
span65234662span
spar65433302spar
spas67036722spas
spat66548522spat
spay96631662spay
spaz155626162spaz
sped76031492sped
spud75818492spud
squad155110792squad
stab67329932stab
stade64825302stade
stag57332002stag
staid66722072staid
stand65923282stand
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
stead65520272stead
stud56220092stud
sudd64719772sudd
sued56537932sued
surd56433812surd
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
sward94221462sward
swat77244442swat
sway107128232sway
tad47959822_tad
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thud85613912thud
toad55830182toad
trad55630912trad
wad77053892_wad
wha96422072wha_
wham125321692wham
whap125119642whap
what105434072what
whid115418872whid
woad85523942woad

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.0802233637.5
2DLD Change Limit298722841.03029001.9
3Display Results2842840.0763736.8
 (SQL Overall)1786912841.186150666.9
 
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.