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

413 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
subnets9251208(None) 
sublets92616701sublets
subnet82520931subnet_
subsets92813101subsets
burnets93813262burnets
gurnets84010792gurnets
lunets66914762lu_nets
punnets9409262punnets
sennets73712582sennets
signets83311502signets
snubness1044372snubness
sonnets74211992sonnets
spinets94714812spinets
subdebs1236482subdebs
subers85722642sub_ers
subjects19226532subjects
sublet82827242sublet_
sublots92410912sublots
submits1139742submits
subrents10310292subrents
subsects12267902subsects
subset83122582subset_
subtest9513962subtest
subtests1037532subtests
subtexts1744902subtexts
subunits1046612subunits
subverts1336972subverts
suets55126102su__ets
suints64617782suin_ts
sunbelts1044672sunbelts
sunkets113511282sunkets
sunsets72911572sunsets
abets75621673_ab_ets
auklets11298573auklets
aunts55227633au_n_ts
bannets94013843bannets
beets76131443__beets
bennets94712163bennets
bents76033693__bents
bets67051443__b_ets
blets75324943__blets
bonnets94812803bonnets
brunets9419553brunets
bubkes144612623bubke_s
buboes104513993buboe_s
buckets153811693buckets
budgets11489863budgets
buffets15317593buffets
bulblets1255353bulblets
bullets93516393bullets
bundts95010843bu_ndts
bunts75729803bu_n_ts
burets84321263bu_rets
burners94115673burners
burnet84326173burnet_
cabinets1238283cabinets
cablets114216343cablets
carnets93918403carnets
cobnuts1135343cobnuts
cornets94820573cornets
cubebs12508673cub_ebs
cubers105318343cub_ers
cubes95028163cub_e_s
cubists11359023cubists
cubits103714023cub_its
culets85518513cu_lets
cullets94015613cullets
cunners93913463cunners
cunts76125123cu_n_ts
curets84922343cu_rets
curvets12399913curvets
cutlets94113653cutlets
cygnets1333813cygnets
dipnets10109033dipnets
doublets11257363doublets
dubbers124011823dubbers
dubiety1344583dubiety
dubonnets1242133dubonnets
dueness82310123dueness
duets65323883du__ets
dulcets1046283dulcets
dulness8307983dulness
dumbness1334613dumbness
dunes65332173du_ne_s
dunness8298983dunness
dunnest83312263dunnest
dunts65828413du_n_ts
duvets1039223du_vets
ebbets10376833_ebbets
eupneas935233eupneas
fulness10248963fulness
fumets114311813fu_mets
funest94316863fu_nest
funnels10348173funnels
funnest102912003funnest
gannets83811443gannets
garnets84115403garnets
genets75716663_genets
gibbets12417723gibbets
giblets103210423giblets
gobbets12327643gobbets
goblets103210183goblets
guglets9369693guglets
guineas836743guineas
gullets84013713gullets
gunnels8358563gunnels
gunners83111723gunners
gurnet74920873gurnet_
gurneys11406463gurneys
gussets837443gussets
hornets104113553hornets
hunts86826173hu_n_ts
jennets14517633jennets
jubes145420743jub_e_s
junkets18377623junkets
labrets939363labrets
linnets739823linnets
lubbers113913723lubbers
lubes74727993lub_e_s
lunes55337773lu_ne_s
lunet56835423lu_net_
lunts55826903lu_n_ts
magnets10311143magnets
mullets93614783mullets
muskets13258633muskets
nets45941533___nets
nonets64118703_nonets
nuggets936383nuggets
numbness1234413numbness
nutlets74111253nutlets
objets15125323_objets
outlets73616363outlets
outsets73514923outsets
planets93914083planets
pubes94423403pub_e_s
pullets94015163pullets
punners94114233punners
punnet83518843punnet_
punts75828003pu_n_ts
puppets10317013puppets
quants153614143quan_ts
qubits173710343qub_its
qubytes2134383qubytes
quiets154014373qu_iets
quintes164114713quintes
quintets17347203quintets
quints154316563quin_ts
rabbets11279423rabbets
rennets75212633rennets
riblets93412553riblets
rubbers113913183rubbers
rubels84112993rub_els
rubes74928413rub_e_s
rubies84420333rubie_s
rubiest92914423rubiest
rubles83921703ruble_s
rubouts937973rubouts
ruiners74213023ruiners
runes55530223ru_ne_s
runlets73310773runlets
runnels7329153runnels
runners74212453runners
runts55927633ru_n_ts
russets738163russets
sabbats1138633sabbats
sabers85224733sab_ers
sabes76437463sab_e_s
sabines94318483sabine_s
sables85026693sable_s
sabots8314693sab_ots
sabres85520863sabre_s
sachets123914103sachets
sadness8310613sadness
saints65122423sain_ts
sallets73719653sallets
samlets93813553samlets
sanes55649073s_ane_s
sanest64426693s_anest
sarsnets836783sarsnets
satinets8311733satinets
sawneys13274643sawneys
scants85219723scan_ts
scenes84520353scene_s
scents85317023scen_ts
scones84521303scone_s
scunners10357303scunners
secrets9311773secrets
seiners74219273seiners
seines65029903seine_s
sennet64224143sennet_
sennits73811283sennits
septets998953septets
sestets7911473sestets
sets45549503s___ets
sextets1497143sextets
sheets93918493s_heets
shiners104015943shiners
shines95028913shine_s
shunners11317743shunners
shunts95712013shun_ts
shyness1344993shyness
signees83510803signees
signers84714423signers
signet73621153signet_
silents73514493silents
simnels976103simnels
sines55954823s_ine_s
sinews94210623s_inews
sinners74019013sinners
sippets113310173sippets
skeets104513253s_keets
skenes104616633skene_s
sklents11348163sklents
slants64819083slan_ts
sleets64318873s_leets
slubbers12349943slubbers
slyness1035263slyness
smugness1143813smugness
sneds65715353s__neds
snits54124833s__nits
snots55225103s__nots
snubbers12326673snubbers
snugness934323snugness
sobbers114114253sobbers
sobers85218853sob_ers
sockets134012983sockets
solonets838233solonets
sones55444143s_one_s
sonnet65923503sonnet_
sooners73916643sooners
soonest7415593soonest
sorbents10279123sorbents
sorbets93012503sorbets
sorners73416863sorners
sourness839543sourness
soviets1087293soviets
spinels94512443spinels
spines85132033spine_s
spinet85629753spinet_
splents93912133splents
spurners10288493spurners
squints16339033squin_ts
stanes64933403stane_s
starets73515923starets
stents65019453sten_ts
stets55423913s__tets
stints65119763stin_ts
stoners74817953stoners
stones65130033stone_s
streets73312613streets
students954683students
stunners8277923stunners
stunts65615253stun_ts
stylets10369213stylets
suavest10310623suavest
subagents1245003subagents
subahs114512383sub_ahs
subareas1038623subareas
subas74724073sub__as
subbass1138033subbass
subbed114116673subbe_d
subcell1146743subcell
subcells1246273subcells
subcults1246923subcults
subcutes1238573subcutes
subcutis1246283subcutis
subdean1037403subdean
subdeans1137203subdeans
subdeb1137523subde_b
subdepots1443163subdepots
subducts13106093subducts
subduers1186353subduers
subdues1099883subdues
subedits1146713subedits
subentry1344693subentry
suber74924503sub_e_r
subgenus1145753subgenus
subgums1235893subgums
subhead1387693subhead
subheads1496533subheads
subideas1146443subideas
subitem1138543subitem
subitems1245493subitems
subito8410443sub_ito
subject18258633subject
sublate9315363sublate
sublates10315003sublates
sublease1038383sublease
sublines10315783subline_s
sublot82315523sublot_
submenu1148363submenu
submenus1245903submenus
submerse1237633submerse
submiss1138083submiss
submit10312673submit_
suborners1146313suborners
suborns939483suborns
subpanels1344393subpanels
subparts1246903subparts
subpena1136673subpena
subpenas1246903subpenas
subplots1255773subplots
subrent9315083subrent
subs66037123sub___s
subsea82610193subse_a
subsect112611843subsect
subsense1046963subsense
subsere9311443subsere
subseres10312423subseres
subsist9311573subsist
subsists1037993subsists
subsite9412863subsite
subsites10312763subsites
subteen938523subteen
subteens1037423subteens
subtend1037103subtend
subtends1136173subtends
subtext1647653subtext
subtlest10511353subtlest
subtlety1345063subtlety
subtones10311373subtone_s
subunit948943subunit_
suburbs1136503suburbs
subvene1238493subvene
subvenes1339633subvenes
subvert12312893subvert
subways1536163subways
subzero1835613subzero
subzones1947213subzone_s
success1146403success
suchness1335763suchness
suckers133717623suckers
sucres84218893sucre_s
suddens9308783suddens
sudsers83310413sudsers
sudses74114503sudse_s
suedes73918113suede_s
suers55128483su__ers
sues46247653su__e_s
suet46754823su__et_
suety85318493su__ety
suffers133113543suffers
suggest9310863suggest
suggests1044713suggests
suint55638183suin_t_
suiters73618873suiters
suites63727403suite_s
suits55028053su__its
sulkers113613343sulkers
sumless92611123sumless
summers113616503summers
summits1137973summits
sunbath1236423sunbath
sunbaths1344383sunbaths
sunbeam1146053sunbeam
sunbeams1243963sunbeams
sunbelt939233sunbelt
sunbonnets1252433sunbonnets
sunbows1236023sunbows
sunders84120053sunders
sundews11398153sundews
sunket103721363sunket_
sunless73013693sunless
sunnahs10326593sunnahs
sunnas63914563su_nnas
sunned74216323sunne_d
sunniest82712903sunniest
sunns55017353su_n_ns
suns45841903su_n__s
sunset63723633sunset_
sunups837263su_nups
supers84622403su_pers
supes75628303su_pe_s
supines94216383supine_s
suppers113314693suppers
sureness8912903sureness
surest65026763su_rest
surety93515003su_rety
surfeits1146223surfeits
surfers103614133surfers
surgers83517483surgers
surges73924593surge_s
surreys10489433surreys
surveys13357573surveys
suspects1254863suspects
susses64221053susse_s
sutlers73116973sutlers
suttees74114063suttees
sweets94214433s_weets
swivets13436963swivets
syboes1139343syboe_s
syndets1136113syndets
tablets94714373tablets
telnets738373telnets
tenets65518953_tenets
tubbers113411243tubbers
tubers85017023tub_ers
tubes74826453tub_e_s
tubists9288323tubists
tuckets134810333tuckets
tuffets13266523tuffets
tuners64417343tu_ners
tunes55332193tu_ne_s
tunnels7328723tunnels
turners73912893turners
turrets73010673turrets
ubiety1135913_ubiety
unbelts9237663_unbelts
units54923433_u_nits
unsets64116163_unsets
upsets8409683_upsets
usneas638333_usneas
zibets1737743zib_ets

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.1401276364.3
2DLD Change Limit1340274137.51617832.2
3Display Results4134130.2201877.3
 (SQL Overall)1786914137.87622688.0
 
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.