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 “success” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

215 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
success114640(None) 
succuss1134991succuss
access1037682_access
duchess1335552duchess
soccers1138392soccers
succahs1435322succahs
succeed1235982succeed
succeeds1343692succeeds
successes1345642successes
successor1343062successor
succors1137412succors
suchness1335762suchness
suckers133717622suckers
suckless14288822suckless
sucres84218892sucre_s
sumless92611122sumless
sunless73013692sunless
unsuccess1341882unsuccess
abscess1133903abscess
ancress978613ancress
bocces123912023bocce_s
buckers153517453buckers
buckets153811693buckets
budless1038873budless
burgess10409343burgess
cess65326053___cess
chess105016923__chess
cress75022833__cress
duces86327473du_ce_s
duckers143214713duckers
ductless11196313ductless
dueness82310123dueness
dulcets1046283dulcets
dulness8307983dulness
dunces95215753dunce_s
dunness8298983dunness
duress74712063du_ress
excess1546053_excess
fuckers163611593fuckers
fucoses12148303fucoses
fucuses12158353fucuses
fulness10248963fulness
furless103210143furless
guess64213363gu__ess
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
hueless1058823hueless
juicers1636153juicers
juices1549423juice_s
kuchens1634713kuchens
luces75528433lu_ce_s
luckless14265893luckless
lucres84513303lucre_s
muches134718993muche_s
muchness1534073muchness
muckers153612803muckers
mucuses11148513mucuses
nonsuccess1461953nonsuccess
nucleus956573nucleus
ouches114322183ouche_s
ounces83617773ounce_s
precess11310863precess
process11310403process
puces94924633pu_ce_s
puckers153514673puckers
recces10614913recce_s
recess8314263_recess
ruches114819583ruche_s
runless72810423runless
sachems14348903sachems
sachets123914103sachets
sackers133820223sackers
sadness8310613sadness
saices84221803saice_s
sapless93313443sapless
saucers93712133saucers
sauces84919503sauce_s
sauciers1076733sauciers
sauciest10310983sauciest
sauciness1138043sauciness
schuss11186733s_chuss
screes85023973s_crees
screws115513893s_crews
scumless1254993scumless
scutes85219193scute_s
seccos1039923secc_os
secrets9311773secrets
seeress7311573seeress
sexless1467243sexless
shuckers17388133shuckers
shyness1344993shyness
sicced11489653sicce_d
sices75637273s_ice_s
sickees134514213sickees
sickens134411483sickens
sickest131813793sickest
sickness1437833sickness
sinless73014213sinless
slicers94114923slicers
slices84022853slice_s
sluices959073sluice_s
slyness1035263slyness
smugness1143813smugness
snubness1044373snubness
snugness934323snugness
soccer1038543socce_r
sockets134012983sockets
sockless14267793sockless
socles8418453socle_s
sonless72612613sonless
soulless8218763soulless
soupless10268463soupless
sources9312173source_s
sourness839543sourness
spacers113813873spacers
spaces104722633space_s
spicers113815553spicers
spices104326033spice_s
stress66616673s_tress
stuccoers1342563stuccoers
stuccoes1254273stuccoes
stuccos1153933stucc_os
suavest10310623suavest
subbass1138033subbass
subcell1146753subcell
subcells1246283subcells
subclass1246623subclass
subdebs1236483subdebs
subers85722643su_bers
sublets92616703sublets
submiss1138083submiss
subnets92512083subnets
subsets92813103subsets
subtest9513963subtest
subtests1037533subtests
succah1336643succ_ah
successful1752023successful
succession1454013succession
successive1753193successive
successors1453013successors
succor1036623succ_or
succorers13124203succorers
succory1444643succory
succoth1445093succoth
succour1144693succour
succours1244593succours
succuba1343443succuba
succubas1443853succubas
succubi1342883succubi
succubus1443033succubus
succumb1543283succumb
succumbs1642423succumbs
succussed1443393succussed
succusses1344423succusses
sucked134120493sucke_d
sucker124120663sucke_r
suckiest143314113suckiest
sucklers14379963sucklers
suckles134516743suckles
sucks114523073su_c_ks
sucrase9310343sucrase
sucrases10310253sucrases
sucre75019103sucre__
sucrose939313sucrose
sucroses1039943sucroses
suddens9308783suddens
sudsers83310423sudsers
sudses74114503sudse_s
sudsless944353sudsless
suedes73918113suede_s
suers55128483su__ers
sues46247653su__e_s
suets55126103su__ets
suffers133113543suffers
suggest9310863suggest
suggests1044713suggests
suiters73618883suiters
suites63727403suite_s
sulcus8410493sulc_us
sulkers113613343sulkers
summers113616503summers
sunders84120053sunders
sundews11398153sundews
sundress936983sundress
sunkets113511283sunkets
sunsets72911573sunsets
supers84622403su_pers
supes75628303su_pe_s
suppers113314703suppers
suppress1236443suppress
surcease1086883surcease
surceases1157473surceases
sureness8912903sureness
surest65026763su_rest
surfers103614133surfers
surgers83517483surgers
surges73924593surge_s
surpass938283surpass
surreys10489443surreys
surveys13357573surveys
suss45229303su___ss
susses64221053susse_s
sutlers73116973sutlers
suttees74114063suttees
sycees11409653s_ycees
syces106416463s_yce_s
sycoses1249133sycoses
tuckers134014353tuckers
tuckets134810333tuckets
tugless837383tugless
ulcers839383_ulcers
unless62413073_unless
useless7188423useless
yuccas13426553yucc_as

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272156.83019623.3
3Display Results2152150.0932311.8
 (SQL Overall)1786912157.34324334.9
 
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.