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

272 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
sting6533024(None) 
sating74735451sating
sing57544171s_ing
siting74126621siting
sling66028801sling
stang66424681stang
stingo74212161stingo
stings76220181stings
stingy105213201stingy
stink95122501stink
stint57037661stint
string75327561string
stung65417151stung
stying105414571stying
suing65026361suing
swing96124841swing
ting56139891_ting
acing87429152acing
acting95920982acting
aging77026352aging
ahing98928342ahing
anting75827022anting
aping87327232aping
ashing107824092ashing
asking116017232asking
awing96827322awing
axing138521372axing
basting104227202basting
bating95132252bating
being84920502being
besting104923922besting
biting95321822biting
boing84725552boing
bring85528502bring
busting104221792busting
casting104628342casting
citing94220182citing
cling86424672cling
costing104323022costing
coting94629252coting
cuing85420192cuing
dating85326482dating
ding66940952_ding
doing74923582doing
doting84821912doting
dusting93618992dusting
dying105316032dying
easting84924302easting
eating75134402eating
eking106614982eking
exing136016812exing
eying96117922eying
fasting114522832fasting
fating105328672fating
feting104417792feting
fisting113818122fisting
fling97023512fling
gasting95022762gasting
gating84826952gating
going75218492going
gusting93917162gusting
hasting114725192hasting
hating104929712hating
histing113720372histing
hosting114318382hosting
hying126514742hying
icing86017752icing
iring66025422iring
isling71213882isling
jesting154317712jesting
justing153615162justing
king95933652_king
kiting114117092kiting
lasting84725242lasting
ling57447962_ling
listing84020592listing
lusting83619322lusting
luting75221752luting
lying95717452lying
masting104325822masting
mating94832912mating
meting94320592meting
misting103623382misting
musting103221072musting
muting93921522muting
nesting84320442nesting
noting74120152noting
ohing96018802ohing
oping86322412oping
opting94514402opting
ousting84021352ousting
outing74128152outing
owing96222722owing
pasting103826552pasting
piing85218832piing
ping75943592_ping
posting105622242posting
rating74938702rating
resting85031182resting
ring56541152_ring
ruing67221052ruing
rusting83821262rusting
sain45551292sain_
sains55639972sains
saint55147072saint
salting84120792salting
sang55441222s_ang
saning75127642saning
satang75711562satang
satin55935212satin_
satins64930482satins
satiny93817982satiny
saving104724512saving
sawing104323812sawing
saying104325542saying
seating84130682seating
seeing74222142seeing
seine55732872seine
sering74731812sering
setting83621392setting
sewing103819622sewing
sexing144313892sexing
shin75634302shin_
shine85533092shine
shins85131042shins
shiny115122142shiny
shuting113212042shuting
shying134211842shying
siding83822132siding
sifting113014592sifting
sign55523052s_ign
silting83320482silting
sin36265892s_in_
sine46560622s_ine
singe65731132s_inge
sings65532702s_ings
sinh76238042s_inh
sink86640142s_ink
sins46755272s_ins
siping94220632siping
siring75128312siring
sitting83519632sitting
sizing163616442sizing
skating123613842skating
skiing113610192skiing
skin85927522skin_
skink85916852skink
skins94723462skins
skint95629222skint
skiting123812492skiting
skying14399982skying
slang66324022slang
slating83724652slating
slings74618012slings
slink95422912slink
sluing74315882sluing
slung65117832slung
smiting103014442smiting
soling74226822soling
song55133672s_ong
sooting82820952sooting
soring74731882soring
sorting83221812sorting
sowing104222912sowing
spang84919732spang
spin66231302spin_
spine76534422spine
spins75327982spins
spiny104921302spiny
spiting103917622spiting
spring94526012spring
spuing94313362spuing
spying123913252spying
stag57332002st_ag
staging93818372staging
staig65519632staig
stain55727932stain_
stains64923652stains
staking123919802staking
staling83925422staling
stand65923282stand
stane55933002stane
stangs75018162stangs
staning83922242staning
stank95823302stank
staring84527052staring
stating83725162stating
staving113915702staving
staying114017322staying
stein54620532stein_
steins64818342steins
steno54716862steno
stent55634512stent
stewing113412492stewing
stich104117922stich
stick115121562stick
stied65723032stied
sties55132982sties
stiff114219242stiff
stile54931572stile
still54922072still
stilt54831982stilt
stime76521792stime
stimy105114732stimy
stinger84314682stinger
stingos8459442stingos
stinko10499392stinko
stinks105616832stinks
stinky134611072stinky
stints65119762stints
stipe76523372stipe
stir45723242sti_r
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
stoking123615592stoking
stone55431182stone
stoning83717442stoning
stony85818642stony
stoping103716622stoping
storing83921122storing
stowing113315132stowing
strang75718312strang
strings84617132strings
stringy114111072stringy
strong74914882strong
strung75213022strung
stun45623452stun_
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
styling112910652styling
suint55638182suint
suiting83419002suiting
sung55832172s_ung
swang95519722swang
swig85818022swi_g
swine85625302swine
swinge105614382swinge
swings104714452swings
swingy13489872swingy
swink125116352swink
swung95610562swung
tang56138662_tang
tasting84624212tasting
testing86021052testing
thing96622962thing
tin36362172_tin_
tine45855132_tine
tinge64626612_tinge
tings65329192_tings
tins45251302_tins
tint46758862_tint
tiny76134632_tiny
tong56434352_tong
toting74123792toting
tsking114210422tsking
tung55328162_tung
tying96019832tying
using66317962using
vesting114618682vesting
voting103916032voting
vying125111812vying
wasting114422842wasting
westing115020272westing
wing86339222_wing
wisting113519742wisting
witing103522822witing
wring95920712wring
wyting13277242wyting
zesting174515332zesting
zing145728612_zing

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.0901985455.6
2DLD Change Limit538002721.70331591.3
3Display Results2722720.0803400.0
 (SQL Overall)1786912721.87395403.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.