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

225 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
shah10562778(None) 
hah910655221_hah
sha69837781sha_
shad86230911shad
shag86430561shag
shahs115919511shahs
sham96436351sham
shat76456591shat
shaw108132551shaw
shay107133341shay
shh97121071sh_h
aah616252962_aah
ah513868792__ah
aha611246642aha_
amah98927482amah
ayah108022992ayah
bah87755352_bah
blah98625062blah
chad105525502chad
chai95929902chai
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
dah78148982_dah
dhak125512032dhak
dhal86719282dhal
ephah1337062ephah
ghat86435282ghat
ha510259942_ha_
had77658762_had
hae67364002_hae
hag77255742_hag
haha107821062_haha
hahs108333362_hahs
haj138140602_haj
ham86363282_ham
hao67251122_hao
hap87360052_hap
has67372652_has
hash106936502_hash
hat67289962_hat
hath105933912_hath
haw97153272_haw
hay97358772_hay
heh96039622_heh
huh96432012_huh
khaf145319602khaf
khan115819142khan
khaph17395962khaph
khat116730722khat
nah69847002_nah
odah87018932odah
opah96218402opah
pah88853592_pah
phat95837862phat
pshaw13447512pshaw
rah68052402_rah
sab56563202s_ab
sac57452862s_ac
sad47459202s_ad
sae38365182s_ae
sag46163402s_ag
sal36462882s_al
sap56463232s_ap
sash77235302sash
sat36288482s_at
sau36356572s_au
saw68255352s_aw
sax107447642s_ax
say67264762s_ay
scab85926712scab
scad75725762scad
scag76626892scag
scam85932352scam
scan65530452scan
scar66434202scar
scat65848372scat
schav1338312schav
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
selah8319612selah
sh56828522s__h
shack145321752shack
shade95125582shade
shads95124482shads
shady125416512shady
shaft115725252shaft
shags95123862shags
shake124726402shake
shako125516082shako
shaky154616842shaky
shale85332832shale
shall85024052shall
shalt85534482shalt
shaly114322862shaly
shame105726702shame
shams105829412shams
shank125422192shank
shape105125112shape
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shaugh13287432shaugh
shaul85418102shaul
shave114425892shave
shawl116217572shawl
shawm135316142shawm
shawn116417612shawn
shaws116226262shaws
shays116021432shays
she66837692sh_e
shea76031572shea
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
sheath12412882sheath
shed86536152shed
shes75734352shes
shew108030762shew
shibah14387462shibah
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shivah15488532shivah
shmo95318092shmo
shoal83920262shoal
shoat85633942shoat
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
shri76021692shri
shul75823152shul
shun75122772shun
shush113812542shush
shut76137582shut
shwa106014962shwa
shwas116415102shwas
shy96728192sh_y
sial45938832sial
sidh86222982sidh
sigh85625892sigh
sinh76238042sinh
sith75435152sith
ska76925862ska_
skag96321512skag
skas85325712skas
skat87037892skat
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slash84719682slash
slat46959022slat
slaw77930712slaw
slay76436382slay
smash104814432smash
snag55827872snag
snap65727032snap
snash84815672snash
snath86419802snath
snaw78923072snaw
soak87227662soak
soap65831132soap
soar46838672soar
soph97024202soph
soth75932512soth
spa55730812spa_
spae65034322spae
spahi10311142spahi
spam85930042spam
span65234662span
spar65433302spar
spas67036722spas
spat66548522spat
spay96631662spay
spaz155626162spaz
stab67329932stab
stag57332002stag
staph104314652staph
star48037762star
stash84916972stash
stat47352692stat
staw78627692staw
stay78333722stay
subah106015212subah
such96424812such
sugh86423442sugh
surah86823252surah
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
swash116316752swash
swat77244442swat
swath115920382swath
sway107128232sway
syph125413272syph
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
wha96422072wha_
wham125321692wham
whap125119642whap
what105434072what
yah99046352_yah
yeah106725412yeah

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 Limit298722250.92032469.6
3Display Results2252250.0464891.3
 (SQL Overall)1786912251.046170832.7
 
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.