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

226 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
sannup83656(None) 
sannop837371sannop
sannups934461sannups
annul55813382_annul
hangup1277292hangup
sannops936692sannops
santur6311272santur
sendup9106342sendup
standup1034352standup
stannum944642stannum
sunup7313052s_unup
ankus91410683_ankus
anna45529013_ann_a
annal56520763_annal
annas55824883_annas
annex12310883_annex
annoy869713_annoy
annual64710703_annual
annuli6459053_annuli
annuls64711733_annuls
anus47131113_a_nus
backup1646613backup
banned94721343banned
banner84421503banner
bannet84925333bannet
banns75321233bann_s
canful11610263canful
cangue91012443cangue
canna75919333cann_a
cannas84518403cannas
canned95022063canned
cannel84216403cannel
canner84625983canner
cannie83819363cannie
cannon84514443cannon
cannot83616773cannot
cannula937433cannula
canny105817693cann_y
cantus85117763cantus
catnap1098383catnap
catnip1097973catnip
catsup1036433catsup
disannul942833disannul
ennui537523_ennui
faceup1334893faceup
fanned104117473fanned
fanner94218183fanner
fanny114816043fann_y
fanum10313443fa_num
gangue81310573gangue
gannet74321853gannet
hangul1049213hangul
hangups1364813hangups
jaup135316423ja__up
kanzu1847593kanzu_
kanzus1944603kanzus
langue71012173langue
langur7109303langur
lanner64920603lanner
larrup835713larrup
layup1037723la_yup
lineup835983lineup
linkup1245123linkup
magnum1136733magnum
makeup1434863makeup
manful11610213manful
manna75522543mann_a
mannan85413623mannan
mannas85019803mannas
manned94418643manned
manner84020513manner
manque17259513manque
mantua84412023mantua
manus75924933ma_nus
markup1436903markup
nannie63713223nannie
nanny84813813nann_y
panful1179743panful
panne76623653pann_e
panned94123433panned
panner84224763panner
pannes85522853pannes
pinup9612883_pinup
sacbut10811943sacbut
sacque17107113sacque
sacrum103910143sacrum
sadhu9459963sadhu_
sadhus10298463sadhus
sagbut959753sagbut
sagum8512873sa_gum
sain45551293sain__
sained75424243sained
sains55639973sain_s
saint55147073sain_t
saints65122423saints
sajou12311693sajou_
sajous13310583sajous
salep77022953sa_lep
saloop84212583saloop
salp64534093sa__lp
sambur10469503sambur
samp85733593sa__mp
sancta839833sancta
sanctum1145293sanctum
sand55338473sa_n_d
sandal73317283sandal
sandbur10105353sandbur
sanded84920613sanded
sander74828533sander
sandhi1038193sandhi
sands65228583sa_nds
sandy94221133sa_ndy
sane45954343sa_n_e
saned65636273sa_ned
sanely93114613sanely
saner54334323sa_ner
sanes55649073sa_nes
sanest64426693sanest
sang55441233sa_n_g
sanga66023793sa_nga
sangar73617683sangar
sangas75222653sangas
sanger74524563sanger
sangh95517453sa_ngh
sanghs105312063sanghs
sanies63031953sanies
saning75127643saning
sanious7514103sanious
sanity9316203sanity
sanjak1735693sanjak
sank85236833sa_n_k
sans45153363sa_n_s
sansar63613393sansar
sansei63411903sansei
santir6315253santir
santo56227283sa_nto
santol64515243santol
santos64421833santos
santour737373santour
santurs7310763santurs
sap56463233sa___p
sapour83812373sapour
satrap86212553satrap
sau36356573sa__u_
saul45836523sa__ul
sauna54117553saun_a
saunas63915433saunas
savour94110703savour
sawn75428163sawn__
sawney12387603sawney
scaleup1134483scaleup
scanned104110893scanned
scanner94411813scanner
scaup95515993s_caup
scup84822383s__cup
sendups10115193sendups
senna54617983senn_a
sennas64214233sennas
sennet64224143sennet
sennit63117923sennit
sensum849353sensum
setup73915823s_etup
shakeup1632763shakeup
shanny124110093shann_y
shapeup1443293shapeup
sinful938803sinful
sinned73818413sinned
sinner64320603sinner
sinus55523853s_inus
sirup74014913s_irup
situp74414063s_itup
slipup1034503slipup
smashup1443453smashup
snafu8412143snafu_
snafus936743snafus
snap65727033s__nap
sneap75514823s_neap
snip66424653s__nip
snoop75317173s_noop
snout54530633s_nout
snub65320763s__nub
snug55218693s__nug
sonnet65923503sonnet
sonny85016103sonn_y
soup66232913s__oup
spanned104111223spanned
spanner94312563spanner
stackup1533743stackup
standups1143963standups
stannic936663stannic
stannous846443stannous
stannums1043803stannums
startup934963startup
stoup75517073s_toup
sunn45423593sunn__
sunna55016063sunn_a
sunnah9369353sunnah
sunnas63914563sunnas
sunned74216323sunned
sunns55017353sunn_s
sunny84917743sunn_y
sunups837263s_unups
sup57041943s___up
swanned11358173swanned
swanny12336823swann_y
syrup103010963s_yrup
takeup1234583takeup
tanned75219953tanned
tanner63722283tanner
tannic82811473tannic
tannin62613923tannin
tannoy958353tannoy
tuneup835203tuneup
turnup835093turnup
vanned104614483vanned
vanner94215843vanner
walkup1534193walkup
walnut939433walnut
wangun1037103wangun
wanned104318013wanned
wanner94019623wanner
warmup1335343warmup
washup1435323washup
windup1235383windup
yanqui1843383yanqui
yaup96618483ya__up

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162265.17321789.3
3Display Results2262260.0633587.3
 (SQL Overall)1786912265.60931857.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.