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

181 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
shuns8501814(None) 
huns76136931_huns
shins85131041shins
shuls85319711shuls
shun75122771shun_
shunt85226511shunt
shunts95712021shunts
shuts85622481shuts
stuns54719491stuns
suns45841901s_uns
bhuts105812952bhuts
buns66243722_buns
chins105631462chins
chubs125412622chubs
chugs115511942chugs
chums125015832chums
chunk144812382chunk
chunks154210332chunks
churns114910232churns
duns55140432_duns
fauns84516752fauns
funs75235732_funs
guns55533482_guns
hens75642572_hens
hins76447992_hins
hons77350782_hons
hubs96027142_hubs
hues75235232_hues
hugs86129752_hugs
hums96831422_hums
hun65844712_hun_
hung86126352_hung
hunh106323732_hunh
hunk116029542_hunk
hunks125321452_hunks
hunt76445492_hunt
hunts86826172_hunts
huts76737442_huts
khans124615172khans
muns65535922_muns
nouns56717312nouns
nuns45228232_nuns
phons105221142phons
phuts104613502phuts
puns66641482_puns
rhus75114052rhu_s
runs46438082_runs
sains55639972sains
sans45153362s_ans
sauls55128122sauls
sauna54117552sauna
saunas63915432saunas
scans74625102scans
schuls11299852schuls
schuss11186732schuss
scuds85116242scuds
scums95017422scums
scups95316652scups
scuts74522522scuts
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shank125422192shank
shanks135315582shanks
sharns95516982sharns
shauls94913112shauls
shaws116226262shaws
shays116021432shays
sheas86331792sheas
sheds96122702sheds
sheens95116992sheens
shend94719972shend
shends105313772shends
shent85933502shent
shes75734352sh_es
shews115924712shews
shies86136552shies
shims104422552shims
shin75634312shin_
shine85533092shine
shines95028912shines
shiny115122142shiny
ships105123772ships
shits84731172shits
shivs115018802shivs
shlubs11386732shlubs
shoes85429662shoes
shogs95319712shogs
shoguns1134422shoguns
shone83725982shone
shoos84226362shoos
shops104222902shops
shots84730852shots
shouts94017722shouts
shows115324582shows
shris84221452shris
shrubs11409212shrubs
shrugs10469162shrugs
shrunk13357062shrunk
shuck144314532shuck
shucks154010412shucks
shul75823152shu_l
shuln84713112shuln
shush113812542shush
shut76137592shu_t
shute84520352shute
shutes93518222shutes
shwas116415102shwas
signs65516322signs
sins46755272s_ins
sinus55523852sinus
skins94723462skins
skuas95611732skuas
skunk85011762skunk
skunks9468162skunks
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slung65117832slung
slunk95016302slunk
slurs54123372slurs
sluts54523982sluts
smuts75415712smuts
snubs75412552snubs
snugs64913022snugs
sons46049552s_ons
sorns55028422sorns
souks94820522souks
souls55127362souls
sound64420022sound
sounds74616182sounds
soups75322942soups
sours55230502sours
sous46947212sou_s
spans74528732spans
spins75327982spins
spuds85113672spuds
spues75025382spues
spun66221462spun_
spunk114513402spunk
spunks12349332spunks
spurns84811382spurns
spurs74621522spurs
stubs75016072stubs
studs64415872studs
stums75320082stums
stun45623452stun_
stung65417152stung
stunk94616292stunk
stunt55328172stunt
stunts65615252stunts
subs66037122s_ubs
suds56135292s_uds
sues46247652s_ues
suks85927122s_uks
sums65837582s_ums
sun37149032s_un_
sung55832172s_ung
sunk85031812s_unk
sunn45423592s_unn
sunns55017352sunns
sups64834432s_ups
suqs134319652s_uqs
suss45229302s_uss
swans84625012swans
swouns9358242swouns
swung95610562swung
thens85921832thens
thins85826332thins
thuds95110132thuds
thugs95611992thugs
thunk124911852thunk
thunks13459032thunks
thus76721472thu_s
tuns45138662_tuns
uns35936762__uns
whens114618762whens
whins114922332whins
whups134210002whups

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.313570897.8
2DLD Change Limit538001811.62633087.3
3Display Results1811810.0463934.8
 (SQL Overall)1786911811.98590020.7
 
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.