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

282 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
cotype134682(None) 
cotypes1437941cotypes
ecotype1444841ecotype
biotype1444422biotype
calotype1544322calotype
cerotype1544652cerotype
cope86847382co__pe
cote66648732cot__e
cottae84615702cottae
coupe96023482co_upe
coypu12349872co_ypu
ecotypes1545052ecotypes
ectype1334282ectype
isotype12224952isotype
neotype1244592neotype
retype11399142retype
type96223742__type
acolyte12157653acolyte
allotype1344823allotype
autotype1375873autotype
biotope1146623biotope
biotypes1544683biotypes
blype12429673_blype
bottle84916073bottle
calotypes1644423calotypes
canape10913513canape
cape87242783c__ape
cate66254603cat__e
cattie85221023cattie
cattle85118903cattle
cepe84926653c__epe
cerotypes1644733cerotypes
cetane8315283cetane
cete64934783cet__e
chape125221143c_hape
chyle134913483c_hyle
chyme156512503c_hyme
cite65640343cit__e
citole8311503citole
city95122623city__
clepe94617383c_lepe
clothe114712993clot_he
cloture9238453cloture
clypei1334163c_lypei
coapt96131533co_apt
coarse84813903coarse
coatee84327223coatee
cobble123615263cobble
coble94823173co_ble
cockle143913573cockle
coddle104713853coddle
code77347733co__de
coempt12311033coempt
coerce10310403coerce
coffee144113743coffee
coffle14359043coffle
cohere112716993cohere
cohune1189423cohune
coiffe1447043coiffe
coigne94612193coigne
coke107038383co__ke
coky137526823coky__
cole66956113co__le
collie83621993collie
collotype1643383collotype
colone85425003colone
colure8314163colure
coly96940533coly__
comade114415323comade
comae97128423co_mae
comake144413423comake
comate104124843comate
combe116223543co_mbe
come87547703co__me
commie124215523commie
comose105016843comose
comp106731253co_mp_
comped135919873co_mped
compel124412893co_mpel
compo115318573co_mpo
comps115526053co_mps
compt116328223co_mpt
comte96125473co_mte
condyle13247053condyle
cone67256963co__ne
conge85227593co_nge
congee96024473congee
conine84528553conine
conte76633203co_nte
contuse9311413contuse
cony96537833cony__
cooee74531023co_oee
cookie123716043cookie
coolie83821603coolie
coombe124110093coombe
coop87238653co_op_
cooped114821603co_oped
cooper104221123co_oper
coops96229643co_ops
coopt95929853co_opt
cootie84223093cootie
cop711162373co__p_
coped105036843co__ped
copen94826433co__pen
coper95336093co__per
copes97747103co__pes
copped135221253co_pped
copper124321893co_pper
cops86751373co__ps
copse95623923co_pse
copy116229803co__py
corbie103618203corbie
core67263113co__re
corps95927043co_rps
corpse104013403corpse
corrie83621223corrie
corse75036183co_rse
cortege1098953cortege
corvee114320093corvee
cory96941513cory__
corymb1535223corymb
coryphee1874033coryphee
coryza2074583coryza
cosie74728263co_sie
cosine83823513cosine
costae85319683costae
costate94019273costate
costive12312843costive
costume1157853costume
cosy97232703cosy__
cot510483223cot___
cotan71521783cot_an
cotans81317923cotans
coteau8311083coteau
coted85033853cot_ed
coterie9417403coterie
cotes76347843cot_es
coting94629253coting
cots68054843cot__s
cotta75818573cot_ta
cottage104210573cottage
cottar84613813cottar
cottas84615573cottas
cotter84926673cotter
cottier93814173cottier
cotton8312993cotton
coude85022633co_ude
coulee8323513coulee
coup86729793co_up_
couped115019313co_uped
coupes105022523co_upes
couple104415963couple
coups95522473co_ups
course85117783course
couthie121810553couthie
couture9310623couture
cove95837073co__ve
cowage12310673cowage
cowpea1337643co_wpea
cowpie133511513cowpie
cowrie113814283cowrie
cowy126427363cowy__
coxae146115183co_xae
coy810557553co_y__
coyed114623803co_yed
coyer105222843co_yer
coyly135614893co_yly
coyote11411783coyote
coypou13268403co_ypou
coypus13389303co_ypus
coys97537243co_y_s
cozie163519133co_zie
cozy185823803cozy__
crape96128443c_rape
crepe95520723c_repe
cripe95521143c_ripe
croupe105114433croupe
crypt123715233c_rypt
cute66440453cut__e
cutie76925933cut_ie
cuttle84113893cuttle
cutup9410093cutup_
cutups1036813cutups
cyanotype1952573cyanotype
cyme119420373c__yme
dope76038893do__pe
dotage82711613dotage
dote55442883dot__e
dottle74212503dottle
doty86128223doty__
ecotage1036883ecotage
ecotone938583ecotone
ecotypic1744413ecotypic
ectypes1434803ectypes
etape74413703_etape
genotype1444483genotype
holotype1644883holotype
hope96639673ho__pe
hottie92514383hottie
hoyle11314413ho_yle
hype125519813__hype
idiotype1442963idiotype
isotope9227783isotope
isotypes13234853isotypes
lectotype1653453lectotype
linotype1343963linotype
logotype1443393logotype
lope65941923lo__pe
lotte54923853lot_te
loupe75319513lo_upe
metope10611123metope
mistype14126523mistype
monotype1545783monotype
mope86838043mo__pe
mote67048083mot__e
motile83818343motile
motive113112143motive
motte75526973mot_te
mottle84116053mottle
neotypes1344523neotypes
nope65934193no__pe
notate63217863notate
note46239963not__e
notice8313443notice
octane81411633octane
octave11157343octave
octopi1036533octopi
octuple1153993octuple
octyl10136063octy_l
octyls11135323octyls
odyle9349593_odyle
oocyte1135753oocyte
ope56845243_o__pe
polyp125611533polyp_
polyped1537173polyped
polypi13458593polypi
polyps13479763polyps
polytype1844753polytype
pope85535613po__pe
potage92715903potage
potpie103412433potpie
potsie83916033potsie
pottle84416103pottle
pretype14387483pretype
protyle12229453protyle
retape83917683retape
retyped13367303retyped
retypes12308623retypes
rope65542913ro__pe
rotate63320343rotate
rotche114311983rotche
rote46249023rot__e
rotte54625933rot_te
scope94821483sco__pe
scottie937463scottie
serotype1345163serotype
slype105112363_slype
stipe76523373_stipe
stope74727243_stope
stupe75217753_stupe
stye76218973_sty_e
style85519363_style
subtype1444203subtype
tape64538143__tape
tintype1243033tintype
tope65946383__tope
topotype1543903topotype
tote46643673tot__e
tye65837443__ty_e
tyee75131423__tyee
tyke115720503__tyke
tyne76325053__tyne
typed115815453__typed
types105721063__types
typey135511883__typey
typo95418123__typo
typp115812783__typp
typy126013043__typy
tyre75428253__tyre
vote74728623vot__e
votive12348933votive
watape11208483watape

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 Limit1127162825.48620546.1
3Display Results2822820.0933032.3
 (SQL Overall)1786912825.95230022.0
 
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.