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

115 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
stunt5532817(None) 
shunt85226511shunt
stent55634511stent
stint57037661stint
strunt64918911strunt
stun45623451stun_
stung65417151stung
stunk94616291stunk
stuns54719491stuns
stunts65615251stunts
sturt56028961sturt
aunt46553652_aunt
blunt75525022blunt
brunt75728752brunt
bunt65850852_bunt
count74932052count
cunt66243672_cunt
daunt65929082daunt
dunt55746872_dunt
fount84727032fount
gaunt65430402gaunt
grunt65523542grunt
haunt85229132haunt
hunt76445492_hunt
jaunt125025272jaunt
lunt46148842_lunt
mount74128062mount
punt65747202_punt
runt46647992_runt
saint55147072saint
sault55834962sault
sauna54117552sauna
scant79735072scant
scent75831622scent
scut65835542scu_t
sent46963012s_ent
shent85933502shent
shun75122772shun_
shuns85018142shuns
shunts95712022shunts
shut76137592shu_t
skint95629222skint
skunk85011762skunk
slant55238702slant
slung65117832slung
slunk95016302slunk
slut45040592slu_t
smut66629782smu_t
sound64420022sound
spent75532832spent
spun66221462spun_
spunk114513402spunk
spurt77227982spurt
squat143720142squat
squint154214792squint
stand65923282stand
stane55933002stane
stang66424682stang
stank95823302stank
start55642312start
stat47352692st_at
steno54716862steno
stents65019452stents
stet45947322st_et
stilt54831982stilt
sting65330242sting
stink95122502stink
stints65119762stints
stoat57135952stoat
stone55431182stone
stony85818642stony
stopt76528352stopt
stot46347332st_ot
stott56929792stott
stound7399902stound
stout57434052stout
strung75213022strung
strunts7429542strunts
strut56030732strut
stub66221842stu_b
stubs75016072stubs
stuck114515772stuck
stud56220092stu_d
student848342student
studs64415872studs
study94411792study
stuff113817052stuff
stull54916272stull
stum65526022stu_m
stump94616462stump
stums75320082stums
stunted83010402stunted
stupa74112312stupa
stupe75217752stupe
sturts63915142sturts
suet46754822s_uet
suint55638182suint
suit45649872s_uit
sun37149032s_un_
sung55832172s_ung
sunk85031812s_unk
sunn45423592s_unn
suns45841902s_uns
swung95610562swung
taunt55532282taunt
tent46159862_tent
tint46758862_tint
tuft76929512_tuft
tun35845192_tun_
tuna45127842_tuna
tune45635862_tune
tung55328162_tung
tuns45138662_tuns
tut36758092_tu_t
vaunt85925312vaunt

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 Limit538001151.56334421.0
3Display Results1151150.0333484.8
 (SQL Overall)1786911151.90993604.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.