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

275 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
sham9643635(None) 
cham115532311cham
ham86363281_ham
scam85932351scam
seam66645971seam
sha69837781sha_
shad86230911shad
shag86430561shag
shah105627781shah
shame105726701shame
shams105829411shams
shat76456591shat
shaw108132551shaw
shawm135316141shawm
shay107133341shay
shim95827841shim
slam67737971slam
spam85930041spam
swam96329981swam
wham125321691wham
aha611246642aha_
ahem97225362ahem
am411875562__am
ashram1139052ashram
bam78560142_bam
beam86939232beam
blam86131702blam
cam78058982_cam
chad105525502chad
chai95929902chai
champ145017962champ
chams126028502chams
chao95727312chao
chap114928492chap
char95132152char
charm126124662charm
chasm125518792chasm
chat95546132chat
chaw126224632chaw
chay124924872chay
chum116318002chum
clam86332292clam
cram85635492cram
dam67457042_dam
dhak125512032dhak
dhal86719282dhal
dram75832002dram
exam132514622exam
flam96333292flam
foam97127172foam
gam67060062_gam
ghat86435282ghat
glam76529342glam
gram77034582gram
ha510259942_ha_
had77658762_had
hae67364002_hae
haem95730982_haem
hag77255742_hag
hah910655222_hah
haj138140602_haj
halm95834972_halm
hame97043132_hame
hams96446132_hams
hao67251122_hao
hap87360052_hap
harm95637792_harm
has67372652_has
hat67289962_hat
haw97153272_haw
hay97358772_hay
hem86148732_hem
him86247652_him
hm78126732_h_m
hmm106218992_hmm
hum85542932_hum
ihram10310182ihram
imam81718332imam
jam126942522_jam
khaf145319602khaf
khan115819142khan
khat116730722khat
lam57666712_lam
loam65630482loam
nam55953392_nam
ogam75120032ogam
ogham1138252ogham
ohm86523012oh_m
pam77858392_pam
phat95837862phat
pram85733492pram
pshaw13447512pshaw
ram56867272_ram
ream65841612ream
roam67132412roam
sab56563202s_ab
sac57452862s_ac
sad47459202s_ad
sae38365182s_ae
sag46163402s_ag
sal36462882s_al
same65245642s_ame
samp85733592s_amp
sap56463232s_ap
sat36288482s_at
sau36356572s_au
saw68255352s_aw
sax107447642s_ax
say67264762s_ay
scab85926712scab
scad75725762scad
scag76626892scag
scamp115717312scamp
scams94423972scams
scan65530452scan
scar66434202scar
scat65848372scat
schav1338312schav
scram910621612scram
scum85924522scum
sea36161292sea_
seal45654372seal
seams75731662seams
seamy105921272seamy
sear47353842sear
seas45755272seas
seat47575562seat
seem65438562seem
sh56828522sh__
shack145321752shack
shade95125582shade
shads95124482shads
shady125416512shady
shaft115725252shaft
shags95123862shags
shahs115919512shahs
shake124726402shake
shako125516082shako
shaky154616842shaky
shale85332832shale
shall85024052shall
shalom11810912shalom
shalt85534482shalt
shaly114322862shaly
shaman113314272shaman
shamas113717932shamas
shamed125120212shamed
shames114726222shames
shammy16388502shammy
shamos114216982shamos
shamoy14379912shamoy
shamus114112812shamus
shank125422192shank
shape105125112shape
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shaul85418102shaul
shave114425892shave
shawl116217572shawl
shawms14579562shawms
shawn116417612shawn
shaws116226262shaws
shays116021432shays
shazam2046602shazam
she66837692sh_e
shea76031572shea
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
shed86536152shed
shes75734352shes
shew108030762shew
shh97121072sh_h
shims104422542shims
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shmo95318092shmo
shoal83920262shoal
shoat85633942shoat
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
shri76021692shri
shul75823152shul
shun75122772shun
shut76137582shut
shwa106014962shwa
shwas116415102shwas
shy96728192sh_y
sial45938832sial
sim56553132s_im
sima64730782sima
ska76925862ska_
skag96321512skag
skas85325712skas
skat87037892skat
skim105322492skim
slab67133762slab
slag55934352slag
slams74927902slams
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
slim66631952slim
slum65430512slum
smarm95517602smarm
snag55827872snag
snap65727032snap
snaw78923072snaw
soak87227662soak
soap65831132soap
soar46838672soar
som59153802s_om
soma65635292soma
spa55730812spa_
spae65034322spae
spams94922192spams
span65234662span
spar65433302spar
spas67036722spas
spasm94514172spasm
spat66548522spat
spay96631662spay
spaz155626162spaz
stab67329932stab
stag57332002stag
stamp95217362stamp
star48037762star
stat47352692stat
staw78627692staw
stay78333722stay
steam76322922steam
stem610628242stem
stum65526012stum
sum56346012s_um
swab96825312swab
swag87526732swag
swami105614522swami
swamp125015322swamp
swamy136714402swamy
swan76631312swan
swap95925432swap
swarm106218832swarm
swat77244442swat
sway107128232sway
swim96221392swim
swum96416822swum
tam58663422_tam
team66238652team
thae76825562thae
than76128772than
tharm105916642tharm
that75639322that
thaw107521312thaw
them97427042them
tram67034552tram
wha96422072wha_
whamo135511262whamo
whams135515642whams
whap125119642whap
what105434072what
whim126220522whim
whom127018172whom
yam87448992_yam

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.0762351197.4
2DLD Change Limit298722750.93631914.5
3Display Results2752750.0634365.1
 (SQL Overall)1786912751.075166224.2
 
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.