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 “shogun” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

243 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
shogun104571(None) 
shoguns1134421shoguns
shotgun1143001shotgun
hogan97817702_hogan
progun968782progun
shog86025142shog__
shogi95014012shog_i
shogis103810942shogis
shogs95319712shog_s
shogunal1242382shogunal
shoon84022012sho_on
shoran94016042shoran
shorn85722182sho_rn
shotguns1242312shotguns
shout85433172sho_ut
shown115216482sho_wn
shoyu1138912shoyu_
shoyus1266002shoyus
shun75122772sh__un
slogan7539222slogan
swoun84811492swo_un
begun85113443_begun
biogen9310253biogen
blowgun1342653blowgun
bogan87519003_bogan
bogus85616473_bogus
bosun75113593_bosun
brogan9311043brogan
brogue94211033brogue
chon96627793cho__n
chopin132712193chopin
chorus115014773chorus
chosen116014133chosen
chough15699243chough
cogon89120903_cogon
drogue8938333drogue
exogen1436513exogen
ghoul959053gho_ul
gun47240803___gun
hocus104715203_hocus
hog78049063_hog__
hogans105914313_hogans
hogg96617533_hog_g
hoggs107212463_hoggs
hognut1039413_hognut
hogs87139663_hog_s
hokum1436773_hokum
hon67759383_ho__n
honan85319773_honan
horn76735613_ho_rn
hosen85623883_hosen
hound95016483_ho_und
hour75827313_ho_ur
hun65844713_h__un
isogon7227543isogon
khoum1476643kho_um
korun9411923_korun
logan68123283_logan
login66025003_login
logon615922313_logon
mogul8310213_mogul
noun45724183_no_un
outgun7349643outgun
phon95925383pho__n
phonon114012033phonon
photon1111514833photon
pishogue1442833pishogue
popgun1145733popgun
rogue66417533_rogue
sagum8512873s_agum
scorn75817453sco_rn
scour75315533sco_ur
scout75031453sco_ut
segue6314413s_egue
shaduf1337063shaduf
shag86430563shag__
shaggy14478043shaggy
shags95123863shag_s
shairn9269063shairn
shaken134113613shaken
shaman113314283shaman
shamus114112813shamus
shapen114414653shapen
sharn84823703sh_arn
shaugh13287433shaugh
shaul85418103sh_aul
shaven124213303shaven
shawn116417613sh_awn
sheen85023313sh_een
sheugh13295883sheugh
shewn115715703sh_ewn
shin75634313sh__in
shlub105411743sh_lub
shoal83920273sho_al
shoals94215793shoals
shoaly124010773shoaly
shoat85633953sho_at
shoats94117083shoats
shock144917033sho_ck
shocks154414583shocks
shod86225063sho__d
shodden12265763shodden
shoddy1434543shoddy
shoe75933443sho__e
shoed95723013sho_ed
shoeing113211883shoeing
shoer84722163sho_er
shoers94518333shoers
shoes85429663sho_es
shofar1236313shofar
shogged13397963shogged
shogging14308023shogging
shogunate1342853shogunate
shoji15419963sho_ji
shojis16348493shojis
sholom11910113sholom
shone83725983sho_ne
shoo75929893sho__o
shooed103916083shooed
shooing112112913shooing
shook124920163sho_ok
shooks134515633shooks
shool84523153sho_ol
shools94919013shools
shoos84226363sho_os
shoot84235913sho_ot
shoots94619363shoots
shop95629843sho__p
shopman14247263shopman
shopmen14277203shopmen
shoppe133110323shoppe
shops104222903sho_ps
shorans102812413shorans
shore85432653sho_re
shored105723653shored
shores94830413shores
shoring112820073shoring
shorl84720253sho_rl
shorls94516203shorls
short85040533sho_rt
shorten103511413shorten
shorts95321743shorts
shorty124313203shorty
shot76150263sho__t
shote85526103sho_te
shotes95321913shotes
shots84730853sho_ts
shott85332193sho_tt
shotten10288463shotten
shotts93614703shotts
should1038033should
shouts94017723shouts
shove114421043sho_ve
shoved134214283shoved
shovel124611323shovel
shover124515993shover
shoves124919423shoves
shoving142910643shoving
show106229193sho__w
showed135016973showed
shower124315113shower
showing143814663showing
showman15257293showman
showmen15227173showmen
shows115324583sho_ws
showy145714013sho_wy
shroud1038773shroud
shrub104814893sh_rub
shrug94512513sh_rug
shrugs10469163shrugs
shrunk13357063sh_runk
shul75823153sh__ul
shuln84713113sh_uln
shuns85018143sh__uns
shunt85226513sh__unt
shut76137593sh__ut
sign55523053s_ig_n
slog56728273slog__
slogans8407983slogans
slogs64521843slog_s
slough10539233slough
sloven9389633sloven
smog76317413smog__
smoggy1354283smoggy
smogs85112163smog_s
snog55623633snog__
snogs66017493snog_s
snout54530633sno_ut
soggy105413903s_oggy
solan55328153s_olan
solon55026133s_olon
solum74717613s_olum
solus54726983s_olus
soman75024903s_oman
son37761953s_o__n
soon46240503s_o_on
sorn46641063s_o_rn
sorus54527583s_orus
sou37853693s_o_u_
sough95320463s_ough
souk86127173s_o_uk
soul46435713s_o_ul
sound64420023s_o_und
soup66232913s_o_up
sour45935893s_o_ur
sous46947213s_o_us
sown75127453s_o_wn
soyuz1748853s_oyuz
sozin14514543s_ozin
spoken124610003spoken
spongin1036373spongin
spoon74719443spo_on
spout75029633spo_ut
spun66221463s__pun
stogey105811543stogey
stogie7311323stogie
stogy95414083stog_y
stolen64315063stolen
stolon64112073stolon
stotin63215063stotin
stound7399903sto_und
stoup75517073sto_up
stour54916743sto_ur
stout57434053sto_ut
stun45623453s__tun
subgum1136133subgum
sun37149033s___un
swoon85014783swo_on
sworn86115313swo_rn
swound10377633swo_und
swouns9358243swo_uns
thegn95810903theg_n
thorn85318703tho_rn
thoron94713903thoron
thou76722213tho_u_
though139410773though
thous86017263tho_us
togue64816303_togue
trogon73611753trogon
vodun937223_vodun
vogue95613043_vogue
wangun1037103wangun
yogin98317743_yogin

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162435.20321663.7
3Display Results2432430.0763197.4
 (SQL Overall)1786912435.65231615.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.