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

186 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
shogs9531971(None) 
hogs87139661_hogs
shags95123861shags
shoes85429661shoes
shog86025141shog_
shogi95014011shogi
shogis103810941shogis
shoos84226361shoos
shops104222901shops
shots84730851shots
shows115324581shows
slogs64521841slogs
smogs85112161smogs
snogs66017491snogs
biogs85016112biogs
blogs85319232blogs
bogs75742752_bogs
chops125019872chops
chows135618202chows
chugs115511942chugs
clogs85519552clogs
cogs77340032_cogs
cohogs125810272cohogs
dhows125911222dhows
dogs66440152_dogs
flogs95919962flogs
fogs87035002_fogs
frogs96220772frogs
grogs76319412grogs
hags86740842_hags
hobs97038982_hobs
hods87239862_hods
hoes75755732_hoes
hog78049062_hog_
hogg96617532_hogg
hoggs107212462_hoggs
hols76946292_hols
hongs95126202_hongs
hons77350782_hons
hops97942632_hops
hos68364192_ho_s
hots78349332_hots
hows106345602_hows
hoys107733932_hoys
hugs86129752_hugs
jogs127129332_jogs
logs57343112_logs
mhos95517772mho_s
mogs75439332_mogs
nogs56534612_nogs
phons105221142phons
phots105418502phots
progs86624152progs
rhos76319062rho_s
sagos66123872sagos
sags55948402s_ags
scags85520972scags
scops95820192scops
scots74025912scots
scows106617802scows
segos64919482segos
segs54933882s_egs
shads95124482shads
shag86430562shag_
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shays116021432shays
sheas86331792sheas
sheds96122702sheds
sheols94614162sheols
shes75734352sh_es
shews115924712shews
shies86136552shies
shims104422552shims
shins85131042shins
ships105123772ships
shits84731172shits
shivs115018802shivs
shmoes114612102shmoes
shoal83920272shoal
shoals94215792shoals
shoat85633952shoat
shoats94117082shoats
shock144917032shock
shocks154414582shocks
shod86225062sho_d
shoe75933442sho_e
shoed95723012shoed
shoer84722162shoer
shoers94518332shoers
shogun1045712shogun
shoguns1134422shoguns
shoji15419962shoji
shojis16348492shojis
shone83725982shone
shoo75929892sho_o
shook124920162shook
shooks134515632shooks
shool84523152shool
shools94919012shools
shoon84022012shoon
shoot84235912shoot
shoots94619362shoots
shop95629842sho_p
shore85432652shore
shores94830412shores
shorl84720252shorl
shorls94516202shorls
shorn85722182shorn
short85040532short
shorts95321742shorts
shot76150262sho_t
shote85526102shote
shotes95321912shotes
shott85332192shott
shotts93614702shotts
shout85433172shout
shouts94017722shouts
shove114421042shove
shoves124919422shoves
show106229192sho_w
shown115216482shown
showy145714012showy
shoyu1138912shoyu
shoyus1266002shoyus
shris84221452shris
shrugs10469162shrugs
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
shwas116415102shwas
sings65532702sings
skags104316072skags
skegs105011232skegs
slags66525902slags
slobs74419872slobs
sloes54728872sloes
slog56728272slog_
slops75026012slops
slots54830532slots
slows85323462slows
slugs64618562slugs
smog76317412smog_
snags64421312snags
snobs74716152snobs
snog55623632snog_
snots55225122snots
snows84719892snows
snugs64913022snugs
sobs64941752s_obs
sods54940212s_ods
sols45448162s_ols
soms66239372s_oms
songs67725552songs
sons46049552s_ons
sooks94425452sooks
soots55536212soots
sops65244562s_ops
sos37761602s_o_s
sots45552452s_ots
sous46947212s_ous
sows75342492s_ows
soys75233932s_oys
spots74424112spots
stags66226742stags
stoas55126022stoas
stobs75718232stobs
stogy95414082stogy
stops74827282stops
stoss54316342stoss
stots54828552stots
stows86622702stows
swags94921252swags
swigs96213662swigs
swobs104910892swobs
swops105913972swops
swots85518432swots
thongs104611192thongs
thous86017262thous
thugs95611992thugs
togs57242432_togs
trogs67022602trogs
whigs125612642whigs
whops135013932whops
wogs86531402_wogs

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 Filter178691538000.330541487.9
2DLD Change Limit538001861.57634137.1
3Display Results1861860.0503720.0
 (SQL Overall)1786911861.95691355.3
 
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.