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

112 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
stunk9461629(None) 
skunk85011761skunk
slunk95016301slunk
spunk114513401spunk
stank95823301stank
stink95122501stink
stuck114515771stuck
stun45623451stun_
stung65417151stung
stuns54719491stuns
stunt55328171stunt
sunk85031811s_unk
bunk105731352_bunk
chunk144812382chunk
clunk114215082clunk
drunk10549842drunk
dunk96228572_dunk
flunk125014382flunk
funk115825622_funk
gunk95423572_gunk
hunk116029542_hunk
junk155121032_junk
lunk86030722_lunk
plunk114514402plunk
punk105729972_punk
sank85236832s_ank
sauna54117552sauna
sculk115112462sculk
shank125422192shank
shrunk13357062shrunk
shuck144314532shuck
shun75122772shun_
shuns85018142shuns
shunt85226512shunt
sink86640142s_ink
skank84415582skank
skink85916852skink
skulk8479622skulk
skunks9468162skunks
skunky12436162skunky
slank95822772slank
slink95422912slink
slung65117832slung
snuck114411912snuck
souk86127172sou_k
sound64420022sound
spank115919572spank
spun66221462spun_
spunks12349332spunks
spunky15427162spunky
stack114421692stack
stalk94518002stalk
stand65923282stand
stane55933002stane
stang66424692stang
stanks104917702stanks
stark95425622stark
steak95219802steak
steek95418002steek
steno54716862steno
stent55634512stent
stick115121562stick
sting65330242sting
stinko10499392stinko
stinks105616832stinks
stinky134611072stinky
stint57037662stint
stirk95717412stirk
stock114417562stock
stone55431182stone
stony85818642stony
stook95218212stook
stork96819692stork
stound7399902stound
struck12489262struck
strung75213022strung
strunt64918912strunt
stub66221842stu_b
stubs75016072stubs
stud56220092stu_d
studs64415872studs
study94411792study
stuff113817052stuff
stull54916272stull
stum65526022stu_m
stump94616462stump
stums75320082stums
stunts65615252stunts
stupa74112312stupa
stupe75217752stupe
sturt56028962sturt
suck106131732s_uck
suk75632972s_u_k
sulk85326652s_ulk
sun37149032s_un_
sung55832172s_ung
sunn45423592s_unn
suns45841902s_uns
swank125318232swank
swink125116352swink
swung95610562swung
tank85134032_tank
thunk124911852thunk
trunk94713042trunk
tuck104626572_tuck
tun35845192_tun_
tuna45127842_tuna
tune45635862_tune
tung55328172_tung
tuns45138662_tuns
turk86125862_turk
tusk85621632_tusk

Search took 8 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 Filter178691538001.016175877.0
2DLD Change Limit538001126.3938415.5
3Display Results1121120.0303733.3
 (SQL Overall)1786911127.43924020.8
 
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.