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

202 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
coccous103899(None) 
coccus979281cocc_us
cachous14312562cachous
coccids11277212coccids
coccoid11299282coccoid
coccoids12176792coccoids
cocoas104915742co_coas
cocoons11310562cocoons
cocos95624692co_co_s
comous10816502co_mous
concours1239432concours
congous103615082congous
copious11311962copious
cormous11312352cormous
couscous1246662couscous
coypous14248812coypous
nocuous946582nocuous
acoelous1047023acoelous
bocces123912023bocc_es
boccias13307193boccias
boccies133311513boccies
boccis123911133bocc_is
boocoos1137753boocoos
boubous1138683boubous
cacaos104616183cacao_s
cachou13310613cachou_
cactus104912233c_actus
caducous1344363caducous
callous93516593callous
carious93320283carious
caseous9312513caseous
caucus1039603cauc_us
cercus105013153cerc_us
cerous85821203c_erous
chicos134614833chico_s
chylous15107263chylous
chymous1775693chymous
circus104310593circ_us
cirrous93111063cirrous
ciscoes113610733ciscoes
ciscos104711133cisco_s
citrous93112983citrous
coaches144018693coaches
coactors1239453coactors
coacts105314323coac_ts
cocains111313923cocains
cocas95926573co_c_as
coccal9310223cocc_al
cocci82812673cocc__i
coccic8298943cocc_ic
coccid102910743cocc_id
coccyges1542333coccyges
coccyx1942663cocc_yx
coccyxes2142013coccyxes
cochins141413093cochins
cockcrows1942903cockcrows
cockers153618333cockers
cockles153414643cockles
cocks135227163co_c_ks
cockup1635713co_ckup
cockups1735223cockups
coco87330603co_co__
cocoa98517883co_co_a
coconut11511463coconut
coconuts1246323coconuts
cocoon10312263co_coon
codons96119463co_dons
coeloms1139063coeloms
cogons96818113co_gons
cohogs125810273co_hogs
cohos105921853co_ho_s
coitus8511893co_itus
coleus86818273co_leus
collops112611753collops
colobus11389373colobus
cologs96517353co_logs
colons86028683co_lons
colonus94413443colonus
colors86622373co_lors
colour85915083co_lour
colours95913413co_lours
combos125316613combo_s
commons13311043commons
compos124818803compo_s
conatus9310463conatus
conchas144013313conchas
conches144019813conches
conchos144313953conchos
conchs134714903conc_hs
concoct10312903concoct
concocts1138633concocts
concord12510343concord
concords1358593concords
concourse1345793concourse
concur10411093conc_ur
concurs11311453concurs
concuss1138063concuss
condoes104319203condoes
condoms124214083condoms
condors104018553condors
condos94322333condo_s
congius103210073congius
congoes103617303congoes
congos94219883congo_s
congou94313243congou_
conscious1347573conscious
consols92914073consols
contos84923233conto_s
contour939963contour
contours1039613contours
conus76726533co__nus
convoys15267023convoys
cooches143515833cooches
coocoo1069693cooco_o
coofs105924713co__ofs
cookout13410143cookout
cookouts1445993cookouts
cooks115429143co__oks
cools75632633co__ols
coons76737283co__ons
coops96229643co__ops
coos67456493co__o_s
coots75636843co__ots
coplots11511593coplots
copout10418773co_pout
copouts11311073co_pouts
cordons104415763cordons
corncobs1444723corncobs
corneous10310033corneous
cornus84816563co_rnus
corpus106015293co_rpus
cosmos10311753cosmo_s
cottons9312193cottons
couches144020463couches
coupons112710553coupons
covetous1347093covetous
cowboys1735253cowboys
coxcomb2243293coxcomb
coxcombs2342353coxcombs
coydogs1434493coydogs
coypou13268403coypou_
coypus13389303co_ypus
crocus104813173croc_us
croupous1245903croupous
cuckoos1585123cuckoos
cuprous1149743cuprous
curious93813563curious
cuscus1038113cusc_us
cyclops1635383cyclops
cyclos1338073cyclo_s
cymous1388403c_ymous
dioicous1145133dioicous
doctors1039983doctors
floccus1443653flocc_us
focus105815883fo_c_us
folious103710733folious
fucous11399863_fucous
fuscous1256673fuscous
hocus104715203ho_c_us
iodous7311493io_dous
jockos19527563jocko_s
joyous16276763jo_yous
lockout1359333lockout
lockouts1445493lockouts
locoes85516583lo_coes
locos75822603lo_co_s
loculus9296973loculus
locus74819993lo_c_us
mucous104411653_mucous
nodous7711323no_dous
noncoms1139183noncoms
noxious1446553noxious
occur9137323_occ_ur
occurs10136553_occurs
ochrous1237933ochrous
octopus1144803_octopus
oculus8178393_oculus
odious749933_odious
osmous8138183_osmous
piceous11310693piceous
poaceous1267173poaceous
pompous1338063pompous
porous84419483po_rous
poyous112911623po_yous
raucous938283raucous
rococos1145903rococos
roscoes9310923roscoes
sarcous9312933sarcous
seccos1039923secco_s
soccers1138393soccers
soukous1136403soukous
succors1137413succors
succour1144693succour
succours1244583succours
talcous939483talcous
tomcods1234873tomcods
torous64319023to_rous
vacuous1237023vacuous
vicious1239493vicious
viscous1238833viscous
vodous1038593vo_dous
zincous1837053zincous

Search took 7 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.1561145455.1
2DLD Change Limit1340272026.59320328.7
3Display Results2022020.0633206.3
 (SQL Overall)1786912026.81226231.8
 
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.