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

203 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
cobnuts113535(None) 
cobnut10311321cobnut_
cobalts1139202cobalts
coconuts1246332coconuts
conus76726532co_nu_s
copouts11311082copouts
cornets94820572cornets
cornus84816562cornu_s
cornute939642cornute
cornuto937032cornuto
cornutos1046052cornutos
counts84618272coun_ts
donuts7410582do_nuts
hognuts1134182hognuts
abuts75417073_ab_uts
bhuts105812953__bhuts
bobcats1335993bobcats
bonnets94812803bonnets
bonus75324323bo_nu_s
bouts75131313__bouts
bruts75922953__bruts
bunts75729803__bunts
buts67247693__b_uts
cabinets1238283cabinets
cablets114216343cablets
cants77036943c_an_ts
cantus85117763c_antus
carnets93918403carnets
catguts1045323catguts
cents74730333c_en_ts
chants115020393chan_ts
chaunts1267083chaunts
chints115117833chin_ts
clonus85212413clonu_s
clouts87017203c_louts
coacts105314333co_acts
coapts104614013co_apts
coasts85719143co_asts
coats75635003co__ats
cobalt10317393cobalt_
cobbers134114753cobbers
cobbles133814823cobbles
cobbs115013993cob__bs
cobias104014993cob_ias
cobles104622883cob_les
cobras104014193cob_ras
cobs87043143cob___s
cobwebs1631933cobwebs
coccus979283coccu_s
cockups1735223cockups
cocoanuts1343193cocoanuts
coconut11511473coconut_
coedits10310243coedits
coempts1335683coempts
coenacts1246403coenacts
coenure968153coenure
coenures1048683coenures
coenuri945463coenuri
coenurus1044133coenurus
cognacs1256043cognacs
cognate10312203cognate
cognates11311583cognates
cohorts123411103cohorts
cohosts12398813cohosts
cohunes1249713cohunes
coiners93620753coiners
coins75834553coin__s
coitus8511893coitu_s
coleus86818273coleu_s
collets93517903collets
colonus94413443colonu_s
colours95913443colours
colts76633293co__lts
combats13311683combats
combust1338363combust
combusts1445503combusts
comets105823583co_mets
comfits14328743comfits
commits133812383commits
commute134310443commute
commutes143011893commutes
comous10816513comou_s
compts125216653co_mpts
compute134513663compute
computes143914553computes
conatus9310463co_natus
conchs134714903co_nchs
concurs11311473concurs
concuss1138063concuss
condos94322333co_ndos
conducts13118713conducts
conduits111210063conduits
cones76457423co_n_es
coneys115218423co_neys
confits122811423confits
confute1239263confute
confutes1339843confutes
congas94417033co_ngas
conges94928173co_nges
congos94219883co_ngos
conics103920593co_nics
conies84338593co_nies
conins84327233co_nins
coniums11311863coniums
conks115525703co_n_ks
connate9315753connate
connects123010563connects
conners94023113conners
connote9311613connote
connotes10311453connotes
conns75024233co_n_ns
cons66057693co_n__s
consuls92412323consuls
consults10219983consults
conte76633203co_n_te
contes84432913co_ntes
conto76027173co_n_to
contos84923233co_ntos
contuse9311413co_ntuse
cookouts1446003cookouts
coons76737283coon__s
coopts105814583co_opts
coots75636843co__ots
coplots11511593coplots
copout10418783copout_
coquets18399893coquets
corneas94717003corneas
cornels94716663cornels
corners94723313corners
cornet84436733cornet_
corns76034763corn__s
cornu75921323cornu__
cornua85411903cornu_a
cornual94210173cornual
cornuses10310033cornuses
cornuted1137473cornuted
coronets103814363coronets
corpus106015293corpu_s
corrupts1244983corrupts
corsets94819803corsets
corvets124715023corvets
cosets85824403co_sets
cossets95014283cossets
costs77231143co__sts
cots68054843co___ts
count74932053coun_t_
county114313323coun_ty
coups95522473co__ups
courts84216173co_urts
couth106122493co__uth
couths115715413co__uths
coverts124813813coverts
covets114819643co_vets
cowpats1437713cowpats
coyness1277323coyness
coypus13389303coypu_s
crinums1135863crinums
crownets13407673crownets
cubists11359023cubists
cubits103714033cub_its
cubitus11346783cubitus
cunts76125123c_un_ts
cutouts938033cutouts
cuts65841153c___uts
cygnets1333813cygnets
debuts93911753deb_uts
donut6324513do_nut_
fonts86124753fo_n_ts
founts94313383foun_ts
gobbets12327643gobbets
goblets103210183goblets
gouts64826173go__uts
hobbits14317553hobbits
hobnobs1443603hobnobs
hognut1039413hognut_
hornets104113553hornets
joints133811453join_ts
locknuts1443683locknuts
louts56330273lo__uts
mounts84115073moun_ts
nonets64118703no_nets
nuts45032673___nuts
obits74617553_ob_its
objets15125323_objets
onus45826813_o_nu_s
outs45746963_o__uts
peanuts936993peanuts
pignuts1035613pignuts
points85618533poin_ts
pouts75530323po__uts
rebuts84015193reb_uts
robots8313153rob_ots
robust8310433rob_ust
rotguts833763rotguts
routs57133413ro__uts
rubouts937983rubouts
scouts84817943sco__uts
sonnets74211993sonnets
subnets92512083subnets
tonus56324303to_nu_s
touts54830393to__uts
walnuts1033843walnuts
wonts87621543wo_n_ts

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.406440125.6
2DLD Change Limit1340272037.23618522.2
3Display Results2032030.0603383.3
 (SQL Overall)1786912037.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.