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

216 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
cobnut1031132(None) 
cobnuts1135351cobnuts
cobalt10317392cobalt
coconut11511472coconut
conus76726532co_nus
copout10418782copout
cornet84436732cornet
cornu75921322cornu_
cornua85411902cornua
cornus84816562cornus
cornute939642cornute
cornuto937032cornuto
count74932052coun_t
donut6324512do_nut
hognut1039412hognut
about75229083_about
abut66834953_ab_ut
bhut95425713__bhut
bobcat12411253bobcat
bonnet85524633bonnet
bonus75324323bo_nus
bout66353293__bout
brut66537963__brut
bunt65850853__bunt
but55963023__b_ut
cabinet11318903cabinet
cablet104429463cablet
cannot83616773cannot
canst74932213c_anst
cant66362033c_an_t
caput9823983c_aput
carnet84732873carnet
catgut9310803catgut
cent67451013c_en_t
centu76119413c_entu
chant105932693chan_t
chaunt11613493chaunt
clonus85212413clonus
clout75330463c_lout
coact96130583co_act
coapt96131533co_apt
coast75236273co_ast
coat67558353co__at
cob710258753cob___
cobalts1139203cobalts
cobb106422003cob__b
cobber124116843cobber
cobble123615263cobble
cobbs115013993cob_bs
cobby145516413cob_by
cobia94117513cob_ia
cobias104014993cobias
coble94823173cob_le
cobles104622883cobles
cobra95214403cob_ra
cobras104014193cobras
cobs87043143cob__s
cobweb1533243cobweb
coccus979283coccus
cockup1635713cockup
cocoanut1246903cocoanut
coconuts1246333coconuts
coedit9316243coedit
coempt12311033coempt
coenact11311803coenact
coenure968153coenure
coenuri945453coenuri
coft97939683co__ft
cogent9321003cogent
cognac1157273cognac
cognate10312203cognate
cohort1110720263cohort
cohost115217213cohost
cohune1189423cohune
coin66645353coin__
coined94523603coined
coiner84323783coiner
coins75834553coin_s
coitus8511893coitus
coleus86818273coleus
collet84030363collet
colonus94413443colonus
colour85915093colour
colt67158243co__lt
combat12316753combat
combust1338363combust
comet95946073co_met
comfit133112423comfit
commit124016703commit
commute134310443commute
comous10816503comous
compt116328223co_mpt
compute134513663compute
con510268023co_n__
conch124620073co_nch
concur10411103concur
condo85322593co_ndo
conduct121411593conduct
conduit10713083conduit
cone67256963co_n_e
coned86040053co_ned
cones76457423co_nes
coney105932883co_ney
confit113316403confit
confute1239263confute
conga85419873co_nga
conge85227593co_nge
congo85623133co_ngo
coni65534803co_n_i
conic95329793co_nic
conin76232723co_nin
conium10415313conium
conk106531443co_n_k
conks115525703co_nks
conky145818743co_nky
conn66229133co_n_n
connate9315753connate
connect113515743connect
conned95119703conned
conner84423963conner
connote9311613connote
conns75024233co_nns
cons66057693co_n_s
consul82312303consul
consult92513633consult
conte76633203co_nte
conto76027173co_nto
cony96537833co_n_y
cookout13410153cookout
coon67248943coon__
coons76737283coon_s
coopt95929853co_opt
coot67860383co__ot
coplot10518273coplot
copouts11311083copouts
coquet174318013coquet
corium10315723corium
corn69945813corn__
cornea84018923cornea
corned95224523corned
cornel84020053cornel
corner84625623corner
cornets94820573cornets
corns76034763corn_s
cornual94210173cornual
cornuted1137473cornuted
cornutos1046053cornutos
corny106023273corn_y
coronet94227173coronet
corpus106015293corpus
corrupt1149103corrupt
corset85636223corset
corvet114626933corvet
coset75748843co_set
cosset84125863cosset
cost68057943co__st
cot510483223co___t
counts84618273counts
county114313323county
coup86729793co__up
court75532773co_urt
couth106122493co__uth
covert114925503covert
covet105638943co_vet
cowpat13312033cowpat
coyest11316053coyest
coypu12349873coypu_
coypus13389303coypus
crinum1039333crinum
crownet123714113crownet
cubist104214443cubist
cubit94122893cub_it
cunt66243673c_un_t
cut57957663c___ut
cutout8315923cutout
cygnet1237893cygnet
debut86024143deb_ut
donuts7410583do_nuts
font77143753fo_n_t
fount84727033foun_t
gobbet114214443gobbet
goblet93219483goblet
gout56646003go__ut
hobbit132810543hobbit
hobnob1335133hobnob
hognuts1134183hognuts
hornet94926433hornet
joint125227723join_t
locknut1345253locknut
lout45952143lo__ut
mount74128063moun_t
nonet54540843no_net
nut36651963___nut
obit66837083_ob_it
objet141213143_objet
onus45826813_o_nus
out38072153_o__ut
peanut8318183peanut
pignut9311573pignut
point75338733poin_t
pout65752553po__ut
rebut75927383reb_ut
robot7325973rob_ot
robust8310433robust
rotgut738793rotgut
rout46153283ro__ut
rubout8313563rubout
scout75031453sco__ut
sobeit8315363sobeit
sobful1136333sobful
sonnet65923503sonnet
subnet82520933subnet
tonus56324303to_nus
tout46753823to__ut
walnut939433walnut
wont75842503wo_n_t

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.1261418182.5
2DLD Change Limit1127162165.43620735.1
3Display Results2162160.0802700.0
 (SQL Overall)1786912165.64231671.6
 
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.