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

149 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
stink9512250(None) 
sink86640141s_ink
skink85916851skink
slink95422911slink
stank95823301stank
stick115121561stick
sting65330241sting
stinko10499391stinko
stinks105616831stinks
stinky134611071stinky
stint57037661stint
stirk95717411stirk
stunk94616291stunk
swink125116351swink
blink115720142blink
boink115516332boink
brink116122002brink
chink145321592chink
clink115320042clink
dink97137802_dink
drink106816382drink
fink117532122_fink
gink97129522_gink
ink76433632__ink
jink156227202_jink
kink76034402_kink
link86943442_link
mink106636532_mink
oink85429342_oink
pink107039382_pink
plink115219122plink
prink114719672prink
reink95518092reink
rink87736992_rink
sain45551292sain_
sains55639972sains
saint55147072saint
sank85236832s_ank
satin55935222satin_
sating74735452sating
satins64930482satins
satiny93817982satiny
seine55732872seine
shank125422192shank
shin75634312shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shirk124817842shirk
shrink134511732shrink
shtick15308022shtick
shtik123210962shti_k
sick106435572s_ick
silk85529322s_ilk
sin36265892s_in_
sine46560622s_ine
sing57544172s_ing
sinh76238042s_inh
sinks95529182s_inks
sins46755272s_ins
siting74126622siting
skank84415582skank
skin85927532skin_
skinks94511652skinks
skins94723462skins
skint95629222skint
skunk85011762skunk
slank95822772slank
slick115520522slick
sling66028802sling
slinks104315152slinks
slinky13399102slinky
slunk95016302slunk
smirk116612752smirk
snick114416012snick
spank115919572spank
spick134519072spick
spik105419712spi_k
spin66231302spin_
spine76534422spine
spins75327982spins
spiny104921302spiny
spunk114513402spunk
stack114421692stack
stain55727942stain_
stains64923652stains
stalk94518002stalk
stand65923282stand
stane55933002stane
stang66424682stang
stanks104917702stanks
stark95425622stark
steak95219802steak
steek95418002steek
stein54620542stein_
steins64818342steins
steno54716862steno
stent55634512stent
stich104117922stich
sticks125118612sticks
sticky154711342sticky
stied65723032stied
sties55132982sties
stiff114219242stiff
stile54931572stile
still54922082still
stilt54831982stilt
stime76521802stime
stimy105114742stimy
stingo74212162stingo
stings76220182stings
stingy105213202stingy
stinker113313312stinker
stints65119762stints
stipe76523372stipe
stir45723252sti_r
stirks104914242stirks
stirp76815502stirp
stirs55921622stirs
stock114417562stock
stone55431182stone
stony85818642stony
stook95218212stook
stork96819692stork
strick124813202strick
string75327562string
stuck114515772stuck
stun45623452stun_
stung65417152stung
stuns54719492stuns
stunt55328172stunt
stying105414572stying
suing65026362suing
suint55638182suint
sunk85031812s_unk
swank125318232swank
swine85625302swine
swing96124842swing
swinks134610652swinks
tank85134022_tank
think125018802think
tick106231222_tick
tin36362172_tin_
tine45855132_tine
ting56139902_ting
tins45251302_tins
tint46758862_tint
tiny76134632_tiny
wink116435022_wink

Search took 3 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 Limit538001491.71631352.0
3Display Results1491490.0334515.2
 (SQL Overall)1786911492.06286659.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.