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

184 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
stuns5471949(None) 
shuns85018141shuns
stubs75016071stubs
studs64415871studs
stums75320081stums
stun45623451stun_
stung65417151stung
stunk94616291stunk
stunt55328171stunt
stunts65615251stunts
suns45841901s_uns
tuns45138661_tuns
buns66243722_buns
duns55140432_duns
etuis54013132etuis
fauns84516752fauns
funs75235732_funs
guns55533482_guns
huns76136932_huns
muns65535922_muns
nouns56717312nouns
nuns45228232_nuns
puns66641482_puns
runs46438082_runs
sains55639972sains
sans45153362s_ans
satins64930482satins
sauls55128122sauls
sauna54117552sauna
saunas63915432saunas
scans74625102scans
scuds85116242scuds
scums95017422scums
scups95316652scups
scuts74522522scuts
setons64620172setons
setups83910462setups
shins85131042shins
shuls85319712shuls
shun75122772shun_
shunt85226512shunt
shunts95712022shunts
shuts85622482shuts
signs65516322signs
sins46755272s_ins
sinus55523852sinus
situps8538782situps
situs55019232situ_s
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
stabs76221382stabs
stags66226742stags
stains64923652stains
stand65923282stand
stands75118052stands
stane55933002stane
stanes64933402stanes
stang66424682stang
stangs75018162stangs
stank95823302stank
stanks104917702stanks
stars55836572stars
stats55933362stats
stays86022022stays
steins64818342steins
stems75219952stems
steno54716862steno
stenos63915772stenos
stent55634512stent
stents65019452stents
steps76619882steps
sterns64616762sterns
stets55423912stets
stews85519142stews
sties55132982sties
sting65330242sting
stings76220182stings
stink95122502stink
stinks105616832stinks
stint57037662stint
stints65119762stints
stirs55921622stirs
stoas55126022stoas
stobs75718232stobs
stone55431182stone
stones65130032stones
stony85818642stony
stops74827282stops
stoss54316342stoss
stots54828552stots
stound7399902stound
stounds8377822stounds
stoups85313272stoups
stours65015632stours
stouts65019002stouts
stows86622702stows
strums84716452strums
strung75213022strung
strunt64918912strunt
strunts7429542strunts
struts65616802struts
stub66221842stu_b
stuck114515772stuck
stud56220092stu_d
study94411792study
stuff113817052stuff
stuffs123810222stuffs
stull54916272stull
stulls63912982stulls
stum65526022stu_m
stump94616462stump
stumps104912282stumps
stupa74112312stupa
stupas83910882stupas
stupe75217752stupe
stupes84116952stupes
sturt56028962sturt
sturts63915142sturts
styes86316522styes
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
tans46154822_tans
tens45647412_tens
tins45251302_tins
tons46553052_tons
tubs65430062_tubs
tugs56231672_tugs
tuis44829642_tuis
tun35845192_tun_
tuna45127842_tuna
tunas54224122_tunas
tune45635862_tune
tunes55332192_tunes
tung55328162_tung
tungs65520622_tungs
tups65628762_tups
turns55623242_turns
tuts45838452_tuts
uns35936762__uns

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 Limit538001841.56334421.0
3Display Results1841840.0603066.7
 (SQL Overall)1786911841.93692299.1
 
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.